Ranked #1
DBA Jobs: Threats and Opportunities
DBA Jobs: Threats and Opportunities
Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (m... Read more
17 Jan 2019
•
34mins
Ranked #2
Teach Yourself SQL Server Performance Tuning
Teach Yourself SQL Server Performance Tuning
You'd love to have a job tuning SQL Servers, but you don't have an environment to practice in. Here's how to teach yours... Read more
11 Aug 2016
•
19mins
Ranked #3
Training Resources for SQL Noobs
Training Resources for SQL Noobs
New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community me... Read more
13 Jun 2018
•
29mins
Ranked #4
How Do I Analyze a SQL Server Execution Plan?
How Do I Analyze a SQL Server Execution Plan?
A query is slow, and you figure out how to collect the query execution plan. Now what? In this episode I talk "big pictu... Read more
22 Sep 2017
•
26mins
Ranked #5
Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes
Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes
Learn the difference between heaps, clustered and nonclustered indexes, primary keys, and columnstore indexes in SQL Ser... Read more
2 Feb 2017
•
26mins
Ranked #6
Will the Cloud Eat My DBA Job?
Will the Cloud Eat My DBA Job?
Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? Kendra talks ... Read more
23 Feb 2017
•
28mins
Ranked #7
How to Level Up Your DBA Career
How to Level Up Your DBA Career
You're a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to lev... Read more
7 Jul 2016
•
26mins
Ranked #8
Should I Get Certified as a DBA?
Should I Get Certified as a DBA?
Find out if getting certified will help you land an entry level DBA job, and if you do want to get certified, get Kendra... Read more
4 May 2017
•
17mins
Ranked #9
Index Maintenance and Performance
Index Maintenance and Performance
They made their index maintenance job smarter, and their queries got slower in production afterward. Could the index mai... Read more
13 Apr 2017
•
28mins
Ranked #10
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*(
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*(
In this week's episode, I'm not answering a reader's question. Instead, I'm talking about my personal experience with an... Read more
8 Nov 2017
•
43mins
Ranked #11
Which Queries are Causing my Wait Stats?
Which Queries are Causing my Wait Stats?
You've got some troubling wait stats in SQL Server. How can you tell which queries are causing those waits? Kendra discu... Read more
25 May 2017
•
34mins
Ranked #12
DevOps Terms - and Why They Matter to Database Specialists
DevOps Terms - and Why They Matter to Database Specialists
In this session, I discuss scrum, continuous deployment, test driven development, DevOps, and related concepts. I close ... Read more
2 Oct 2018
•
19mins
Ranked #13
Signs Your SQL Server is Running with Scissors
Signs Your SQL Server is Running with Scissors
Does your team know what it's doing with SQL Server? Learn what a consultant looks for when assessing a team, and signs ... Read more
1 Dec 2016
•
22mins
Ranked #14
WAL: The concept that makes recovery models & backups make sense
WAL: The concept that makes recovery models & backups make sense
When you're a Junior DBA, it's really hard to take in all the information out there. Learn about write ahead logging: th... Read more
2 Mar 2017
•
18mins
Ranked #15
Should I Learn Full-Text Indexing?
Should I Learn Full-Text Indexing?
Learn where full-text search shines, a common problem which full-text search does NOT solve, where full-text can run int... Read more
9 Feb 2017
•
18mins
Ranked #16
Interview Advice from the SQL Server Community
Interview Advice from the SQL Server Community
In this episode, I talk about three articles written by members of the SQL Server community on interviewing that I can't... Read more
17 Aug 2017
•
8mins
Ranked #17
Should I Upgrade to SQL Server 2016?
Should I Upgrade to SQL Server 2016?
Learn why SQL Server 2016 SP1 is a game changer, and how to take best advantage of all the cool features now in Standard... Read more
17 Nov 2016
•
23mins
Ranked #18
Auto-Tuning and the #1 Mindset Problem I had as a DBA
Auto-Tuning and the #1 Mindset Problem I had as a DBA
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs in SQL Server?... Read more
1 Dec 2017
•
18mins
Ranked #19
How Do I Prepare for Certification Exams?
How Do I Prepare for Certification Exams?
In this episode, I talk about how to strategize for and prepare for Microsoft Certification exams, using the Database Fu... Read more
23 Apr 2018
•
29mins
Ranked #20
Do I Need to Master PowerShell?
Do I Need to Master PowerShell?
As a SQL Server DBA, do you need to be a killer with scripts? In this episode I talk about how much you need to know abo... Read more
12 Sep 2017
•
9mins