SQL Server 2008 SR4 sample database installer available

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.  This is a much simpler and more robust installer which allows you to select the databases that can be successfully installed, and also provides…


AdventureWorks 2008R2 November CTP is now live 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 that came up during testing, but we feel that the sample databases will be very helpful to have now that SQL Server 2008 R2 November CTP is available on…


SQL Server 2008 (Katmai) October 2009 Samples Refresh 3 Available

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 how to write an application which manages Reporting Services permissions via the Reporting Services Web Service API.  There…


VS/SSMS settings and the Fault Retry functionality

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, or at least you should be able to…


The transition to community based development

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 source samples and tools that we share with…


New step-by-step instructions for installing sample databases

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 install that is right for the architecture of the machine you’ll be installing on…


Fault Retry provider and sample

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 provider and sample (http://www.codeplex.com/SqlFaultRetryProvide/Wiki/View.aspx?title=Home) may be your ticket to a smoother high availability experience.  This project demonstrates provides…


October 2008 SQL Server Samples Refresh

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 install experience with a lot fewer database installers to choose from.  Please let us know how you like this…


SQL Server 2008 Samples are here!

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 for downloading all the code samples.  If you’re looking for the sample databases for SQL Server 2008,…


SQL Server 2008 is here!

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 for you in the next few days.  I’ll blog again when they are ready.