Written by boB Taylor , Principal Microsoft Premier Field Engineer. Now Available! A smaller, leaner database. I have released my SQL Server Compression Estimator tool to CodePlex . One of the most exciting additions to SQL Server 2008 was the capability to apply data compression. The benefits...

Written by boB Taylor , Principal Microsoft Premier Field Engineer.
As the world moves to a global economy, it becomes more and more important to capture time information with respect to Coordinated Universal Time ( UTC ). This format captures the date and time along with a time zone offset (offset...

Written by boB Taylor , Principal Microsoft Premier Field Engineer. Many Microsoft SQL Server DBAs automate as many of their day to day processes as possible, freeing them to attend to higher impact activities. To do so, many DBAs leveraged two undocumented system stored procedures, namely sp_MSForEachDatabase...

Written by boB Taylor , Principal Microsoft Premier Field Engineer. The wait is finally over! The SQLDiag Configuration Tool has been released. One of the most heavily used tools in the SQL Server Premier Field Engineer’s tool belt is PSSDiag . It is maintained by Microsoft’s Customer Service and...