Be careful with Open Table

Yes, you were already aware of 40 or 50 reasons not to use Open Table.  I have one more.  Say you are creating a table with a composite key that includes a binary column.  An example I came across recently was a table that captures additional data not covered by […]

Some new and updated SQL Server 2005 builds

Updated: 2007-07-02 Continuing with a great tradition, I present again an updated list of SQL Server builds and hotfixes that have been released since the last time I posted a similar list (beginning of May).  The cumulative fix build 3152 is available for public download.  Most others need to be obtained […]

Staying on top of SQL Server 2005 builds and hotfixes

For years I have been an advocate of making any and all hotfix information available to the public.  I used to stumble upon new builds in the KB by accident, and so I took it upon myself to collect and publish lists of new hotfixes (e.g. here and here) as I found them […]

Playing with CDC in Katmai

Change Data Capture (CDC) is something DBAs around me have been screaming about for ages.  For auditing and other reasons, we have needed to rely on 3rd party tools from companies like Lumigent, whose motto for their auditing product previously named Entegra went something like, "Who did what to which data […]

Playing with DMF in Katmai

I've long been anticipating the Declarative Management Framework (DMF, not to be confused with dynamic management functions!) in Katmai.  We were given an early peek at the product in March, but it was essentially SQL 2005 with a new @@version and slightly modified splash screen.DMF allows you to create policies […]

Katmai news

There is a public CTP coming out this morning.  It was supposed to be published on Connect at 8:30 AM ET, but maybe they meant a different time zone?  Anyway, an interesting "by the way" here is that the official name is SQL Server 2008.  Not that this should really surprise […]

Some new or updated SQL Server 2005 builds

Sorry, this table looks much better in preview mode than publish mode <shrug>.  KB Title Build # KB #932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399 1406 KB #932556 FIX: A script task […]

Vote Whoring

We've been given this great tool called Connect:*/ We have been granted the ability to provide input on the next version of SQL Server, and influence which problems need the most attention and which features we want added most.  But I don't think we're using it very effectively.I'd like to point […]

More on GDRs, QFEs, and the aftermath of SP2.

James Howey of Microsoft gave us a very thorough explanation on the differences between a GDR and a QFE, what happened in SP2, and how to decide which build you should be aiming for.  I'm going to post it here, unedited. <snip>We recently posted updates to address an issue in two SP2 […]

SP2 fallout : the drama continues; UPDATE 4/6

4/6 Here is some more info from Steve Kass.  He paraphrased Microsoft's internal response to the confusion about who should install 3054 and who should install 3159. <snip>3054 includes the new fix along with a few important general-release fixes since SP2.  But 3054 doesn't include several quick fix updates that […]

An update on recent SQL Server 2005 builds

I'm still waiting for the latest GDR / QFE that is going to clean up (no pun intended) all the maintenance plan cleanup issues that were borne out of SP2 and the followup fixes. In the meantime, I've collected a list of build #s and their associated KBs that have […]

More news on Service Pack 2 and Maintenance Plans

So I have official word (and permission to broadcast) that there is one minor bug left in maintenance plans, in the wake of last week's difficulties in properly addressing SP2 and the fixes that followed.  We should expect a GDR early next week and a QFE rollup within a week […]