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

Writing to Clones

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?

Deploying Azure SQL Database Using an ARM Template

Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).

Backup SQL Server on Linux Databases using SQL Server Agent on Windows

In this tip, we're going to look at the steps to backup SQL Server on Linux databases using SQL Server Agent on a Windows server.