Media Summary: Should you always index your foreign keys? What if you index your foreign key, and then the index never gets used? Get clickable ... Ever had a database change go horribly wrong? It can feel awful in the moment, then eat away at your confidence for days ... Find out if getting certified will help you land an entry level

Dear Sql Dba Everything I - Detailed Analysis & Overview

Should you always index your foreign keys? What if you index your foreign key, and then the index never gets used? Get clickable ... Ever had a database change go horribly wrong? It can feel awful in the moment, then eat away at your confidence for days ... Find out if getting certified will help you land an entry level Learn about free tools that send you notifications when blocking happens, and track the queries causing your toughest blocking ... Learn the basics of full-text indexing in In this video, I discuss the integration of AI tools into my daily work and explore their potential impact on

I've been working as an 'Evangelist' at Redgate for close to six months now, and one question keeps coming up: what exactly ... When you migrate a database, it can be useful to prove that you moved all the data and didn't miss any transactions. Learn how to ...

Photo Gallery

Dear SQL DBA: Everything I Never Wanted to Know About Collation
Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)
How Does a DBA Build Confidence After Making Mistakes? (Dear SQL DBA Episode 40)
How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)
Next Door to Derpton - When Your CoWorker is a Danger to Databases (Dear SQL DBA Episode 3)
Lost in Performance Troubleshooting - Kendra's Method to Triage Perf (Dear SQL DBA Episode 2)
Should I Get Certified as a DBA? (Dear SQL DBA Episode 41)
Setting Up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)
Should I Learn Fulltext Indexing? (Dear SQL DBA Episode 29)
Dear SQL DBA: AI SQLServer2025
How to Level Up Your DBA Career (Dear SQL DBA Episode 7)
What a Software Evangelist Does - and Where the Job is Going (Dear SQL DBA Episode 67)
View Detailed Profile
Dear SQL DBA: Everything I Never Wanted to Know About Collation

Dear SQL DBA: Everything I Never Wanted to Know About Collation

I'm not an expert on collation in

Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)

Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)

Should you always index your foreign keys? What if you index your foreign key, and then the index never gets used? Get clickable ...

How Does a DBA Build Confidence After Making Mistakes? (Dear SQL DBA Episode 40)

How Does a DBA Build Confidence After Making Mistakes? (Dear SQL DBA Episode 40)

Ever had a database change go horribly wrong? It can feel awful in the moment, then eat away at your confidence for days ...

How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)

How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)

Prefer a written transcript? Go to https://littlekendra.com/2017/09/22/how-do-i-analyze-a-

Next Door to Derpton - When Your CoWorker is a Danger to Databases (Dear SQL DBA Episode 3)

Next Door to Derpton - When Your CoWorker is a Danger to Databases (Dear SQL DBA Episode 3)

What do you do when your fellow

Lost in Performance Troubleshooting - Kendra's Method to Triage Perf (Dear SQL DBA Episode 2)

Lost in Performance Troubleshooting - Kendra's Method to Triage Perf (Dear SQL DBA Episode 2)

The

Should I Get Certified as a DBA? (Dear SQL DBA Episode 41)

Should I Get Certified as a DBA? (Dear SQL DBA Episode 41)

Find out if getting certified will help you land an entry level

Setting Up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)

Setting Up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)

Learn about free tools that send you notifications when blocking happens, and track the queries causing your toughest blocking ...

Should I Learn Fulltext Indexing? (Dear SQL DBA Episode 29)

Should I Learn Fulltext Indexing? (Dear SQL DBA Episode 29)

Learn the basics of full-text indexing in

Dear SQL DBA: AI SQLServer2025

Dear SQL DBA: AI SQLServer2025

In this video, I discuss the integration of AI tools into my daily work and explore their potential impact on

How to Level Up Your DBA Career (Dear SQL DBA Episode 7)

How to Level Up Your DBA Career (Dear SQL DBA Episode 7)

You're a Junior or mid-level

What a Software Evangelist Does - and Where the Job is Going (Dear SQL DBA Episode 67)

What a Software Evangelist Does - and Where the Job is Going (Dear SQL DBA Episode 67)

I've been working as an 'Evangelist' at Redgate for close to six months now, and one question keeps coming up: what exactly ...

Using a Tail Log Backup in a SQL Server Migration (Dear SQL DBA Episode 34)

Using a Tail Log Backup in a SQL Server Migration (Dear SQL DBA Episode 34)

When you migrate a database, it can be useful to prove that you moved all the data and didn't miss any transactions. Learn how to ...