Yearly Archive: 2008

Cumulative Update 9 for SQL Server 2005 SP2 released

Cumulative Update 9 for SQL Server 2005 SP2 released

Microsoft quietly released CU #9 (build 9.00.3282) yesterday; it contains a few dozen fixes, including a nasty AV involving UNION queries, documented in KB #956006.  You can read about / obtain the cumulative update...

My Management Studio wishlist for SQL Server 2011

My Management Studio wishlist for SQL Server 2011

Inspired both directly and indirectly by fellow MVP Erland Sommarskog, whose programming wishlist I talked about the other day, I have decided to compile a list of my own wish list items, in the...

Want to make a difference in the next version of SQL Server?

Want to make a difference in the next version of SQL Server?

SQL Server 2008 is out, and I'm sure you are either learning about or already enjoying some of the new features.  And while the dev team probably doesn't wholeheartedly agree with me at this...

SQL Server Express 2008 is now available

SQL Server Express 2008 is now available

Sorry I missed this yesterday with all the excitement over the Visual Studio SP1 release (which allowed some people to finally install the SQL Server 2008 release from last week).  Yesterday also marked the...

Visual Studio 2008 SP1 (RTM) is now available [UPDATE]

Visual Studio 2008 SP1 (RTM) is now available [UPDATE]

Now that you can get Visual Studio 2008 SP1 RTM, you probably want to rush out and install it.  I would hold off on that until you read Bob Ward's blog entry, which explains...

Express now comes in small, medium and large

Express now comes in small, medium and large

No, this is not about a new extra value meal from your favorite fast food restaurant.  In order to accommodate different requirements and download sizes, a new edition of Express will be offered alongside...

SQL Server 2008 has RTM'd, and free trial software now available

SQL Server 2008 has RTM'd, and free trial software now available

According to a few sources (e.g. Gail Shaw and Brian Randell), Microsoft announced today at TechEd South Africa that SQL Server 2008 has RTM'd. For those that aren't aware, this just means that the...

New Kid on the Block : SQL Server 2008 Web Edition

New Kid on the Block : SQL Server 2008 Web Edition

You may have heard rumblings at a conference or user group meeting about a new SKU of SQL Server that will be shipping soon: Web Edition.  But what is it, exactly?  Some information on...

How do the links in YOUR copy of SQL Server 2008 Books Online work?

How do the links in YOUR copy of SQL Server 2008 Books Online work?

I am just taking a quick show of hands; and maybe some information, if you are willing.  (And if this hasn't happened to you, I apologize for taking up your time.) I have had...

Performance Advisor : A Quick "Two Thumbs Up"

Performance Advisor : A Quick "Two Thumbs Up"

I have been playing with Performance Advisor, the new companion to the very popular Event Manager software from SQL Sentry.  Right off the bat, I can tell you that this tool should have Quest...

Very important SQL Server update

Very important SQL Server update

There is a patch available for four elevation of privilege vulnerabilities recently discovered in SQL Server. From http://www.microsoft.com/technet/security/bulletin/ms08-Jul.mspx: This security update resolves four privately disclosed vulnerabilities. The more serious of the vulnerabilities could allow...

A little Management Studio "oops"

A little Management Studio "oops"

For those of you who connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of...

sys.dm_exec_requests

sys.dm_exec_requests

One of the dynamic management views (DMVs) that is very useful in troubleshooting query performance is sys.dm_exec_requests.  The documentation around this DMV, however, is quite lacking in two areas. percent_complete This column shows the...

OT : Buck Woody talks about the environment

OT : Buck Woody talks about the environment

Buck makes a quick mention of the "green" efforts at Microsoft in his blog, and points us to the Environment site that Microsoft has created to show off what they are doing for a...

My biggest beef with RC0 so far

My biggest beef with RC0 so far

As Andrew Fryer pointed out earlier today on his blog, RC0 for SQL Server 2008 has been released to MSDN and TechNet subscribers.  What is RC0?  It may be the last public push we...

More on the recent rash of SQL injection attacks (update 6/3)

More on the recent rash of SQL injection attacks (update 6/3)

Fellow MVP Steve Kass and Microsoft's Buck Woody have some links and advice about preventing SQL injection attacks not only from affecting your data but also from affecting your users.  You can see the...

Are you (or is your team) nervous about SQL Server 2008?

Are you (or is your team) nervous about SQL Server 2008?

As you may know, I have been heavily involved in testing a lot of the new features in SQL Server 2008, and am likely as excited as anybody about its release.  Since I work...

Do you want IntelliSense to support SQL Server 2005?

Do you want IntelliSense to support SQL Server 2005?

Currently, the plans for IntelliSense are to support SQL Server 2008 *ONLY*… since it works against SQL Server 2005 in the February CTP, I was very surprised to learn that it is being dropped...

When was my database / table last accessed?

When was my database / table last accessed?

A frequently asked question that surfaced again today is, "how do I see when my data has been accessed last?"  SQL Server does not track this information for you.  SELECT triggers still do not...

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