More updates for SQL Server 2005 Service Pack 3

As promised, upon return from a trip to the frozen tundra of Northern Ontario, I am posting the latest updates from last week's release of SQL Server 2005 Service Pack 3.  For those who have been waiting to test the service pack until the post-SP3 cumulative update is available, you […]

More info on SQL Server 2005 SP3 + Cumulative Updates

I recently posted about the availability of SQL Server 2005 SP3.  I have a bit more information about cumulative updates and the service pack, for those of you who might be confused about the whole mess involving CU#10, CU#11, post-SP3 CU#1, and are wondering whether you need to install some […]

Pushing for more disclosure in DMVs

I have been involved in several discussions over the past week involving getting more diagnostic information out of the DMVs in SQL Server 2008 and beyond. Yesterday, I asked for procedure recompiles to be tracked in the new sys.dm_exec_procedure_stats DMV: http://web.archive.org/web/*/https://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=388218 Today, Erland followed up with a similar request, but […]

SQL Server 2005 SP3 is available!

UPDATE 2008-12-16, from the team, regarding SP3 CU1: CU#1 on SP3 is nothing but a rollup of fixes from SP2 CU#10 and SP2 CU#11 that did not make it into SP3 release as these hotfix requests had come in during the stabilization phase of the SP3 development cycle. SP3 CU#1 […]

SQL Quiz : Career Challenges

I was tagged by Denis Gobo to write a bog post about career challenges and how I overcame them.  I'm not going to tag anyone else because I can't seem to find anyone that hasn't already been tagged, and I think this thread has already "made the rounds" as it […]

CU2 for SQL Server 2008 is missing!

UPDATE 2008-12-03 The download packages for the database engine have returned to the download page.  Make sure you download the file labeled "SQL_Server_2008_Cumulative_Update_2" to apply to machines where the SQL Server engine is present, and the file "SQL_Server_2008_RTM_CU2_SNAC" to apply to any machines that don't have a SQL Server instance […]

Troubleshooting Service Broker through SQL Server error logs

Last week I was trying to troubleshoot some activation stored procedures in Service Broker.  One nice thing about this framework is that it logs activation procedure errors in the SQL Server error log, since activation is not an interactive experience.  You will see error messages like this: The activated proc […]

My reasons for upgrading to SQL Server 2008

I gave a presentation this morning to my bosses and co-workers explaining some of the benefits of upgrading to SQL Server 2008.  I thought it might be useful to some of you if I shared my reasons for recommending this upgrade even if the cost is daunting. (Of course, it […]

I forgot how fun it is to set up a new machine!

Okay, this isn't really about SQL Server, but I have been building a new machine today, and it is easily the most powerful computer that has ever been inside my house.  In fact it is more powerful than most of our production servers.  The mere act of opening applications like […]