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

Dec 12, 2022

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:

• SQL Server 2022 is now generally available
• Consumption-based...

Nov 14, 2022

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:

• Buffer Pool Extension
• SQL Server editions comparison...