December 2006 - Posts

• Slipstreaming Hot Fixes and Service Packs

  I've been getting requests from users concerning the best way to roll out new service packs and hot fixes to their SQL Server computers. A perenial question that always seems to come up is "Why doesn't Microsoft slipstream (that is, add the hot fixes Read More... Posted Friday, December 29, 2006 1:42 PM by KKline | 0 Comments Filed under: Trends, Releases

• Erland Sommarskog's Dynamic Search Conditions Article

  Erland Sommarskog, SQL Server MVP, and a much smarter SQL Server professional than me has updated his article on Dynamic Search Conditions available at http://www.sommarskog.se/dyn-search.html . A great document to begin with, it now to covers the method Read More... Posted Wednesday, December 27, 2006 6:23 PM by KKline | 0 Comments Filed under: SQL Programming

• SQL Server 2005 Service Pack 2 - December CTP

  Microsoft published the December CTP of SQL Server 2005 SP2 on the web on December 19th. Find it at http://www.microsoft.com/downloads/details.aspx?FamilyID=d2da6579-d49c-4b25-8f8a-79d14145500d&DisplayLang=en This update replaces the November CTP Read More... Posted Friday, December 22, 2006 6:18 PM by KKline | 0 Comments Filed under: Releases

• SQL Server Performance Improvements on Windows 2003 SP2

  SQL Server MVP Aaron Bertran recently asked for elaboration on the comments posted here: http://blogs.technet.com/windowsserver/archive/2006/08/01/444365 .aspx Specifically, "Performance improvements for SQL Server Service Pack 2 provides performance Read More... Posted Wednesday, December 20, 2006 4:06 PM by KKline | 0 Comments

• How to Best Synchronize a Reporting Server

  Have you ever had to build a reporting system where you wanted to off-load the reporting function from the main production server? It's a problem that can be solved with a variety of methods, for example: - Database Mirroring: Works very nicely in an Read More... Posted Monday, December 18, 2006 3:30 PM by KKline | 0 Comments Filed under: Best Practices

• Consuming Data from the PerfMon Counters

  SQL Server MVP Kent Tegels recently raise an interesting question. SQL Server publishes a number of performance counters. In the code he's written that publishes performance counter data, he's had to explictly code the counter updates within his code Read More... Posted Friday, December 15, 2006 3:15 PM by KKline | 0 Comments Filed under: Performance, Best Practices, Administration