No More Deadlocks

Detecting Deadlocks Quickly

Increase Deadlock Detection

How Long is a Long I/O?

Detecting Deadlocks

Find SQL Server Agent Jobs that Start Other Jobs

A SQL Server Agent job can start other jobs. Writing jobs this way makes it easy to compartmentalize jobs: start a “child” job only when the “parent” reaches a certain step. Finding these steps can be challenging. There is no field or property in sysjobs or its associated tables to help find child jobs.

Removing TDE

Everything you should know about the SQL Server Resource database

Every SQL Server instance contains a database that most people never query, never back up, and never even see in Object Explorer. Yet, without it, SQL Server would not start. Enter the SQL Server Resource database.

Why use a Composite Index in SQL Server

SQL queries can take a long time to run, especially on large tables if not properly indexed. Full table scans can be costly operations when all a user wants is to fetch a few rows based on multiple columns and a WHERE filter. How can we properly index our tables to support multi-column queries?

Doing the Little Things

There are a lot of tasks that DBAs and developers struggle to get done. These little things can be important, and perhaps AI can help us keep on top of them.