Browse by Tags

  

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...