SQL Server Radio

In this show, we talk about:

• What Happened in Samoa on December 30, 2011?
• Business Data Monitoring with Zabbix – Easily Done
• Matan Introduces Design Discussion #1
• Availability Group Parallel Redo
• Matan Introduces Design Discussion #2
• Power BI Desktop Q&A Data Interaction Examples

In this show, we are happy to welcome a special guest - Dekel Asaf, R&D manager at OM2. We talked about many things, among them:

• Always On - or "Mostly On"
• Why DBAs don't Use SSDT?
• Database Unit Testing
• Sliding Window

In this show, we talk about:

• Advanced Service Broker Sample: Asynchronous Triggers
• Azure SQL Database Availability Zones
• Microsoft Learn
• Magic Johnson
• Do You Trust Your Availability Group?

Can you believe it?

It's the 100th show!!!

We have been doing it for 5 years, and we are having so much fun!

We have been planning this show for a very long time, and we have some very special guests with us...

In this show we answered a listener's question about the 32-bit vs. 64-bit nightmare that developers have to go through when trying to access Excel files from SSIS.

And we also mentioned a script to roll forward transaction log backups.

The next show is the 100 show!!! We are planning a big party! Stay tuned...

In this show, we talk about:

• How to Fix Orphaned DB Users Easily
• SSMS Auto-Recovery Feature
• Multi-Tenant Database Challenges
• Your DR Plan isn't a Plan
• And much more...

Show Notes:

• How to Set Up Availability Group with a Domain Account
• How to Start SQL Server Without Tempdb?
• Auto-Commit vs. Implicit Transactions
• What's between Corruption and Blocking?
• What Machine Learning Can Do?