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 bug here: http://web.archive.org/web/*/https://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=357419 And about the fixes/workarounds in KB #: http://support.microsoft.com/kb/956718 More importantly, I have received […]

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 should be published before PASS in November. http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx

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 at the following KB: http://support.microsoft.com/kb/953752 So, now you can start hitting F5 all day, every day […]

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 same spirit of, "it's never too early."  This list is restricted to issues involving Management Studio; […]

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 release of SQL Server 2008 Express Edition, which you can download here: http://www.microsoft.com/express/sql/default.aspx You can read […]

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 the situation, and should help clear up some confusion on whether you need to install anything: […]

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 Express with Advanced Services, about a month after the core edition comes online, called Express with […]

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 this edition has recently been released by Ireland Licensing, and I will try to sum it […]