Tag | SQL Server 2008 Posts

Well I like to look at pretty pictures on deployment days to keep my mind on the good side of software. Well I guess it is not that bad, but today we moved Geekswithblogs.net to a new server pool to update hardware, get some extra machines in the mix, and move to SQL Server 2008 R2. If you see any issues, please alert us directly via comments or support@geekswithblogs.com. Thanks and hopefully we will see more benefits that issues. Technorati Tags: Geekswithblogs.net ...
If you are installing SharePoint 2010 on a new box you might see the Setup Errors notification from the installer. In my case, I am using Windows Server 2008 R2, but I have seen the similar Error on Windows 7 as well with little less requirements. As you can understand all the “-“ bullets are the requirements that needs to be installed or configured on the box. There are two ways to do this 1) Microsoft SharePoint 2010 Product Preparation tool In the SharePoint 2010 Splash Form, you can find that ...
In my attempt of installing and configuring SharePoint 2010 Farm, I have given a new Windows Server 2008 R2 box that should have SQL Server 2008. So when I attempt to install SQL Server 2008 on it, I came across the following error message. Not so weird because every server product have a set of requirement to be installed. First off, before you do any thing Just run the Windows Update. That’s recommended because there can be some thing else that is not mention in this post or any other but can hanged ...
Some Background The AdventureWorks database has been around for over a decade; a staple amongst sample databases. The first version of the AdventureWorks database appeared in time for SQL Server 2000. Microsoft has been good at keeping the AdventureWorks sample database up to date as new versions of SQL Server are released. Case-in-point: SQL Server 2012 is at RC0 and yet you can already find a version of AdventureWorks for it (albeit, it really isn’t that different from the SQL Server 2008 R2 version). ...
Environment what we are building consists of: Operating System: Windows Server 2008 SP2. Database Server: SQL Server 2008 with SP2. PeopleSoft Application: PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 PeopleTools: PeopleSoft PeopleTools 8.52 Web Server: Oracle Web Logic Server 10.3.4 The machine name given for this environment is WIN2K8 and currently only 1 user, the default username is Administrator and it is the local admin. The below steps are performed with ...
This post is an example of how to write a WCF Service using a class. The example uses Visual Studio 2010, written in C#, SQL Server 2008 and hosted in IIS. So lets have at it. The table is pretty simple just three columns, an TestID (int), Value1 (varchar(50)) and Value2 (varchar(50)). The stored procedure used will return one record from the table using the TestID as a parameter. Table SQL: CREATE TABLE [dbo].[Table_1]( [TestID] [int] IDENTITY(1,1) NOT NULL, [Value1] [varchar](50) NOT NULL, [Value2] ...
This is a strangest error I have come across whilst working with SharePoint 2010, the full error is this. [12/20/2011 5:29:10 PM] Warning: [WSS_Content] The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier. RESTORE DATABASE is terminating abnormally. The error message was written to the file restore.log found in the SharePoint backup folder, it seems that the following keyword in TSQL caused the error. IF EXISTS ( SELECT * FROM master..sysdatabases ...
UPDATED March 24th 2016: Test Data Retention is now added to TFS 2015 Update 1, see this post for more information.UPDATED Apr 15th 2013: Corrected to VS2012 Update 2 UPDATED Mar 23rd 2012: Added information about VS 11 UPDATED Mar 21st 2012: Added info and link to VS/TFS 11 tool for getting the Test Attachment Cleaner, now included with the TFS Power Tools UPDATED Mar 17th 2012: Added sql queries for TFS 11 Beta. Changed structure after Adam’s advices. Updated information. UPDATED Jan 9th 2012: ...
Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} My friend asked me where to ...
In SQL Server 2008 you can use table valued parameters which can be pretty useful. In the example I use a very simple one to overcome SQL Server’s lack of having a parameter as an array. The example goes through creating the new type, using it in a stored procedure and calling it from an application (VB.Net in this example). You start off with creating the new type. Under Programmability/Types/User-... Table Types create a new table. Here I created a table with a single column to hold an integer. ...
Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; ...
Once the installer for the AdventureWorks Community Sample Database has finished, we then need to complete the process (not mandatory, but nice to do to play with the OLAP content). The first thing we need to do is make sure we note the location of the script files and samples. The path if you are working with SQL Server 2008 R2 is as follows: “C:\Program Files\Microsoft SQL Server\100\Tools\Samples\Ad... 2008R2 Analysis Services Project\enterprise” I am working with the developer edition, ...
BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple stored procedure calls A recent project that I was working on required that I take an incoming flat file, containing multiple transaction records, and load these transactions into a database. Within the source file were multiple instances of any of seven transaction types. The database had a separate table for each transaction type, each with its own stored procedure for inserting a record. So thats seven transaction types and seven ...
I got this error today while trying to access my new SharePoint 2010 environment via PowerShell: Cannot access the local farm. Verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again. If I would have just read the error message a little more carefully, I would have realized that I should start by looking at my permissions in SQL – which my account didn’t. This happened because I installed SQL ...
Full Disclosure: I was one of the technical reviewers on this book. I think my friend Tomislav did a great job on this book and it would make a valuable addition to the bookshelf of anyone that is working with MDX. I really enjoyed reading this and there were even a couple of interesting techniques that I have added to my toolkit. As far as I know there are not any other MDX books on the market quite like this one. It's more aimed at the intermediate level of MDX user and assumes that you have some ...
In response to a post from an anonymous individual on one of my posts (http://geekswithblogs.net/... regarding free Microsoft tools I thought a follow up post was required! Anonymous, unfortunately you are mistaken; Websitespark is free and is open to individuals it truly provides all the possible tools & software that you could require to get started. If you read the program details on the Microsoft website (http://www.microsoft.com/w... ...
When I try to start the service, it fails and the following appears in the Application log within Event Viewer: Source: MSSQL$SQLEXPRESS Event ID: 17058 Task Category: Server Level: Error Keywords: Classic User: N/A Description: initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.). To fix this I had to change the Log on as property of the service from Local Service to Local System Technorati Tags: sql server 2008,troubleshooting,servic... ...
You have at least 2 choices: Source 1: SQL Server 2008 Feature Pack http://www.microsoft.com/do... ... this includes Microsoft OLEDB Provider for DB2 Source 2: Available from IBM, is the IBM I Access pack http://www-03.ibm.com/syste... Remember, whichever one you use, you will need to specifiy which libraries under the detail/advance settings in ODBC ...
On the 9th Sep, the SQL Azure team announced that the new version of SQL Azure had just been release. In this version not only the SQL Azure engine had been upgraded, the SQL Azure Management Portal had been upgraded massively. Below are the features and improvements available in this release: Foundational updates for scalability and performance. Co-administrator support, which enables customers to specify multiple database administrators. Increased capability for using spatial data types, which ...
This is very cool Just found this fab, tool to generate all the insert statements you need from a SQL database. If you have SQL Server 2008 R2 Installed - Run "C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\... This lets you select individual tables, views, stored procedures and script out both data and schema structures. Perfect for populating SQL Azure, when migrating from on-Premise databases ...
Today's $10 Deal of the day from Apress at http://www.apress.com/97814... is Beginning SQL Server 2008 Administration. "Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database." Proud to useIn-depth C# code analysis with instant errorand warning highlighting and quick-fixes ...
In our environment most of developers use SQL Server 2008,but in production we have SQL Server 2005, and some databases still have compatibility level 80(SQL server 2000) It sometimes causes problems E.g. the SQL wtitten on SQL Server 2008 INSERT INTO[dbo].[SiteIds] ([SiteID], [SiteCode],[ParentID]) VALUES (11,'ChildOfXX',(select [SiteID] from [SiteIds] where SiteCode='XX')) GO on SQL Server 2005 caused Msg 1046, Level 15, State 1, Line 5 Subqueries are not allowed in this context. Only scalar expressions ...
Today's $10 Deal of the day from Apress is Expert SQL Server 2008 Development "Focuses on sound development and architectural practices that will help you become a better developer, capable of designing high-performance, robust, maintainable database applications." www.apress.com/media/catalo... ...
In this Issue: WindowsPhoneGeek, John Papa, Mike Taulty, Erno de Weerd, Stephen Price, Chris Rouw, Peter Kuhn, Damian Schenkelman, Michael Washington, and Manas Patnaik. Above the Fold: Silverlight: "Binding to View Model properties in Data Templates. The RootBinding Markup Extension" Damian Schenkelman WP7: "Storing Files in SQL Server using WCF RIA Services and Silverlight – Part 3" Chris Rouw LightSwitch: "Saving Files To File System With LightSwitch (Uploading Files)" Michael Washington Shoutouts: ...
I wanted to get familiar with SharePoint 2010 because I have noticed how the market is starting to demand it. Also, most of the SharePoint 2010 guides on the net are outdated. They show everything from registry hacks/editing xml files to installing hot fixes/service packs. My guide uses the latest bits as of 6/7/11 to create a SharePoint 2010 server inside of an Virtual Machine. This will be more than enough to begin creating Silverlight Web Parts inside of SharePoint 2010. NOTE: I did not want to ...
Just reminder of a post I wrote back in December. Don’t forget that there is a variety of free ebooks available for download on a number of different developer and IT topics. Developer subjects include Programming Windows Phone 7, Moving to Visual Studio 2010, and Introducing SQL Server 2008 R2. IT topics include Deploying Windows 7, Understanding Microsoft Virtualization Solutions and First Look at Office 2010 just to name a few. Have a day ...
Mondays had been good to me recently. Mondays at work are usually quiet, and occasionally I may even be able to sneak in a nap if you want to. Yeah, I have it good. But this Monday would prove to be a bit trickier than normal. It started out normal enough, I was rushing to work, and hoping for one more day full of naps. As I settled in and logged on to my system, I saw an email from one of the clients. It said he was not able to connect to his SQL Server 2008 instance. Also, he had tried using the ...
The Apress $10 Deal of the day at http://www.apress.com/ is Pro SQL Server 2008 Analytics "Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint," MORE ...
First, let me clarify the “killing kittens” statement. A couple of years back, I had a chance of attending a sessions presented by Todd Klindt and Shane Young on SharePoint Installation and to raise awareness of how little control, and not to say the limitations, of installing in Standalone mode, they would state “Everytime a SharePoint Standalone Installation happens, God kills a kitten”. Ok, now on to the rest of the purpose of the post. Assumption: SQL Server 2008 R2 is already installed on the ...
I am encountering this error on a freshly installed Named Instance SQL Server 2005 "Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The SQL Server specified in Integration Services service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in SQL Server 2008 Books Online. Login Timeout Expired An error has occurred ...
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false false EN-GB X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.000... ...
If you are using SQL Server management Studio much the we can observer that the list of server names in the log in of it. As you can imagin a period of time after 6 month or 1 year you will see a long list of server names in the login dialog. How to clear this list...? I doesn't provide a mechanism to clean nor clear the list, so you'll have to do a little browsing through your file system. For SQl Server 2005 Management Studio, we should delete the below file C:\Documents and Settings\<user>\Appli... ...
I was trying to change the SA password on my development server this morning and got an error. Msg 15535, Level 16, State 1, Line 1 Cannot set a credential for principal 'sa'. It was a little frustrating to get an error for a seemingly simple task but then agian maybe I screwed something up. After doing a couple of searches i found a Microsoft KB (support.microsoft.com/kb/9... "You receive an exception in SQL Server 2008 when you try to modify the properties of the SQL Server Administrator account ...
Towards the end of 2010, Microsoft made some changes to the Microsoft Certified Master for SQL Server 2008 program. The process to certification required to have a 3 week bootcamp/course in Redmond. This has changed now. It has been mapped to 2 exams. Get information from Microsoft Learning with regards to the changes, process, resources and pricing for the certification exams. http://www.microsoft.com/le... What has happened here too, is some SQL MCM rotation ...
It’s about 3 months later when I registered the SQL Azure Reporting CTP on the Microsoft Connect after TechED 2010 China. Today when I checked my mailbox I found that the SQL Azure team had just accepted my request and sent the activation code over to me. So let’s have a look on the new SQL Azure Reporting. Concept The SQL Azure Reporting provides cloud-based reporting as a service, built on SQL Server Reporting Services and SQL Azure technologies. Cloud-based reporting solutions such as SQL Azure ...
So I’ve been doing some upgrades just to see if things will work from 2007 to 2010. So far most of the stuff I want works, but obviously there are some things that break. Did you guys know that in 2007 you could add a webpart to the view pages for lists and libraries without losing the toolbar? In 2010 the ribbon disappears every time you add a webpart. So if you are using Scot Hillier’s Codeplex project to hide buttons it will not work the same way, because the ribbon is going to disappear altogether. ...
We love seeing projects from start to finish, and we’re happy to share the latest example with you. Who: SaaS Web Apps – they use Software as a Service to create web applications that look and feel like desktop applications. What: SaaS Web Apps needed to build a Sports Contract Management System (SCMS) for one of its customers, Premier Stinson Sports. Why: The SCMS database is used for collecting, analyzing and recording college coach and athletic directors’ employment and contract data. The Challenge: ...
2011 Event Recap Event Overview During the weekend of January 14th through January 16th, the St. Louis area technology community participated in a national GiveCamp event. With Microsoft’s assistance, similar events were held simultaneously in the following cities: Austin, Texas Phoenix, Arizona Birmingham, Alabama Colorado Springs, Colorado Dallas, Texas Atlanta, Georgia Houston, Texas Nashville, Tennessee Dallas, Pennsylvania Fayetteville, Arkansas New York City, New York Malvern, Pennsylvania ...
I’m trying to find time to update the Prairie Developer Conference 2011 website, and the sessions and speaker information will be up by this weekend including the registration page. For those that are wondering what the session and speaker list looks like, I wanted to give a sneak peak. We have a fantastic set of sessions by world class technologists! We’re covering .NET, Java, Ruby, SQL Server, Agile, User Experience, Mobile, Security, Azure, Office, SharePoint, and others. In fact, this year I’ve ...
This is known issue with SharePoint 2007 or SharePoint 2010 on Windows Server 2008 platform and not specific to any sharepoint application. Problem: Your windows credential doesn’t work if you try to log in to the web application (http://contosto.company.com) on the server itself although you can access the same site from outside, when you create a SharePoint web application with a host header (contosto.company.com) on SharePoint Server (Server Name: contosto) which is installed on Windows Server ...
Todays Apress $10 deal of the day at http://www.apress.com/info/... is "Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking ...
Problem Like most organizations, we are planning to upgrade our database server from SQL Server 2005 to SQL Server 2008. I would like to know is there an easy way to know in advance what kind of issues one may encounter when upgrading to a newer version of SQL Server? One way of doing this is to use the Microsoft SQL Server 2008 Upgrade Advisor to plan for upgrades from SQL Server 2000 or SQL Server 2005. In this tip we will take a look at how one can use the SQL Server 2008 Upgrade Advisor to identify ...
Ok it doesn’t really but the Microsoft Partner Network folks have hit gold with this rather addictive chrimbo game. It is great fun to play yet has a little serious side as it “rewards” you with a Windows Azure related link after each level. Try it now! http://bit.ly/festivegame It is a Silverlight app which is: Related In the UK we are helping partners build applications for the Windows Azure Platform (and other technologies such as SQL Server 2008 R2) through Microsoft Platform Ready. Sign up for ...
SharePoint Installation in Windows 7 or Vista is not same as Windows Server 2008. You might have difficulties if you do not follow the proper steps. Here i have been tried to explain how to install SharePoint 2010 on Windows 7 or Vista and configure it. Assume, Installed OS Windows 7 x64 (as you may already know SP only support 64-bit OS) and Windows update Install SQL Server 2008 Install SharePoint 2010 You can install SharePoint using the following steps A. Install software prerequisites 1. Install ...
In a recent blog post I mentioned the availability of the Programming Windows Phone 7 ebook by Charles Petzold. Well I have good news, there are a number of additional FREE ebooks available from Microsoft to help you continue honing your tech skills. Moving to Microsoft Visual Studio 2010 Introducing Microsoft SQL Server 2008 R2 Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft Understanding Microsoft Virtualization Solutions (Second Edition) First Look Microsoft ...
This post is about VS 2010, go here for the VS/TFS 11 extensions. UPDATED Apr 9th 2012: VersionInfo, NuGet, Code Contracts UPDATED Oct 7th 2012: New Visual Studio GDR UPDATED Aug 31th 2012: New versions updated of ReSharper, NDepend, Web Essentials, Community Build Manager, Code Contracts (March 2012), NuGet, ILSpy, DotPeek, Just Decompile, tangible T4 editor, LinqPad. Added the VersionInfo tool, so you know you have the latest update of VS 2010 UPDATED April 20th 2012: New version of NuGet manager. ...
Problem I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2? Solution Uninstalling a clustered instance of SQL Server 2008 R2 is actually an easy thing to do. It might be intimidating for your first attempt so I would highly recommend doing this first ...
SharePoint 2010 is released and available in 3 Editions. They are Microsoft SharePoint Foundation 2010 Microsoft SharePoint Server 2010 Standard Edition Microsoft SharePoint Server 2010 Enterprise Edition Before start implementing Sharepoint, its must to select the right edition for given requirement. When we recommend SharePoint to customers, they first ask what's the cost? Well, it's based on what for SharePoint is going to be used. 1. Microsoft SharePoint Foundation 2010 MSF 2010 is the least ...
I needed to downgrade SQL Server 2008 from Enterprise to Standard on a Server 2008 machine, and and kept getting this error when trying to uninstall: SQL Server Setup has encountered the following error: Invoke or BeginInvoke cannot be called on a control until the window handle has been created It turns out the setup utility really doesn't like having ANY other windows open - I closed the Server Manager window and it worked ...
Wow. There were a stack of announcements made at the key note. So I thought I would try to jot then down while I'm just waiting for my first technical session a Deep Dive on PowerPivot to start. The Parallel Data Warehouse Edition of SQL Server 2008 R2 has been released to manufacturing, there was a demo with a query over an 800 Billion record table that was returning in 19 seconds on a 40 node parallel cluster. Yahoo came up and talked about an SSAS cube of theirs, it's 12TB in size and they load ...