Monthly Archive: February 2010

Cumulative Update #8 available for SQL Server 2005 SP3

Last week, Microsoft released Cumulative Update #8 for SQL Server 2005 SP3.  The build # is 9.00.4285.  You can read the blog post from the Release Services team here: http://blogs.msdn.com/sqlreleaseservices/archive/2010/02/15/cumulative-update-8-for-sql-server-2005-service-pack-3.aspx And the Knowledge Base...

MacGyver Moments

I was tagged by David Stein, a.k.a. Made2Mentor [ blog | twitter ], to talk about "MacGyver Moments" in my career – times when I've turned nothing into something.  One clearly comes to mind,...

Connect Digest : 2010-02-16

Simon Sabin has asked for better usability in the SQL Server Agent log viewer: specifically, to allow you to get to job / step properties directly from the history viewer. #531889 : Allow access...

[OT] : Headed to the Olympics

Just wanted to drop a quick note to let people know that I will probably be pretty quiet on here for the next two weeks.  We leave tomorrow for Vancouver to spectate at several...

Injection is not always about SQL

I think anybody even remotely involved with databases these days has seen the xkcd comic about Bobby Tables : http://xkcd.com/327/  Basically, the comic warns against SQL injection, and reminds you to sanitize your database...

Connect Digest : 2010-02-06

Upgrading a database with read-only filegroups Earlier today, I complained that I should be able to upgrade a database with read-only filegroups.  In this case an upgrade from, say, 2000 to 2005 is blocked...

When bad error messages happen to good people

Updated July 13th, 2018 Over the years I have largely been amused by the variance in error messages that come out of SQL Server.  Some are very verbose and some even border on provide...