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.

The Profiler Extension in Azure Data Studio (ADS)

This article covers the basics of the Profiler extension in Azure Data Studio, a handy way to trace your application calls.

Understanding Maximum Server Memory in SQL SERVER

This short piece explains the value of maximum server memory and shows you how to change this.