Monthly Archive: April 2008

Performance / Storage Comparisons : MONEY vs. DECIMAL

Performance / Storage Comparisons : MONEY vs. DECIMAL

As you may already know, I am not a big fan of the MONEY data type, because of its inflexibility, accuracy problems, and the expectations the name of the type evokes in new users. ...

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