Jan 13, 2025

Guy and Eitan talk about SQL Server 2025 (well, they try to, at least), and its various interesting upcoming features.

Relevant links:

• Announcing SQL Server 2025 – SQLServerCentral
• What's New in SQL Server 2025 - Brent Ozar Unlimited®
• Optimized Locking - SQL Server | Microsoft Learn
• SQLBits is Coming Back to...

Dec 9, 2024

Guy and Eitan go over the most popular sessions released from the SQL PASS archive of 2023, and discuss some other topics.

Relevant links:

• Announcing Microsoft SQL Server 2025: Enterprise AI-ready database from ground to cloud - Microsoft SQL Server Blog
• Sessions Archive for 2023 - PASS Data Community Summit

Nov 11, 2024

Guy and Eitan discuss the common challenge of long-running database integrity checks (DBCC CHECKDB) and a solution to resolve it, and why do we need integrity checks at all?

Relevant links:

• PASS Data Community Summit
• Incremental Integrity Check for Large Databases - Eitan Blumin's blog
• SQL Server Integrity Check - by...

Oct 14, 2024

Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation.

Relevant links:

• Resources from Microsoft:
  • Preview release of SDK-style SQL projects in Visual Studio 2022 - Microsoft Community Hub
  • Native JSON support now in preview in Azure...

Sep 9, 2024

Fair warning for all listeners!

Before starting to listen to this podcast, very strongly recommended:

Have the diagram at the bottom of this page ready in front of you, so that it'll be easier for you to follow along:

• Common Causes and Troubleshooting Solutions for SQL AG Data Synchronization Latency - Microsoft...