October 2008 - Posts

• 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 and you can download it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D22317E1-BC64-4936-A14B-7A632B50A4CA Read More... Posted Friday, October 31, 2008 1:03 AM by AaronBertrand | 2 Comments Filed under: service packs, cumulative updates, service pack 3, builds

• 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 the window. Personally, I would rather front-load Read More... Posted Thursday, October 30, 2008 6:40 PM by AaronBertrand | 43 Comments Filed under: intellisense, best practices, stored procedures, T-SQL

• 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 miles and miles (and miles) from civilization. The nearby town was nice enough Read More... Posted Thursday, October 02, 2008 7:15 PM by AaronBertrand | 6 Comments Filed under: Celko, PASS