SQL Server 2008 is getting close… I can smell it!

No, this is not a "funny funny, ha ha!" April Fool's Day post (though I do find those entertaining, and considered posting one myself).  This is for real, and it almost made me tingle a little.  I saw this comment from Eric Kang in a Connect item yesterday morning: "This […]

Is SQL Server "keeping up" with MySQL?

I read a comment in a Connect suggestion today that implied that implementing their suggestion would allow SQL Server to "keep up with MySql."  Regardless of the actual suggestion, that made me laugh out loud… and since I was on the train, that got me some weird looks. The actual […]

Which to use: "<>" or "!="?

For some, the answer is easy.  Since Tibor reminded me several months ago that <> == standard and != <> standard (and yes, I used that notation on purpose), I have been making a conscious effort to use only <> going forward.  Similarly, I have tried to avoid GETDATE() in […]

I would rather see SP3, but I'll take CU6 instead…

Cumulative Update 6 for SQL Server 2005 is now available.  This is build 3228. http://support.microsoft.com/kb/946608 Looks mainly like fixes to replication, reporting services, and analysis services.  But there appear to be some fun access violations and arithmetic overflow issues that are being fixed, too.

16 Changed Dynamic Management Views in SQL Server 2008

Yesterday Denis Gobo told you about 33 new DMVs in SQL Server 2008; previously, I had noticed that a few of the existing DMVs from 2005 had changed slightly.  So, Denis sparked my curiosity, and I ran the following query on a recent build of SQL Server 2008, which had […]

List of SQL Server 2005 post-SP2 builds

For years, ever since I started posting build lists over at aspfaq.com (don't go there now; it's been taken over by malware slimeballs), I have been complaining that Microsoft makes it very hard for us to stay on top of these things, and suggested on numerous occasions that they publish […]

I have a dream…

…that SQL Server setup will someday be less of a mystery, especially to new users.  One of the first things I would like them to do is to remove Compact Edition from setup entirely.  If I really want Compact Edition stuff (I would guess that most people do not need […]