SQL Server Radio

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