Finding Marks

The Backup File Extension

Post Restore Tasks for the Resource Database

The Marked Transaction

Restoring the Resource Database

Get the most out of SQL Server Agent logs

If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent for various maintenance and other scheduled tasks. Most of the time, these processes just work. But when it’s time to troubleshoot, it can be cumbersome to get to the root of some problems.

The Cloned Database Size

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.