Jun 12, 2023

As promised in the previous episode, Guy and Eitan interview an actual human this time!

The one and only, the famed Erik Darling is our guest for today!

Check out his official website:

• Erik Darling Data
• Erik Darling's YouTube Channel

We apologize in advance for Guy's occasional audio glitches, as he was having network...

May 8, 2023

Guy and Eitan try something new for today's show - we interview ChatGPT as our guest for today, and make it pretend that it's a SQL Server expert!

Let's see how it does.

Relevant links:

• Monitor performance by using the Query Store
• Brent Ozar Unlimited
• SQLSkills
• Scary DBA
• SQL Authority
• PASS Data Community Summit

Apr 10, 2023

Guy and Eitan share their experience from SQLBits 2023 and some of their favorite sessions.

Relevant links:

• Official SQLBits Website
• SQLBits Content Library
• SQLBits YouTube Channel
• SQL Server Debugging with WinDbg – an Introduction
• Join #TeamHugo and Help Fight Leukemia
• Parameter Sensitive Plan optimization
• Azure...

Mar 13, 2023

Guy and Eitan discuss some new and existing capabilities in the SQL Server engine related to Intelligent Query Processing, and whether our job positions as DBAs are at risk due to the imminent takeover by our robot overlords.

Relevant links:

• Intelligent Query Processing
• Adaptive Joins (Batch)
• Intelligent Query...

Feb 13, 2023

Guy and Eitan list several common mistakes done by DBAs in SQL Server.

Some relevant links:

• Architecting Database Dev and Test Environments: Best Practices and Anti-Patterns for SQL Server
• Ola Hallengren's Maintenance Solution
• HADR My Jobs - Open Source Solution by Madeira
• Columnstore Indexes: Planning...