Sql Server Radio

Today we go over a list written by Kevin Chant about a year ago, and add some of our own insights. Relevant links: Ten comments I think every SQL Server DBA wants to say | Kevin Chant Eitan's T-SQL Tuesday blog posts about automation and productivity: T-SQL Tuesday #123 – Life hacks to make your day easier T-SQL Tuesday #127 – Tips and Tricks to Automate Your Life T-SQL Tuesday #130 – Eitan’s Laws of Automation T-SQL Tuesday #135: The Tools of My Trade Test-DbaBackup Powershell cmdlet for automated restore tests Maintenance Script for Integrity Checks split into buckets per weekday How to Find which user deleted the database in SQL Server SQLWatch.io

We have two very special guests in today's show: the AzureSQL rockstars Anna Hoffman and Bob Ward! Some relevant links: Azure SQL Fundamentals | Microsoft Learn Azure SQL for beginners | YouTube Playlist Digital event: Transform Your Applications with Azure SQL http://aka.ms/newsupdate https://aka.ms/sqlworkshops DataMinutes | Data Grillen SQL Saturday official site

Guy and Eitan discuss lots of interesting recent news, and also about various technical topics in SQL Server. Relevant links: News about PASS and SQL Saturday: What’s next for PASS Summit this fall? Ideas forum The SQL Saturday Foundation Board of Directors The new Azure Data Community webpage from Microsoft PASS Summit 2020 session recordings PASS Pro Educational Series at Red Gate University Data Saturday #1 Recordings Available on YouTube Around the Clock with Azure SQL and Azure Data Factory Microsoft Ignite 2021 Book of News Azure retiring a lot of services on February 29, 2024 Azure Tips and Tricks: 5 Things you didn't know about Azure SQL Database SQL Server Automatic Tuning SQL Server Transaction Log And High Availability Solutions - Pros and Cons and more | Destin Joy Classic GUI issue or how to fix MAX Server memory too low | Vitaly Bruk

Check out the episode where we start movements to change the way everyone writes T-SQL code, and/or deliver data platform meetups! And we also talk about a bunch of other stuff as well. Relevant Links: Join the SQL Server Community Slack and our new channel #SQLServerRadio ! Ask Us Anything: Database Performance Tuning and Optimization | Data Platform Meetup Israel Redgate Software takes over from PASS and commits to the future of the Summit, SQLSaturday and the community Educational Series (Red-Gate University) Database DevOps Considerations for SQL Server Availability Groups GenerateDeployReport method of DacServices | Microsoft Docs Database DevOps Implementation | Madeira Data Solutions I learned to love WHILE (true) and you should too | Eitan Blumin We’re taking Azure certifications for data and AI to the next level | Microsoft Tech Community Azure Data Fundamentals: Explore Core Data Concepts (Part 1) | Microsoft Reactor Tel-Aviv Meetup Watching out for Deferred Name Resolution  

We have a special topic for today, where we talk about our own managed DBA service, and how we ended up choosing SentryOne SQL Sentry as our go-to monitoring platform for SQL Servers. Relevant links with more details: DBSmart - The Managed DBA Service from Madeira Data Solutions SentryOne SQL Sentry clr_http_request - CLR assembly to send HTTP web requests from within SQL Server Case study - UPDATE STATISTICS causing TempDB stress and Availability Group fail-overs Madeira Data Solutions is a SentryOne Partner

Guy and Eitan host a very special guest and speak about various SQL Server and Data Platform topics, and recent events. Relevant links: for more details Cassandra - Use cases: when to use and when not to use Community call for creating the fastest number series generator | Itzik Ben Gan SQL Server Feature Request: Adding Multi-column IN clause support by SQL Server mysqlbinlog — Utility for Processing MySQL Binary Log Files FAQ about the dissolution of PASS | Andy Mallon PASS alternatives and related links: SQLSatHistory.com SQLUGs.com DataSaturdays Project (SQLCollaborative) Microsoft resources for the SQL Server and Azure Data community SQL Governor - Proactive Microsoft SQL Server optimization, consolidation, and rightsizing powered by machine learning Columnstore indexes: Overview | Microsoft Docs The SolarWinds Orion Hack How to Protect SQL Server from Hackers and Penetration Tests | Eitan Blumin

Guy and Eitan take a break from talking about the PASS virtual summit, and celebrate with some interesting content. Relevant links: Notes on the PASS Virtual Summit by Andy Warren: Part 1 Part 2 Part 3 Part 4 Part 5 Part 6 Conclusions Satirical DBA Twitter accounts: @TrumpDBA @Bernie_DBA @biden_dba Concatenating Strings in SQL Server | Guy Glantser Making a more reliable and flexible sp_MSforeachdb | Aaron Bertrand PrintMAX by Ben Dill PrintMaxMinified by Eitan Blumin Access Violation Error querying from system functions with parallelism SQL Server Cumulative Update releases are paused until end of December SQL Server TOP clause performance problem with parallelism | Neeraj Prasad Sharma What is MaxDOP controlling? | Pedro Lopes

Our guest for today is Yitzhak Khabinsky, a subject-matter expert on XML in SQL Server (among other impressive titles). We deep dive into the topic of XML, its history, its purpose and limitations within SQL Server, and fascinating capabilities that you never knew about... And also, how does JSON fit in this whole story? Yitzhak Khabinsky | LinkedIn Azure Feedback item to update XML API engine in SQL Server Azure Feedback item to improve JSON capabilities in SQL Server

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