Monthly Archive: August 2008

SQL Server 2008 cumulative updates and hotfixes, oh my!

SQL Server 2008 cumulative updates and hotfixes, oh my!

As of today there is at least one hotfix available for SQL Server 2008, and it involves Itzik Ben-Gan's reported foreign key validation problem with the new MERGE command.  You can read about the...

Planning on using FILESTREAM?  Read this first!

Planning on using FILESTREAM? Read this first!

Paul Randal just published a list of tips and tricks that will help you get the most out of using FileStream.  The list is based on a longer whitepaper he wrote for Microsoft, which...

Pushing for more tools-related fixes for SQL Server 2011

Pushing for more tools-related fixes for SQL Server 2011

A few days ago I posted a list of Management Studio issues I hope they will add or fix for the next version of SQL Server (or sooner).  Comments there and elsewhere, as well...

Cumulative Update 9 for SQL Server 2005 SP2 released

Cumulative Update 9 for SQL Server 2005 SP2 released

Microsoft quietly released CU #9 (build 9.00.3282) yesterday; it contains a few dozen fixes, including a nasty AV involving UNION queries, documented in KB #956006.  You can read about / obtain the cumulative update...

My Management Studio wishlist for SQL Server 2011

My Management Studio wishlist for SQL Server 2011

Inspired both directly and indirectly by fellow MVP Erland Sommarskog, whose programming wishlist I talked about the other day, I have decided to compile a list of my own wish list items, in the...

Want to make a difference in the next version of SQL Server?

Want to make a difference in the next version of SQL Server?

SQL Server 2008 is out, and I'm sure you are either learning about or already enjoying some of the new features.  And while the dev team probably doesn't wholeheartedly agree with me at this...

SQL Server Express 2008 is now available

SQL Server Express 2008 is now available

Sorry I missed this yesterday with all the excitement over the Visual Studio SP1 release (which allowed some people to finally install the SQL Server 2008 release from last week).  Yesterday also marked the...

Visual Studio 2008 SP1 (RTM) is now available [UPDATE]

Visual Studio 2008 SP1 (RTM) is now available [UPDATE]

Now that you can get Visual Studio 2008 SP1 RTM, you probably want to rush out and install it.  I would hold off on that until you read Bob Ward's blog entry, which explains...

Express now comes in small, medium and large

Express now comes in small, medium and large

No, this is not about a new extra value meal from your favorite fast food restaurant.  In order to accommodate different requirements and download sizes, a new edition of Express will be offered alongside...

SQL Server 2008 has RTM'd, and free trial software now available

SQL Server 2008 has RTM'd, and free trial software now available

According to a few sources (e.g. Gail Shaw and Brian Randell), Microsoft announced today at TechEd South Africa that SQL Server 2008 has RTM'd. For those that aren't aware, this just means that the...

New Kid on the Block : SQL Server 2008 Web Edition

New Kid on the Block : SQL Server 2008 Web Edition

You may have heard rumblings at a conference or user group meeting about a new SKU of SQL Server that will be shipping soon: Web Edition.  But what is it, exactly?  Some information on...