Episode 160 - OPTION RECOMPILE and the magical Turbo button
Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated.
Relevant links for more info:
Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated.
Relevant links for more info:
Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager.
Relevant links:
Also, Happy New Year! 🎉🎈🥂
Guy and Eitan talk about some great things about SQL Server, and mostly Guy’s experience in digging into execution plans and generating synthetic IO workloads.
Relevant links:
SQL Server Radio is going on a short break this month.
Please tune in next month for when we'll be coming back!
In the meantime, check out some of our favorite past episodes:
Guy and Eitan go back to their SQL Server roots and go hardcore into execution plan analysis and database corruption.
Relevant links:
Guy and Eitan celebrate resuming the school year with some learning of their own. This time, focusing on encryption types in SQL Server.
Relevant links:
PWDENCRYPT and PWDCOMPARE
And also, don’t forget to register for the upcoming Data TLV Summit!
Today we have Kevin Chant as our guest!
We talk about Kevin’s favorite topics: Microsoft Fabric, Azure DevOps, SQL Server, and more.
Relevant links:
Guy and Eitan discuss several interesting topics and recent experiences that you'd want to hear about!
Relevant links:
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:
We apologize in advance for Guy's occasional audio glitches, as he was having network issues on the day of recording.
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:
Guy and Eitan share their experience from SQLBits 2023 and some of their favorite sessions.
Relevant links:
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:
Guy and Eitan list several common mistakes done by DBAs in SQL Server.
Some relevant links:
Today we have the pleasure of hosting Rob Sewell, and talking about the upcoming SQLBits event of 2023!
Relevant links:
Guy and Eitan finally celebrate the generally available release of SQL Server 2022! And also discuss other announcements from PASS Data Community Summit, and also various interesting news and features of Azure SQL announced in November 2022.
Relevant links:
Guy and Eitan play a game of word associations to spout a bunch of stuff about SQL Server features - mostly reviewing new system objects that replaced old DBCC commands, useful scripts in our toolbox, and talking about Application Reliability Errors.
Relevant links:
Today we're pleased to have the one and only Itzik Ben-Gan hosted at our show again!
We talk about interesting SQL/T-SQL related topics, the experience of teaching, his new upcoming book edition of T-SQL Fundamentals, and more.
Relevant links:
Guy and Eitan discuss a few new features in SQL Server 2022, and Guy tells a story about an interesting use case where a customer accidentally dropped their encryption keys in production.
Relevant links:
Today, Guy has a lot of tips to share after reviewing one of those... "problematic" customer environments. Let's just say that he's got his hands full. But it's still fun, and you get to learn as well!
Relevant links:
Guy and Eitan discuss their favorite upcoming new features in SQL Server 2022, and talk about some major upcoming events and summits.
Relevant links:
Stay up to date
For any inquiries, please email us at hello@podcastworld.io