Restore to a point in time

This week I had to do a point in time restore for an entire instance. The instance had approx 25 databases on it, and all of them had to be replaced to get the information we needed. As this was on a SQL Availability Group, we are backing up the logs every 15 minutes....

DBATools

I don’t know why I am slow to take up new tools, but I am. I recently, like back in December, began working with DBATools. In case you’re not familiar, DBATools is a powershell module assembled by the community over at DBATools.io. This module, oh this...

Wait Stats Library

Every so often you come across one of those tools that just changes everything. When it comes to troubleshooting tools, this is one of those defing tools. Paul Randal has assembled the greatest library of SQL wait statistics known to man – well to me anyway. If...

A Month of SSMS

One of the things that has always frustrated me with Microsoft’s tools like SSMS and Visual Studio, is the sheer depth of the tool. Figuring out how to create an SSRS or SSIS package in Visual Studio the first few times can result in half a day wasted. SSMS can...

SQL version numbers

This is one of those tools I use all the time. I’m always looking at the version number to see which version of SQL with SP/CU version I am working with. SQL Version numbers and patch...