Monitoring transaction log usage is an important part of database maintenance. High numbers of Virtual Log Files (VLFs) within a…
Several years ago I attended my first SQLSaturday event (when they were still in the 100s). It was a great day,…
This year’s PASS Summit is a week away, so I thought it was time to break out the conference packing…
Recently our local SQL group went through a leadership change, and was faced with an important question: Should we incorporate…
We’re coming up on a great time of year again, for SQL database geeks. The PASS Summit. I’ll leave off…
First, thanks to Sean McCown (t|w) and Mladen Prajdic (t|w) for their assistance with finding & confirming some of the…
In the previous post we looked at how log backups and auto growth settings can affect performance. Now let’s look…
Why does missing a few log backups matter? I was asked that question last week when one of our backup…
Patching servers is an annoying, but critically necessary task. Every month, on every (virtual) server, we have to: Create a…
There are more than 1000 different ways to configure a SQL Server instance. Just to install a new SQL Server…