Backing up the Resource Database

Leave it better than you found it

This is for the folks who still have to log into remote machines and do work manually on the box. Yes, we still exist, and we will for as long as we’re still using physical servers in data centers and even IaaS. Not everyone has transitioned to server core and full-on PowerShell remoting for everything

Find Unused or Backup Tables

If you rename old or backup tables, learn how to find easily find and drop them.

Cloning MSDB

Is This a Good DBA Job Description?

Steve has a sample job description, but is it a good one?

Writing to Clones

Live webinar: How to excel at managing multiple database platforms

Learn about how to handle the requirements of multitple platforms in this webinar.

This is Why You Use Git for Scripts

Git is a good tool for DBAs and other Operations staff. Today Steve gives you a few reasons why.

Error Severity 10

Query Exercise: Find the Best Time for Maintenance

If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own code, maybe scaling up the hardware – when’s the best time to do it?