Guy is back from New Zealand. We talk a little bit about his trip, about things that people shouldn't be doing with SQL Server, and more.

Guy is in New Zealand, so Eitan Blumin comes to fill in. We talk about:

• CI/CD with SSDT
• What is a Canary Query
• The best performance tuning feature, ROI wise
• Hierarchical partitioning
• Azure storage for SQL Server

In this show:

• MySQL, Vertica, Azure Data Explorer and Matan
• 24 Hours of PASS: Summit Preview 2019
• PASS Summit 2019: Session Schedule
• The Data Bias in Song Contests
• How SQL Server Compares Strings with Trailing Spaces
• Using Azure Data Explorer and Fastly to Improve Taboola Customer Experiences
• Kusto in Taboola – Azure Data Explorer

We had a technical issue with this month's recording, so instead we're going back to one of our favorite shows – Big Mistakes with Brent Ozar. Enjoy, and we'll be back with new stuff in a few weeks.

Among other mistakes, we talk about:

• How did a company end up with a table named "C" Brent's first database disaster ever
• Why Guy spent two weeks in Microsoft Belfast Fire in the data center
• How does a manager need to respond during a crisis How should you react when you mess up

In this show:

• Multi-Tenant Architecture Optimizations
• Parallel Update Statistics
• What's the Difference between CONTEXT_INFO and SESSION_CONTEXT?
• New Innovations for Analytics in Azure
• Gartner Hype Cycle
• SQL Notebooks in Azure Data Studio
• SQL Server 2017 Resumable Online Index Rebuilds

Matan is really passionate about Azure Data Explorer. He presented a session about it in the last Data Platform Meetup in Israel. In this show, Matan introduces this powerful analytics platform.

Check it out: Azure Data Explorer

In this show:

• What a Great Event SQL Saturday Israel 2019 Was
• What is the Fastest-Growing Major Programming Language in the World?
• Exploring Azure Storage for SQL Server DBAs
• How Microsoft Access is Ranked among Database Management Systems?
• Understanding Log Buffer Flushes

• SQL Pub Quiz
• The Keynote
• How to Make Sure Your SSIS Packages Will Never Fail by Guy Glantser
• Benchmarking in the Cloud by Gianluca Sartori
• Common Troubleshooting Techniques for AGs and FCIs by Allan Hirt
• Failover Detection Utility – Availability Group Failover Analysis Made Easy
• What's New - Query Performance Insights by Pedro Lopes
• Top 5 Tips to Keep Always On AGs Humming and Users Happy by Matt Gordon
• The SQLBits Party
• Patterns and Best Practices in SSIS by Richard Munn
• Build Hybrid Data Platform with Azure SQL Database and SQL Server by Kevin Farlee
• SQL Leadership Q&A by Microsoft
• PowerShell Medley by Jonathan Allen
• Validate Your SQL Server Estate with Ease Using dbachecks by Rob Sewell
• Select Stars: A SQL DBAs Introduction to Azure Cosmos DB by Bob Pusateri

In this show, we talk about:

• SQLBits 2019
• Guy is Bragging about Tel Aviv Marathon
• Microsoft Helps You Transform Your 2008 Server Applications with Azure
• MongoDB Database Skills - Sia Cheap Thrills Parody
• Matan is Bragging about Azure Data Explorer
• SQL Saturday Israel 2019
• Beware of MIN/MAX Aggregates Against Partitioned Tables