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