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 This is earlier than I expected, and is probably […]

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 my development time; I think that the costs I […]

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 about about his next blog post, where he will discuss how they are making the patches […]

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 simply submit a request for the CU, and it will get e-mailed to you.  Be sure […]

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.  The purpose of tracking dependency information is to allow me to determine which objects are required; […]

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 bug here: http://web.archive.org/web/*/https://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=357419 And about the fixes/workarounds in KB #: http://support.microsoft.com/kb/956718 More importantly, I have received […]

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 should be published before PASS in November. http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx

Cumulative Update 9 for SQL Server 2005 SP2 released

Microsoft quietly released CU #9 (build 9.00.3282) yesterday; it contains a few dozen fixes, including a nasty AV involving UNION queries, documented in KB #956006.  You can read about / obtain the cumulative update at the following KB: http://support.microsoft.com/kb/953752 So, now you can start hitting F5 all day, every day […]

My Management Studio wishlist for SQL Server 2011

Inspired both directly and indirectly by fellow MVP Erland Sommarskog, whose programming wishlist I talked about the other day, I have decided to compile a list of my own wish list items, in the same spirit of, "it's never too early."  This list is restricted to issues involving Management Studio; […]