Yearly Archive: 2007

Connect needs an "Ignored" status

The SQL team seems to have been quite busy recently, commenting on and closing out many bugs and suggestions that have been raised, I suppose as they close out work on the SQL Server...

Registered Servers become more useful

In playing with the latest CTP for SQL Server 2008, I stumbled across some new context menu items for a server group node in Registered Servers.  You can now right-click a group node and...

Casey Kasem is in the machine

Here's a neat database implementation.  Have a song in your head, but don't remember the name?  Got a microphone hooked up to that workstation of yours?  Then head on over to midomi.com, where they...

Resistance is futile! The CLR is everywhere.

Like Java threatened to take over the appliance world 10 years ago, we're probably not that far off from having cars with embedded MP3 players and other gadgets using SQL Server mobile (and hence...

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. ...

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...

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...

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"...

Service Pack 2a?

Well, I'm certainly glad I didn't bet that 3050 would be the last we'd hear about SP2.  It's like alphabet soup, I think 3152 (found at http://support.microsoft.com/kb/933097/ – Thanks Chris!) could unofficially be called SP2c...