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

Aug 12, 2024

Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible.

Relevant links:

• 101 of Troubleshooting SQL Server on Linux - Microsoft Community Hub
• bcp utility - SQL Server | Microsoft Learn
• Altering lock...