SQL Server Management and Operations

There is a new AdventureWorks family of sample databases available for SQL Server 2008 February CTP at https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=MSFTDBProdSamples . The AdventureWorks 2008 family of databases demonstrates some...

Ever wanted to install the SQL Server 2005 samples on Vista? If so, I recommend using the lastest sample installers at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en which we've recently...

Check out the April 2006 samples refresh live at http://msdn.microsoft.com/sql/downloads/samples/default.aspx ! There are lots of bug fixes, plus some new samples. The documentation in SQL Server Database and Samples Overview presents a list of the new...

For the next release of SQL Server we're thinking of just shipping sample code on the web, instead of shipping on the web and also in the SQL Server box on a CD as we have done in the past. Questions: Have you installed SQL Server Samples? Where...

SQL Server 2005 SP2 released to the web today. You can find it here: http://www.microsoft.com/sql/sp2.mspx Note that the serivce pack does not update the samples. You'll need to download the updated samples separately from here: http://www.microsoft...

SQL Server 2008 samples are now available at http://codeplex.com/SqlServerSamples . That's our portal page to many different product and community projects on CodePlex with samples for SQL Server. On the releases tab of the portal page you'll find installers...

We've completed an October refresh of the SQL Server 2008 samples ( http://CodePlex.com/SqlServerSamples ). We've heard from you that the install experience for the databases was too complex and error prone. In this refresh we're providing a much simpler...

Based on the success of the new sample databases installer we created for SQL Server 2008R2, we've created a new samples refresh (SR4) for SQL Server 2008 on CodePlex at http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=37109...

We’ve been discussing with customers and partners and with people inside Microsoft about how we can improve accessibility to the sample code, and move samples into a more community based approach. As a result of all these discussions, we’re moving to...

Welcome everyone! The purpose of this blog is to chat about the samples and sample databases for Microsoft SQL Server. I'll be talking about some of the cool samples already shipping, and let you know about updates and new samples as time goes by. Please...

Just a quick note to let you know that the SQL Server Samples for SQL Server 2005 have just been refreshed. This is Web Refresh 3. You can check out the latest at http://msdn.microsoft.com/sql/downloads/samples/default.aspx . Look for a file called SQLServerDatabasesAndSamplesOverview...

There was a problem with the installer for the AdventureWorks database on the x64 platform. An error indicating the cab file had been corrupted would occur and the installation would fail. This problem has been fixed, and you can find the updated installer...

SQL Server 2005 SP2a Product Samples are now released on CodePlex ( http://codeplex.com/SqlServerSamples ). The only change from the previous release is that the sample installers now have a EULA which is consistent with the MS-PL license we have on CodePlex...

The AdventureWorks 2008R2 November CTP sample databases are now live on CodePlex at http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=24854 ! This is a beta quality release. We’re still addressing some relatively minor issues...

The AdventureWorks sample databases for SQL Server 2008R2 have been updated and are available at http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=24854 . This version includes both the AdventureWorks 2008R2 schema and data...

Have you ever tried using high availability technology like SQL Server database mirroring and been surprised when your ADO.NET client didn't seemlessly switch from the principal to the failover partner but instead reported an exception? The Fault Retry...

The times they are a changin' When I first started working on code to share with the SQL Community that code shipped in the box with very little community participation. Over the years my job has changed and so has the processes we use to create open...

SQL Server 2008 February CTP is now live on http://www.microsoft.com/sql/2008/default.mspx . With this wonderful, feature packed CTP we also have some great companion samples and sample databases which you can find at our portal page: http://CodePlex...

Great news! SQL Server 2008 is now available for download for MSDN subscribers from http://msdn.microsoft.com/en-us/subscriptions/downloads/default.aspx . We're putting the finishing touches on the samples and should have updated installers available...

We're currently creating plans around SQL community and samples for the next 12 months. As we build these plans we want to make sure we're addressing the issues that matter to you. If you have any feedback on your experiences with our community programs...

Doug Holland (a C# MVP) has opened two work items in Connect. The first one is about being able to share settings between VS and SSMS for those of us who do both DBA and developer work. You shouldn't have to specify font, color, or tab settings twice...

SQL Server 2008 (Katmai) October 2009 Samples Refresh 3 is now available. SQL Server 2008 (Katmai) Product Samples Refresh 3 is now live at http://sqlserversamples.codeplex.com/ . There are numerous bug fixes and a new sample, RSPermissions which demonstrates...

The new sample database installers which shipped at the end of October 2008 greatly simplify the installation process for the sample databases. For one thing, there are only three installers to choose from instead of tens of installers. Just pick the...

It is a delight to announce that SQL Server 2008R2 November CTP3 code samples are now posted to CodePlex at http://sqlserversamples.codeplex.com/ . The wiki pages have been updated to reflect the availability of the new sample code installers. These installers...

It is a delight to announce the availability of the AdventureWorks Community Sample Databases for SQL Azure. You can download the scripts and data files from CodePlex . To install the databases on your SQL Azure server just follow the directions on the...