SQL Server Radio

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?

Show 96 is here. Among other stuff, we talked about: 

• SQLGrillen 2018
• Simulating IGNORE NULLs Functionality on FIRST_VALUE and LAST_VALUE Functions
• Database Corruption Story
• Query Store, Automatic Query Tuning, and how they relate to automatic card

it's been very busy lately, and Guy is currently abroad, so we're posting something a little different.

For the 100th show of the Hebrew edition, we celebrated with 5 panels about different topics we held on SQLSaturday Israel.

One of the panels was about programming best practices in SQL Server, and conveniently, it was in English.  

We'll be back in two weeks with a regular show.

Enjoy!

In this show, we talk about:

• Google Duplex
• Accessing External Resources from SQL Server
• SQL Saturday Israel 2018
• 24 Hours of PASS
• Optimizing Server-Side Paging
• How to Change the Fonts in SSMS
• And more..

Today in the show, we solve (well, almost) a SQL Server crossword by Kenneth Fisher...

Today in the show:

• The Best SQL Server Five-Words Tech Horror
• MongoDB Aggregation Feature in Azure Cosmos DB
• Data Discovery and Classification in SSMS
• Managing Multi-Tenant Applications
• Which One is Better? IN or BETWEEN?

Today in the show:

• How to Schedule a Failover
• Use Inline Functions Instead of Scalar Functions
• Guy’s Productivity Guide
• Maintenance Plans Security Hole!
• And More…

Today in the show:

• SSMS Unuseful Tips
• Why Database Continuous Integration is Challenging?
• Monitoring Page Splits

Today in the show:

• How to Deploy Schema Changes with Zero Downtime
• We are All Experts in Identifying Cats
• How to Troubleshoot Application Timeouts
• Signs You are not a Senior DBA
• SQL Saturday Israel Precons Announced