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...

Jan 9, 2023

Today we have the pleasure of hosting Rob Sewell, and talking about the upcoming SQLBits event of 2023!

Relevant links:

• SQLBits 2023 agenda, speakers, pricing, and registration - events.sqlbits.com/2023
• YouTube playlist of all 195 sessions from SQLBits 2022 - available for free!
• SQLBits helpers form...