Goals for 2011

I was tagged by Denis Gobo (blog | twitter) in a Review of his 2010 Goals.  I didn't make such a post last year at this time, so I had nothing to check against.  But that doesn't mean I can't start with my goals for the coming year, right?  A […]

A more reliable and more flexible sp_MSforeachdb

Updated July 2018 I've complained about sp_MSforeachdb before.  In part of my "Bad Habits to Kick" series in 2009-10, I described how I worked around its sporadic inability to actually process all of the databases on an instance: Bad habits to kick : Relying on undocumented behavior I lumped this […]

SSMS Tools Pack now supports Denali CTP1

Earlier today, Mladen Prajdić (blog | twitter) released an updated version of his SSMS Tools Pack (v.1.9.4), a free add-in for Management Studio that provides a ton of helpful functionality that isn't available with the native tools.  I'm really glad this happened, because I've installed Denali on all of my […]

Cumulative Update #1 for SQL Server 2005 SP4

Well, much quicker than I would have suspected, the SQL Server Release Services team has incorporated all of the fixes in 2005 SP3's CU #12 into the first CU for SP4.  Thanks to Chris Wood for the heads up.  You can get the new Cumulative Update here: KB #2464079 : […]

SQL Sentry Plan Explorer : Version 1.1!

Last week, Microsoft offered up an early Christmas present: SQL Server 2005 SP4.  This week, it's SQL Sentry's turn to play Santa Claus: several new features and fixes have been packaged up into SQL Sentry Plan Explorer 1.1 (build So, what's new?  Several wish list items have been fulfilled […]

SQL Server v.Next (Denali) : Metadata enhancements

In my previous job, we had several cases where schema changes or incorrect developer assumptions in the middle tier or application logic would lead to type mismatches.  We would have a stored procedure that returns a BIT column, but then change the procedure to have something like CASE WHEN <condition> […]

SQL Server 2005 SP4 is here!

Yes, the day has finally arrived, and a couple of weeks ahead of schedule.  Typically when Microsoft promises a release in Qx or Hx, the software comes on the last or second last day of that quarter or half.  This year, we get an early Christmas present: SQL Server 2005 […]

What permissions are required for SET IDENTITY_INSERT ON?

SQL Server 2000's SET IDENTITY_INSERT ON topic says: Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner. While the SET IDENTITY_INSERT topic for SQL Server 2005 (and up) says: User must own the object, or be a member […]

The old "do as I say, not as I do" problem

Microsoft is often considered a leader, an innovator, a trend-setter.  The same could be said for Apple, Google, and a host of other tech companies.  And each of those has its set of critics as well, who think that the company is the opposite – or worse.  Some people think […]