SQL Server Radio

Guy and Eitan discuss PASS Virtual Summit 2020, what we should expect, whether it's worth the price tag or not, and discuss the future of the PASS organization.

Relevant links:

• https://www.pass.org/summit/2020/ 
• Imagine All the People | Guy Glantser
• SELECT TOP (3) Pre-Conference Sessions | Guy Glantser
• Why I’m Not Speaking at PASS Summit and You Shouldn’t Either | Joey D'Antoni
• https://sqlsaturday.com/
• https://pass.org/
• https://meetup.com/
• https://sessionize.com/
• https://sqlfriday.net/
• https://groupby.org/
• https://dataweekender.com/
• https://tsqltuesday.com/
• https://curatedsql.com/
• Eitan Blumin is a Data Platform MVP!

Guy and Eitan talk about recent and upcoming virtual events, and discuss the newly available runtime statistics at the operator-level in actual execution plans.

Relevant links:

• Data Platform Virtual Summit 2020
• Development Lifecycle Basics for DBAs - PASS Application Development Virtual Group
• Data Weekender #TheSQL Oct 17th
• SQL Workshops (Microsoft repository in GitHub)
• GroupBy.org
• Starting SQL: Measuring A Query (Eric Darling)
• SSRS with Basic Authentication (open-source sample project)
• SQL Friday #16: Eitan Blumin on “How to HADR Your SQL Jobs”
• The Most Important Performance Factor in SQL Server
• What does It Mean to Be an MVP? (Guy Glantser)
• See the Actual Execution Plan for any query

Guy and Eitan talk about Virtual Summits and free online courses, how to override SSRS authentication, and learn how to pronounce Eitan's name.

Also, we're terribly sorry in advance for the windy interferences!

Links:

• PASS Virtual Summit
• Modernizing Your Data Platform by Guy Glantser
• Azure SQL Bootcamp with Bob Ward & Anna Hoffman
• Free Courses by Kendra Little
• How to start with Azure Data Explorer - A new online course
• Overriding SSRS Authentication | Eitan Blumin
  • ReportViewerWrapper | Stefan Steiger
  • AspNetCore.ReportViewer | Stefan Steiger
  • SSRS Custom Security Extension Example | Microsoft GitHub
  • SSRS 2016 Anonymous Authentication (via Custom Security Extension) | Frans van der Geer
  • Configure Basic Authentication on the Report Server | Microsoft Docs

Guy and Eitan talk about several workarounds that boil down to using a solution for something other than its intended purpose.

Relevant links:

• Moving A Database to New Storage With No Downtime | Bob Pusateri
• Planning a Migration from Azure SQL DB to Azure Managed Instance | Eitan Blumin
• The Internals of the External SqlPackage Tool - Inside a bacpac File | Ronen Ariely (Data Platform Meetup Israel)
• Editing a .bacpac file | Microsoft Tech Community
• Blog post about Azure SQL Analytics | Eitan Blumin
• CosmosDB to SQL Server Migration Utility | Eitan Blumin
• TSQLEventsCollector Extended Events Buffer | Eitan Blumin (Gist)
• TSQLErrorsCollector Extended Events Buffer | Eitan Blumin (Gist)

Today we talk about all the exciting free events that we were involved with during May, with even more to come, and also some other interesting news!

Check them out:

• The Performance Tuning Magic Show by Guy Glantser (PASS Application Development)
• Accelerated Database Recovery by Guy Glantser (PASS Global Hebrew Virtual Chapter)
• SQL Server Setup Best Practices by Guy Glantser (GroupBy.org)
• Data Weekender Europe
• Development Lifecycle Basics for DBAs by Eitan Blumin
• SSDT Template with tSQLt and Azure Pipeline by Sander Stad
• Control SQL Jobs based on HADR Role – Taking it to the Next Level by Eitan Blumin
• Official SQL PASS Bloggers Lineup
• SELECT TOP (3) Pre-Conference Sessions by Guy Glantser
• SQL Friday
• Madeira Live Webinars in Hebrew
• Madeira Toolbox on GitHub
• Using Extended Events as an Events Buffer

Today's show notes are quite a handful!

• Red Gate report about the State of Database DevOps
• Eitan's session about Development Lifecycle Basics for DBAs
• Free  online  conferences  and  events:
  • Data Community Weekender Europe
  • Data Platform Discovery Day
  • GroupBy
  • DataPlatformGeeks Virtual Symposium
  • PASS Recordings Listing
  • Red-Gate Streamed
  • SentryOne Webinars
  • T-SQL Tuesday LIVE
  • Data Platform Meetup Israel
  • PASS Global Hebrew Virtual Chapter
• Free stuff from Madeira Data Solutions:
  
  • Free Webinars in Hebrew
  • Madeira Toolbox
  • Blog posts
• Some SQL Server technical stuff:
  • SQL Server Management Studio 18.5
  • How to migrate SQL data to Azure Cosmos DB
  • Microsoft Learn Module - Choosing Your Storage Approach in Azure

Eitan does his worst Donald Trump impression, and talks SQL Server stuff with Guy Glantser:

• Ola Hallengren's maintenance solution
• SQL Server Index Maintenance – You’re Doing It Wrong | Sean Gallardy
• Because Your Index Maintenance Script Is Measuring The Wrong Thing | Erik Darling
• How can UPDATE STATISTICS cause HADR disconnections?
• Eitan's File Size Maintenance Solution
• MCSA, MCSD, MCSE certifications retire; with continued investment to role-based certifications
• Azure SQL Managed Instance Performance Considerations | Tim Radney
• Azure Windows VM Sizes
• And more

This episode was recorded on March 8th, at the Microsoft for Startups podcast room in Tel-Aviv

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

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