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.

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 […]

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 […]

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.

Database containment and c

Fixing MLS Python Services to Load the Runtime

Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]