Welcome to Stedman’s SQL Server Podcast Season 2. 2025 was the second season of the podcast with 29 episodes featuring guests, team members and much more.
Here is a list of all of our season 1 – 2025 episodes:
Stedman SQL Podcast Season 2 Episode 29 Database Health Monitor Recap for 2025
Database Health Monitor: All the Exciting Features Added in 2025! Join Steve Stedman and lead developer Mitchell Glasscock as they recap an incredible year of updates to Database Health Monitor, the ultimate SQL Server monitoring tool. From December’s Structure Change Log (track who changed what in your databases) and Disk Space Forecast Report, to sortable timeline charts, TempDB allocation insights, enhanced drill-downs, the major Version 3 release with DB Assistant, revamped Performance Monitor, CPU by Query drill-downs, deadlock tracking, email alerting, and more—this episode covers every major enhancement that makes troubleshooting faster and proactive monitoring easier. Whether you’re dealing with blocking, deadlocks, open transactions, index issues, or just want better visibility across your SQL Servers, these real-world features (built from client feedback) will transform your DBA workflow .Download Database Health Monitor today (30-day free trial) at http://DatabaseHealth.com and start using these tools on your servers!
Episode 29 details page – Watch Episode 29 now
Stedman SQL Podcast Season 2 Episode 28 10 Things Every DBA Should Know For Performance
In this episode of the Stedman SQL Podcast, Steve Stedman walks through often overlooked SQL Server configuration settings that can significantly improve performance. Topics include TempDB setup, file growth settings, alerts, index maintenance, fill factor, backup compression, RCSI, and the importance of monitoring with Database Health Monitor. If you want to deepen your SQL Server knowledge, November is Stedman SQL School month with daily class promotions at Stedman.us/school. Watch the episode to learn practical, high-impact adjustments you can apply to your SQL Server environment and how to monitor results using Database Health Monitor at DatabaseHealth.com.
Episode 28 details page – watch episode 28 now
Stedman SQL Podcast Season 2 Episode 27 Database Health Monitor Updates
Welcome to this week’s episode of the Stedman SQL Podcast, hosted by Mitchell Glasscock and George Stedman! In this episode, they explore the latest Database Health Monitor enhancements — explaining not only what’s been added, but why these updates matter for real-world SQL Server environments. From preventing TempDB version store bloat with a new Quick Scan check, to adding open transaction visibility and command-line automation for scheduled health reports, this episode dives deep into practical DBA tools built from direct user feedback. Mitchell and George also discuss improvements to index usage tracking, historic vs. real-time performance analysis, CPU and blocking drill-down reports, and a more accurate backup status view that filters copy-only backups. Plus, they preview the upcoming TempDB allocation chart, designed to help DBAs quickly see how space is being used over time. Whether you manage SQL Server daily or just want to better understand how Database Health Monitor can simplify your DBA workflow, this episode is packed with valuable insights and tips. Learn more and download Database Health Monitor at DatabaseHealth.com
Episode 27 details page – watch episode 27 now
Stedman SQL Podcast Season 2 Episode 26 Backup Types and Retention Periods
In this episode of the Stedman SQL Podcast, Steve Stedman explores one of the most essential topics in SQL Server management—backup types and retention periods. Learn the differences between full, differential, and transaction log backups, how they work together to ensure data protection, and how to determine the right retention strategy for your organization’s recovery and compliance needs. This episode provides practical insights to help DBAs, developers, and IT managers avoid data loss, reduce downtime, and maintain reliable recovery options.
Episode 26 details page – watch episode 26 now
Stedman SQL Podcast Season 2 Episode 25 Data, Log and TempDB Files
In this episode of the SQL Server Podcast, Mitchell and Steve take a deep dive into the critical files that keep SQL Server running—data files, log files, and TempDB. They discuss how these files work, why their configuration matters, and common mistakes that can lead to performance bottlenecks. You’ll hear practical advice on sizing, placement, and growth settings, along with insights from real-world experiences solving SQL Server performance issues. Whether you’re a DBA, developer, or IT manager, this conversation will help you better understand how to keep your SQL Server environment healthy and efficient.
Episode 25 details page – watch episode 25 now
Stedman SQL Podcast Season 2 Episode 24 The Lean DBA
In this episode, we dive into “The Lean DBA,” exploring how process improvements can streamline your workflow and boost efficiency as a database administrator. Discover time-saving SSMS tips like Block Mode Select, dragging table/column names, using “GO” for multiple query executions, and powerful hotkeys (e.g., F5, Ctrl+M, Alt+F1). Learn how to display results in a separate tab for easier viewing, set up a Ctrl+3 shortcut for quick SELECT TOP 100 queries, and use sp_help with Alt+F1. We also cover bulk indenting, displaying line numbers, and leveraging Registered Servers for multi-server queries. Plus, get insights on the Database Health Monitor’s Quickscan Report and DBAssistant. Finally, we discuss the role of AI in the DBA world—featuring tools like Grok, ChatGPT, and Copilot—and why embracing AI is crucial to stay ahead. Don’t miss these practical tips to become a leaner, more efficient DBA!
Episode 24 details page- watch episode 24 now
Stedman SQL Podcast Season 2 Episode 23 Database Health Monitor v3.0
In this episode, we share the exciting upcoming release of Database Health Monitor 3.0, packed with powerful improvements to help you monitor and manage SQL Server more effectively. The new DB Assistant provides guidance and insights to simplify performance tuning. A new Job History Chart makes it easier to visualize SQL Agent job performance over time. Problem Indexes reports at both the instance and database level help you quickly identify indexing issues. The Backup Size report has been completely revamped to give clearer visibility into backup growth, while the new Database Backup Time Frames report shows when backups are running in your environment. We have also added a new Log Shipping instance report to help you monitor the health of your log shipping setup more efficiently. Alongside these new features, we are also introducing the Database Health Monitor Rewards Program. This program is our way of thanking the SQL Server community by offering exclusive benefits, early access to features, and special rewards for those who continue to support and use Database Health Monitor. Join us in this episode to learn how Database Health Monitor 3.0 can help improve your SQL Server monitoring and how you can take advantage of the new rewards program. Download Now: Databasehealth.com/download2 for your 30 day FREE trial
Episode 23 details page- Watch episode 23 now
Stedman SQL Podcast Season 2 Episode 22 Building a Career
In this episode of the Stedman SQL Podcast, Steve Stedman shares a detailed and practical roadmap to building a successful career as a SQL Server DBA. Whether you’re just starting out or looking to advance your skills, you’ll learn what it takes to grow in this high-demand field.
Episode 22 Details page – Watch episode 22 now
Stedman SQL Podcast Season 2 Episode 21 SQL Server Agent Jobs
In this episode, we dive into SQL Server Agent Jobs—one of the most essential, yet often overlooked, features in SQL Server. Whether you’re running index maintenance, backups, ETL processes, or reporting routines, SQL Agent is the backbone that keeps it all running on schedule. Steve Stedman and Mitchell Glasscock walk through how SQL Server Agent works, how to set up and schedule jobs properly, and what to watch for when jobs fail silently. You’ll also hear practical strategies for logging, alerting, and maintaining job history to help you troubleshoot issues faster. Topics include job step management, proxies and credentials, handling long-running jobs, avoiding scheduling conflicts, and real-world examples of Agent job failures that led to performance or data issues.
Episode 21 Details page- watch episode 21 now
Stedman SQL Podcast Season 2 Episode 20 Testing Restores
Steve Stedman and Shannon Lindsay discuss the importance of testing SQL Server backups weekly. Steve emphasizes the risks of untested backups, including potential data loss and longer restore times. They highlight the need for consistent testing to ensure recoverability and compliance with regulations like HIPAA and GDPR. Steve shares a case study where a 1.5 TB database was restored due to endpoint protection issues, avoiding significant downtime. They recommend automating restore processes, using tools like Database Health Monitor, and maintaining a documented runbook. Shannon suggests consulting Stedman Solutions for expert guidance on backup and recovery strategies.
Episode 20 Details page – watch episode 20 now
Stedman SQL Podcast Season 2 Episode 19 One Server Shop
Steve Stedman discusses managing SQL Server in a one-server shop without a full-time DBA. He highlights the challenges of inadequate database management, including performance slowdowns, data corruption, and security vulnerabilities. Stedman Solutions offers Database Health Monitor version 3 coming soon, and managed services with experienced DBAs. He emphasizes the importance of regular backups, proactive monitoring, and disaster recovery. A real-world example shows how they improved a client’s sales report performance. Stedman also addresses the high cost of hiring full-time DBAs and the benefits of managed services, including peace of mind and cost-effectiveness.
Episode 19 Details page – watch episode 19 now
Stedman SQL Podcast Season 2 Episode 18 TDE
In this episode of the Stedman Solutions SQL Server Podcast, Steve Stedman and Derrick Bovenkamp explore Transparent Data Encryption (TDE) in SQL Server and its role in protecting sensitive data.
TDE encrypts data at rest, helping safeguard against unauthorized access to database files. It uses AES-256 encryption and is now available in SQL Server Standard Edition, making it more accessible than ever. However, TDE does not encrypt data in memory or during transmission—SSL or TLS is required for that layer of protection.
Steve and Derrick walk through how to set up TDE, including creating the master key, certificate, and database encryption key. They also explain why it’s essential to regularly back up these keys and certificates to ensure recoverability.
They discuss performance considerations, how TDE typically does not significantly impact database size or speed, and the importance of testing changes in a non-production environment before going live. And if you need help visit https://stedman.us/talktde
Episode 18 details page – watch episode 18 now
Stedman SQL Podcast Season 2 Episode 17 Ransomware
In this episode of the SQL Server Podcast by Stedman Solutions, we take a close look at ransomware—a dangerous form of malware that encrypts your data and demands payment for its release. We explain how ransomware works, why it’s a growing threat to SQL Server environments, and what the real consequences are for businesses that aren’t properly protected.
We’ll walk through real-world examples of ransomware attacks, explore why SQL Servers are often prime targets, and reveal the hidden costs that come with recovery—even if the ransom is paid. You’ll learn why standard backups are often not enough, and how a poorly tested backup plan can actually leave you worse off.
We also cover proven strategies to prevent ransomware from compromising your systems, from strengthening your backups to implementing proactive monitoring and alerting. You’ll learn how Database Health Monitor can help detect early warning signs, and how our SQL Server Managed Services provide expert, around-the-clock protection from threats like ransomware.
Whether you’re a DBA, an IT manager, or a business owner responsible for data, this episode will give you a clear roadmap for defending your SQL Server environment from one of today’s most serious cybersecurity threats.
Episode 17 details page – watch episode 17 now
Stedman SQL Podcast Season 2 Episode 16 Wait Types
In this episode, we dive into the top 10 most common SQL Server wait types. You’ll learn what each wait type means, how it impacts performance, and what you can do to resolve the issues. From CXPACKET to PAGEIOLATCH, we make complex wait stats easier to understand and troubleshoot.
Episode 16 details page – watch episode 16 now
Stedman SQL Podcast Season 2 Episode 15 DBA on Vacation
Steve Stedman and Shannon Lindsay discuss the Stedman Solutions’ DBA on Vacation service, which provides temporary expert SQL Server support when the full-time DBA is on leave. They highlight the risks of unmonitored servers, such as performance issues, missed backups, and potential downtime. The service includes proactive monitoring, issue resolution, on-call support, and customizable duration coverage. Stedman Solutions, with over 100 years of combined SQL Server experience, ensures seamless handoffs and detailed post-vacation reports. They offer a free 30-minute consultation and a special offer of a free database health monitor license for new clients.
Episode 15 details page – watch episode 15 now
Stedman SQL Podcast Season 2 Episode 14 RCSI with Derrick
Join host Steve Stedman and guest Derrick Bovenkamp in Season 2, Episode 14 of the Stedman SQL Server Podcast for an in-depth discussion on Read Committed Snapshot Isolation (RCSI). Discover how this SQL Server feature enhances performance and reduces blocking in database environments. The episode covers how RCSI works, its differences from other isolation levels, steps to enable it, and best practices for implementation, along with potential pitfalls to avoid. Perfect for DBAs and developers aiming to optimize SQL Server workloads, this episode offers expert insights and practical examples.
Episode 14 details page – watch episode 14 now
Stedman SQL Podcast Season 2 Episode 13 Blocking and Deadlocks
In this episode, we explore two of the most common performance issues in SQL Server: blocking and deadlocks. Although they might appear similar at first glance, they behave very differently and require different approaches to troubleshoot and resolve. You’ll learn what blocking is, why it happens, and when it’s considered normal. We’ll also explain what causes deadlocks, how SQL Server automatically handles them by killing one process, and why that matters for your applications. Along the way, we’ll walk through real-world examples, share tips to prevent both problems, and explain how indexing, query tuning, and good transaction practices can make all the difference.
Episode 13 details page – watch episode 13 now
Stedman SQL Podcast Season 2 Episode 12 Database Health Monitor Features
In this episode of the SQL Server Podcast, we explore the latest enhancements to Database Health Monitor, our free SQL Server monitoring and diagnostics tool.
We cover several powerful new features designed to improve the user experience and give DBAs deeper visibility into their environments. This includes new reports for better database insights, additional health checks and warning messages, and the all-new cardinality report. We also introduce the TDE (Transparent Data Encryption) Status Instance Report to help track encryption status across your servers. Plus, we discuss upcoming licensing changes and what that means for current and future users of the tool. Whether you’re already using Database Health Monitor or just starting out, this episode is packed with insights to help you get the most out of your SQL Server environment.
Episode 12 details page – watch episode 12 now
Stedman SQL Podcast Season 2 – Episode 11 Common SQL Mistakes
This week’s episode discusses 4 common mistakes that may be affecting your SQL Server performance. We will cover the misuse of correlated subqueries, cross apply and how it can be over used, missing or overlooked indexes and overly wide tables. Steve covers each of this potential issues in detail with real world examples and how to avoid misusing them. You won’t want to miss this one!
Episode 11 details page – watch episode 11 now
Stedman SQL Podcast Season 2 – Episode 10 Stedman Solutions 10 Year Anniversary!
Happy 10 Year Anniversary to Stedman Solutions! In this special Stedman SQL Podcast episode, Steve reminisces back on the last decade of how Stedman Solutions came to be, the learning curves and growth that the company has had, and announces an exclusive gift for our listeners. Thank you for the last 10 years, and here is to the next!
Episode 10 details page – watch episode 10 now
Stedman SQL Podcast Season 2 – Episode 9 New Features for Database Health Monitor
Steve Stedman and Mitchell Glasscock discuss new features in the Database Health Monitor, including six new deadlock reports at both instance and database levels. They explain deadlock scenarios, the concept of deadlock victims and winners, and how the tool helps identify and track deadlocks. They also introduce a new email alerting tool for notifying users of critical issues, even when the tool is not open. Additionally, they highlight the inclusion of schema drift comparison, SQL Server health reports, and replication status reports. The episode concludes with a sneak peek at upcoming features and an announcement for the 10-year anniversary of Stedman Solutions.
Episode 9 details page – watch episode 9 now
Stedman SQL Podcast Season 2 – Episode 8 SQL Server Analysis in 30 Minutes
In this week’s episode of the SQL Server Podcast, Derrick Bovenkamp joins us to break down the first steps Steve and him take when analyzing a SQL Server. In just 30 minutes, they cover key areas like performance bottlenecks, missing indexes, query optimization, and database health checks using tools like Database Health Monitor. Whether you’re troubleshooting issues or optimizing your environment, this episode is packed with expert insights to get you started.
Episode 8 details page – watch episode 8 now
Stedman SQL Podcast Season 2 – Episode 7 Comparing Database Schema with Schema Drift
This week, Steve Stedman introduces the latest release of Database Health Monitor, featuring significant updates to the Schema Drift tool. Originally developed in 2015, Schema Drift allows users to compare schema objects across databases, including tables, triggers, and stored procedures. After facing challenges with SQL Server Management Objects (SMO), the tool was completely rewritten in 2024 to eliminate SMO dependency, resulting in improved stability and faster performance. Stedman demonstrates its powerful functionality, showcasing how it detects database differences, facilitates object migration, and exports comparison results to Excel—ideal for client presentations. Schema Drift is available for free within Database Health Monitor or as a standalone tool at schemadrift.com. This step by step instructional podcast, is an episode you won’t want to miss.
Episode 7 details page – watch episode 7 now
Stedman SQL Podcast Season 2- Episode 6 Corruption
In this episode of the SQL Server Podcast, we dive deep into one of the most dreaded issues for database administrators—SQL Server database corruption. Corruption can strike at any time, causing data loss, downtime, and major headaches. But with the right knowledge and tools, you can detect, repair, and even prevent corruption before it becomes a disaster. Join Steve Stedman and Shannon as we discuss: – Common causes of database corruption – How to detect corruption using DBCC CHECKDB – Best practices for repairing corruption and recovering data – The role of backups and corruption-resistant strategies – Real-world stories from fixing corrupt databases Whether you’re an experienced DBA or new to SQL Server, this episode is packed with actionable insights to help you protect your data and keep your databases running smoothly.
Episode 6 details page – watch episode 6 now
Stedman SQL Podcast Season 2 – Episode 5 Ace that next Interview
In this week’s episode of the SQL Server Podcast, we dive into DBA interview questions—what to expect, how to prepare, and how to stand out! Whether you’re applying for a SQL Server DBA role or hiring for one, we break down common technical, performance tuning, and disaster recovery questions that every DBA should know.
Episode 5 details page – watch episode 5 now
Stedman SQL Podcast Season 2- Episode 4 Indexing
In this episode of the SQL Server Podcast, Steve Stedman breaks down the fundamentals of indexing in SQL Server and why it’s essential for database performance. Steve starts by explaining the key role of indexes in speeding up query performance. Using a phone book analogy, he illustrates the difference between clustered and non-clustered indexes. A clustered index organizes data physically based on a specific column, making searches on that column highly efficient. Meanwhile, a non-clustered index acts as a separate lookup table, helping speed up queries on other columns, such as names or phone numbers. Also, Steve mentions the performance tuning training for the month of February, at Stedman.us/perf.
Episode 4 details page – watch episode 4 now
Stedman SQL Podcast Season 2- Episode 3 Cybersecurity Costs – Not Being Proactive
Steve Stedman and Bob Borges from Cloud9 Tech Solutions discuss the importance of proactive cybersecurity, highlighting the significant costs of neglecting it. They cite a 2023 report indicating the average data breach cost is over $4.5 million, with 60% of small businesses shutting down within six months of a breach. Bob emphasizes that all businesses are targets, with healthcare breaches averaging over $10 million. They stress the need for comprehensive security plans, regular audits, and user training. Proactive measures include encrypting SQL databases, implementing multi-factor authentication, and continuous monitoring. They warn that breaches lead to direct and indirect costs, including compliance fines, downtime, and reputational damage.
Episode 3 details page – Watch ep. 3 now
Stedman SQL Podcast Season 2 – Episode 2 VLFs
Steve Stedman and Mitchell Glasscock discuss the importance of Virtual Log Files (VLFs) in SQL Server, emphasizing their impact on performance and backup processes. They explain that VLFs are sequential chunks within the transaction log file, and too many or too large VLFs can slow down systems, especially during backups. They highlight that VLF counts should be kept under 500-1000 and individual VLF sizes under 1-2 GB. They demonstrate how Database Health Monitor (DHM) helps manage VLFs, including visualizing VLFs, shrinking log files, and setting proper growth settings. They also stress the importance of monitoring and alerting systems to prevent issues like running out of disk space due to unmanaged log files.
Episode 2 details page- Watch ep.2 now
Stedman SQL Podcast Season 2 – Episode 1 New Year’s Resolutions
Steve Stedman and Shannon Lindsay discuss SQL Server New Year’s resolutions, emphasizing the importance of backup strategies, proactive monitoring, and staying updated with SQL Server versions. They highlight a January promotion offering 12 months of managed services for the price of 10, providing a 16% discount. Key resolutions include reviewing and testing backups, implementing proactive monitoring, ensuring systems are up-to-date, optimizing query performance, protecting against data corruption and ransomware, and planning for disaster recovery. They also stress the value of training and mentoring to improve SQL Server management. Resources like free white papers and a business continuity survey are available at Stedman Solutions.