Running Queries Across Many SQL Server Databases

A challenge that reappears periodically in the world of databases (especially database management) is the need to run code on a subset of databases and to do so in a nuanced manner.

Finding Identity Columns

Resuming Indexes on Old Databases

Central Management Server Credentials

Actively Choosing Compatibility

Do you actively choose which compatibility level makes sense for your SQL Server databases? Or do you just take the defaults? Steve has a few thoughts today on actively managing your system.

T-SQL Scripts to generate the HTML-formatted database storage report

This article will show how to generate an HTML formatted report of your disk space.

Validating Password Expiration

Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.

Using Azure Data Studio to Deploy a SQL Server VM on Azure

This article looks at deploying SQL Server on an Azure VM from Azure Data Studio.

How to Find the SQL Server Instance Startup Time

Learn a number of methods to view or programmatically get the SQL Server instance startup time.

Cheat Sheet for SQL Server DBA Daily Operations

This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.