SQL Server Compression Estimator Now Available

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 are many including reduced disk I/O and memory utilization, with…


How To Convert SQL Server datetime Data To UTC Time

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 values range from -14:00 to +14:00). Many…


New for SQL Server: the SQLDiag Configuration Tool is Released

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 Support organization (CSS) and has a very nice…


SQL Iterators: Making the Life of a SQL Server DBA That Much Easier

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 and sp_MSForEachTable. The upside of using these stored procedures…