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

Jun 10, 2024

Guy and Eitan continue discussing HADR solutions. But this time focusing on Transactional Replication, its cons and pros and potential use cases.

Also, some important announcements from Microsoft about Azure SQL!

Relevant links:

• Data API builder General Availability (microsoft.com)
• Build REST API with Azure Data API...

May 13, 2024

Guy and Eitan discuss the various High Availability and Disaster Recovery options available to us in Microsoft SQL Server, their main advantages, limitations, and when it's most suitable to use or not to use them.

Relevant links for further reading:

• AlwaysOn Basic Availability Groups / Database Mirroring
• AlwaysOn...