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.

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

Default Agent Error Logs