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 release of SQL Server 2008 Express Edition, which you can download here: http://www.microsoft.com/express/sql/default.aspx You can read […]

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 the situation, and should help clear up some confusion on whether you need to install anything: […]

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 Express with Advanced Services, about a month after the core edition comes online, called Express with […]

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 this edition has recently been released by Ireland Licensing, and I will try to sum it […]

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 and Idera shaking in their boots, as it is really going to give them a run […]

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 an attacker to run code and to take complete control of an affected system. An authenticated […]

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 Management Studio that is shipping with SQL Server 2008 is going to bring you some surprises, […]


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 "percent of work completed for certain operations, including rollbacks."  Okay, great, now could you tell us […]

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 cause that is important to all of us.  There are several tidbits in here that can […]

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 see before the product RTMs later this year.  It is feature complete, and from this point […]