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

Jul 8, 2024

Guy and Eitan discuss some important and interesting news from Microsoft about SQL Server, Straight Path Solutions publish 30 articles about SQL Server security checks, Guy talks about his experience with Excel, and Eitan is irritated about people still not doing SQL jobs correctly in AlwaysOn Availability...