Welcome to Stedman’s SQL Server Podcast, your go-to source for all things SQL Server! Whether you’re a seasoned DBA, a developer, or an IT professional looking to expand your SQL Server knowledge, this podcast offers insightful discussions, expert interviews, and practical tips to help you optimize your database performance. Each episode dives deep into topics like performance tuning, database corruption repair, monitoring best practices, and much more. Tune in regularly for a wealth of SQL Server expertise, brought to you by Stedman Solutions, your trusted partner for SQL Server management and DBA services.
Your Host: Steve Stedman
With over 30 years of hands-on experience, Steve Stedman is more than just a host—he’s a trusted guide in the world of SQL Server. From his early days as a developer to his role as founder of Stedman Solutions, LLC, Steve has built a reputation as a go-to expert in SQL Server performance tuning, database corruption repair, and proactive management.
Steve’s extensive knowledge is matched by his passion for teaching. Whether it’s through the podcast, his blog, or speaking engagements, he brings complex SQL Server topics to life with clear explanations, practical examples, and a touch of humor.
What the Podcast Covers
The Stedman SQL Server Podcast is designed to deliver valuable insights in every episode. Here’s what you can expect:
Real-World Problem Solving: From handling ransomware attacks to dealing with untested backups, each episode dives into practical challenges faced by SQL Server users.
Performance Tuning Deep Dives: Learn how to optimize slow queries, improve indexing strategies, and make your SQL Server run like a well-oiled machine.
Database Corruption Stories: Real-life examples of corruption repair, along with strategies to prevent it in your environment.
Interviews with Experts: Conversations with top SQL Server professionals about trends, tools, and techniques that are shaping the industry.
Tips for DBAs and Developers: Actionable advice for both seasoned DBAs and developers working to improve their database skills.
Proactive Monitoring: Explore how tools like Database Health Monitor can help prevent issues before they occur.
Why Listen to Stedman’s SQL Server Podcast?
- Stay Current: Keep up with the latest SQL Server updates, trends, and technologies.
- Learn from the Best: Steve’s engaging teaching style makes learning SQL Server both enjoyable and accessible.
- Connect with the Community: Through listener Q&A sessions and interviews, the podcast fosters a sense of community among SQL Server professionals.
- Practical Takeaways: Each episode is packed with actionable insights you can apply to your own SQL Server environment.
Here is a list of some of our recent episodes:
Stedman SQL Server Podcast Episode 11- New Features for Database Health Monitor
Host: Steve Stedman
Steve Stedman hosts the Stedman SQL podcast, featuring George and Mitchell, developers of the Database Health Monitor. They discuss new features in DHM, including the VLF visualization report, schema search, SQL CPU schedulers, deprecated features, historic file size over time, and average page life expectancy charts. Mitchell highlights the flexibility of the new instance page layout and the upcoming disk latency report. George mentions the rewritten schema drift tool for comparing database schemas. Steve encourages feedback for new features and previews the next episode on SQL join types. The podcast is available on Spotify and YouTube.
Episode 11 details page – Watch ep. 11 now
Stedman SQL Server Podcast Episode 10 – RPO and RTO
Host: Steve Stedman/ Shannon Lindsay
This episode focuses on RTO (Recovery Time Objective) and RPO (Recovery Point Objective) for SQL Server backups, emphasizing the importance of aligning these metrics with business needs. They highlight the role of transaction log backups, log shipping, and immutable backups in improving recovery times and points. The conversation also touches on the necessity of testing backups and maintaining open communication with management.
Episode 10 details page – Watch ep. 10 now
Stedman SQL Server Podcast Episode 9 – Corruption
Host: Steve Stedman
Guest: Derrick Bovenkamp
Steve Stedman and Derek Bovenkamp discuss SQL Server database corruption, its causes, symptoms, and prevention strategies. Corruption often results from IO issues, such as firmware problems with iSCSI or antivirus software misconfigurations. Symptoms include failed queries and check DB errors. They emphasize the importance of regular check DBs, ideally daily, and testing backups. Effective solutions include restoring from backups or engaging experts like Stedman Solutions. They highlight the risks of ignoring corruption, including potential data loss and compliance issues. Best practices include using OLA Halogen scripts, maintaining up-to-date hardware, and staying current with SQL Server updates.
Episode 9 details page- Watch ep. 9 now
Stedman SQL Server Podcast Episode 8 – Business Continuity
Host: Steve Stedman
Steve Stedman discusses the availability of the Stedman Solutions SQL podcast on YouTube and Spotify, and announces November class promotions with discounts up to 60% off. He emphasizes the importance of business continuity planning, especially in light of recent storms in the Pacific Northwest. Stedman outlines potential threats, such as hardware failures, natural disasters, cybersecurity threats, and human error, and stresses the need for risk assessments, backup strategies, and regular testing. He also highlights the role of managed services in ensuring business continuity and shares real-world examples of disaster recovery. The episode concludes with a discussion on best practices for shrinking SQL Server files.
Episode 8 details page – Watch ep. 8 now
Stedman SQL Server Podcast Episode 7 – Brandie Kayser from ROC-IT joins us!
Host: Steve Stedman / Shannon Lindsay
Guest: Brandie Kayser – www.roc-it.net
Steve Stedman hosts the seventh episode of his podcast, discussing the importance of IT budgeting with Brandy Kaiser from ROC-IT. Brandie emphasizes the need for regular IT assessments and budgeting to avoid unexpected expenses. She highlights the significance of aligning IT goals with business objectives and the importance of cybersecurity. Brandie shares a case study of a medical practice with IT issues due to poor initial setup, stressing the value of proactive planning. The conversation also covers the challenges of upgrading systems and the benefits of partnering with experts like Stedman Solutions. An eBook on tech budgeting strategies is available for download.
Episode 7 details page – Watch ep. 7 now.
Stedman SQL Server Podcast Episode 6- New features for Database Health Monitor – October
Host- Shannon Lindsay
Guests- George Stedman/ Mitchell Glasscock
In episode six of the Stedman SQL podcast, Shannon Lindsay hosts George and Mitch to discuss new features in the database health monitor. They introduce a Quick Scan check for unscheduled SQL Server Agent jobs, which is particularly useful in cloud environments like RDS and Azure. Two major additions in release 1074 include a performance history instance report and a database-level file size over time report. The performance history report offers detailed charts for monitoring SQL Server performance metrics, while the file size report helps predict storage demands by tracking database growth. Additionally, color blind mode has been implemented, and real-time blocking and active queries charts are now available for each database. Future plans include line charts and a VLS page.
Episode 6 details page- Watch episode 6 now.
Stedman SQL Podcast Ep. 5 – Performance
Host- Steve Stedman and Shannon Lindsay
In episode five of the Stedman Solutions SQL Server podcast, Steve Stedman and Shannon Lindsay discuss common performance issues in SQL Server. They highlight the importance of indexing, emphasizing the need for proper index creation and avoiding multiple identical or single-column indexes. They address the impact of functions in the WHERE clause, excessive use of cross apply and correlated subqueries, and the necessity of regular database maintenance. Stedman also explains the significance of SQL Server isolation levels and the benefits of READ COMMITTED snapshot isolation. The episode concludes with a Q&A on SQL Server isolation levels and their impact on data.
Episode 5 details page -Watch episode 5 now.
Stedman SQL Server Podcast Episode 4- Replication
Host- Steve Stedman
Steve Stedman discusses SQL Server replication, highlighting its use in synchronizing data between servers. He covers snapshot, transactional, and merge replication, explaining their functionalities and limitations. Snapshot replication provides a one-time copy of data, but can be inefficient during updates. Transactional replication is useful for offloading reporting workloads but doesn’t allow changes on the subscriber side. Merge replication facilitates bi-directional data flow, but requires a rowguid column and can lead to conflicts. Stedman also addresses push vs. pull subscriptions, emphasizing their impact on SQL Server Agent jobs. The session concludes with a Q&A on parameter sniffing and a preview of the next episode on SQL Server performance.
Episode 4 Details page – Watch episode 4 now.
Stedman SQL Server Podcast Episode 3 – How important is your data? Exploring our IT Manager’s Whitepaper
Host- Steve Stedman
Steve Stedman emphasizes the critical importance of data in business operations, highlighting the severe consequences of data loss. He recounts a ransomware attack on a regional hospital that resulted in the complete loss of patient data and backups, underscoring the need for robust backup and business continuity plans. Stedman stresses the importance of regular testing of backups and having multiple data centers to minimize downtime. He shares a case study of a client who, after implementing a business continuity plan, recovered operations within an hour following a primary site failure. Stedman concludes by urging businesses to proactively protect their data to avoid disaster.
Episode 3 details page – Watch episode 3 now.
Stedman SQL Server Podcast Episode 2 – SQL Server Managed Services
Hosts – Steve Stedman / Shannon Lindsay
Guest – Craig Buchner
Steve Stedman and Craig Buchner discuss the benefits of SQL Server managed services, emphasizing stability, optimization, security, and business continuity. They highlight that managed services act as a cost-effective alternative to hiring full-time DBAs, offering comprehensive support for SQL servers. Key points include the ability to handle corruption repairs, performance optimization, and cloud migrations. Stedman Solutions has never lost a managed services client and has expanded its team to meet client needs. They stress the importance of proactive monitoring and expert team collaboration. Craig advises considering the cost of downtime and the expertise of managed service providers.
Episode 2 details page – Watch Episode 2 now.
Stedman SQL Server Podcast Episode 1 – New features in Database Health Monitor
Host – Steve Stedman
Guest – George Stedman – Mitchell Glasscock (Database Health Monitor Developers)
Steve Stedman announced the transition of their live stream to a weekly podcast called the Stedman SQL Podcast. Shannon will assist with editing and streaming. The team is planning six months of content, including SQL Server training and new features for the Database Health Monitor (DHM). George and Mitchell, developers of DHM, discussed recent updates, such as a consolidated instance report panel, new server overview sections for blocking and active queries, and a new color for stability indicators. They also added checks for large differential backups, update locks, user-defined assemblies, and database snapshots. Future plans include a new color mode, resizable panels, and a file size over time report.