Automate your Morning Checklist

A morning checklist is a good thing, but an automated one is better.

Partitioning Limits in SQL Server 2019

Verify your SQL Server database backups

Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]

Preparing Encryption with Trace Flags

Proactive Performance Tuning

Being proactive in trying to improve your system is good, but sometimes your team might cause you problems with their efforts.

Querying for Table Allocated Pages

How Bad are Bad Page Splits?

A look at bad page splits and how they affect your database.

Learn from the Troubles of Others

Learning from the pain of others can be valuable in your career.

Finding Failed Logins

Redistributing Data Across Files

When adding files to a filegroup, SQL Server doesn't automatically balance the data across the files immediately. See how this works and how you can speed this up.