Quick question: Where would you go to find some basil in your local grocery store? Did you say “by the other herbs?” Or did you say “by the tomatoes?” If you are like me, then you would go looking for basil by the other herbs because, well, that is a natural, logical grouping of products. [...]
SQL MVP
How To Find Long Running Backups in SQL Server
I’ve written before about how much I love looking for outliers. One example of this can be found in the post I did on the sysjobhistory table. Recently I was asked to put together some code to find out which backups were “running long”. Of course my first question was trying to define what was [...]
What Toy Story 2 Can Teach You About Testing Your Backups and Recovery Strategy
This is a great little video that helps reinforce a few things.
Make sure your backups are running.
Test your recovery strategy.
Working from home can solve everything.
The 3 DBA Mistakes You Don’t Know You Are Making
You have no idea that what you are not doing is causing you pain.
Then again, how could you know this? I mean, if you are not doing it, why would you ever think that your inaction could be the very thing that is causing you heartache every time your phone rings in the middle of [...]