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 […]
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 […]
I have seen several people make this assumption over the past few weeks, and thought I should write up a little something to drive the point home. Primarily people are expecting to take a flat file, like a log file, bulk insert it into SQL Server, and expect SQL Server […]
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 […]
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 […]
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 […]
Don't be fooled by the poor title on the page, which still says "SQL Server 2005 Books Online (September 2007)" (clearly a leftover from an earlier BOL update). The text under the overview section also mentions the September 2007 update. And the page thanking you for downloading says: Thank You […]
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 […]