Yearly Archive: 2008

More updates for SQL Server 2005 Service Pack 3

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

More info on SQL Server 2005 SP3 + Cumulative Updates

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

SQL Server does not care about the order of your bulk file!

SQL Server does not care about the order of your bulk file!

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

Pushing for more disclosure in DMVs

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

SQL Server 2005 SP3 is available!

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

SQL Quiz : Career Challenges

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

SQL Server 2005 Books Online update (December 2008) now available

SQL Server 2005 Books Online update (December 2008) now available

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

CU2 for SQL Server 2008 is missing!

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

Troubleshooting Service Broker through SQL Server error logs

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

PASS Keynote, Wednesday: "Delivering on Our Data Platform Vision"

PASS Keynote, Wednesday: "Delivering on Our Data Platform Vision"

The keynote today was delivered by Ted Kummert, Corporate VP, Data and Storage Platform Division at Microsoft.   Before Ted started, Wayne Snyder showed up on stage, sitting on a hog and surrounded by...

My reasons for upgrading to SQL Server 2008

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

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

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

SQL Server 2005 SP3 Beta is available!

SQL Server 2005 SP3 Beta is available!

Okay, it happened a couple of days ago; sorry for not noticing.  But SQL Server Release Services / Sustained Engineering has announced that an SP3 Beta has been made available.  The build is 9.00.4028...

My stored procedure "best practices" checklist

My stored procedure "best practices" checklist

When developing stored procedures, there seems to be a lot of emphasis on "get it done fast." Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out...

PASS Conference Stories – tagging Adam Machanic and Peter DeBetta

PASS Conference Stories – tagging Adam Machanic and Peter DeBetta

In 2005, PASS was held in Grapevine, Texas.  The conference hotel was called the Gaylord, of all things.  It was quite luxurious — more of a resort than a hotel — but miles and...

More info about SQL Server 2008 Cumulative Update 1

More info about SQL Server 2008 Cumulative Update 1

Bob Ward has posted a very thorough walk-through of the CU1 installation process.  He talks about some of the things they've improved with the setup of patches, and gives a bit of a teaser...

SQL Server 2008 Cumulative Update 1 is available

SQL Server 2008 Cumulative Update 1 is available

For those waiting for the first CU for SQL Server 2008, your wait is over.  You can get it in KB #956717.  The build # is 10.00.1763.00. As with SQL Server 2005, you can...

Keeping sysdepends up to date in SQL Server 2008

Keeping sysdepends up to date in SQL Server 2008

sysdepends, sp_depends and sys.sql_dependencies Since my very first experience with SQL Server (version 6.5), I have used the system table sysdepends and the system stored procedure sp_depends to track dependency information in my databases. ...

SQL Server 2008 cumulative updates and hotfixes, oh my!

SQL Server 2008 cumulative updates and hotfixes, oh my!

As of today there is at least one hotfix available for SQL Server 2008, and it involves Itzik Ben-Gan's reported foreign key validation problem with the new MERGE command.  You can read about the...

Planning on using FILESTREAM?  Read this first!

Planning on using FILESTREAM? Read this first!

Paul Randal just published a list of tips and tricks that will help you get the most out of using FileStream.  The list is based on a longer whitepaper he wrote for Microsoft, which...

Pushing for more tools-related fixes for SQL Server 2011

Pushing for more tools-related fixes for SQL Server 2011

A few days ago I posted a list of Management Studio issues I hope they will add or fix for the next version of SQL Server (or sooner).  Comments there and elsewhere, as well...