Aug 30, 2018
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...
Aug 16, 2018
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...
Jul 26, 2018
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?
Jul 12, 2018
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...
Jun 21, 2018
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...