SQL Server Radio

Guy Glantser is co-hosting with Eitan Blumin for the first time, and we have a lot of topics to cover and catching up to do. PASS and SQLBits Conferences Storage Best Practices for SQL on IaaS in Azure SQL VM RP (Resource Provider) Guy's hopes for SQL Server setup options SQL Server 2019 features And more

After a very long break, today we come to you with a very special show, with a very special announcement to make. You do not want to miss this one!

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

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

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

In this show, we talk about: What Happened in  Samoa  on December 30, 2011? Business Data Monitoring with Zabbix – Easily Done Matan Introduces Design Discussion #1 Availability Group Parallel Redo Matan Introduces Design Discussion #2 Power BI Desktop Q&A Data Interaction Examples

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