Yearly Archive: 2008

Call a spade a spade!  (SQL injection, or IIS vulnerability?)

Call a spade a spade! (SQL injection, or IIS vulnerability?)

In a recent blog post, Dancho Danchev mis-labeled a recent IIS vulnerability as a "massive SQL injection attack." Let's be honest here.  Yes, this alert needs attention.  But this is not a new SQL...

Don't want to call CSS / PSS to get a cumulative update?  You don't have to!

Don't want to call CSS / PSS to get a cumulative update? You don't have to!

Bob Ward posted a blog entry today where he explains the process of getting a cumulative update for SQL Server 2005 without having to call Microsoft's support team (they are called CSS now but...

Using System Restore for Cumulative Update Rollback?

Using System Restore for Cumulative Update Rollback?

Just wanted to post a brief warning about expecting to be able to roll back a cumulative update or hotfix by reverting to a restore point.  In short: don't do it!  These two features...

SQL Server 2005 SP3 is publicly confirmed

SQL Server 2005 SP3 is publicly confirmed

Microsoft has committed publicly to releasing Service Pack 3 for SQL Server 2005.  Francois Ajenstat first talked about it very recently here.  While there were some casual mentions of the release in some responses...

I'll trade you consistency for meeting your deadline

I'll trade you consistency for meeting your deadline

While playing with the new Policy-Based Management (PBM) features of SQL Server 2008 the other day, I came across a really annoying syntax implementation that is going to trip up a lot of people...

Why is the 8.3 filename convention still biting us?

Why is the 8.3 filename convention still biting us?

It is 2008.  Not 1992.  Why are we still intentionally creating filenames that conform to the limitations of ancient DOS and Windows 3.1 naming standards?  This came up today in one of the SQL...

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

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

Is SQL Server "keeping up" with MySQL?

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

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

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

Increased limits for columns / indexes / statistics

Increased limits for columns / indexes / statistics

I am still on the fence about whether this is a good thing or a bad thing.  However, in the next build of SQL Server 2008 you will be able to get your hands...

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

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

16 Changed Dynamic Management Views in SQL Server 2008

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

List of SQL Server 2005 post-SP2 builds

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

I have a dream…

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