SQL Server Radio-logo

SQL Server Radio

Technology Podcasts

SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.

SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.

Location:

United States

Description:

SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.

Language:

English


Episodes

Episode 142 - What is Your Favorite Feature in SQL Server 2022?

7/11/2022
Guy and Eitan discuss their favorite upcoming new features in SQL Server 2022, and talk about some major upcoming events and summits. Relevant links: SQL Server 2022 public preview is now available on LinuxIntroducing the SQL Server 2022 blog series by Bob WardContained Availability Groups in SQL Server 2022 | Eitan BluminWhat is a contained availability group? | Microsoft DocsErik Darling Blog series about Parameter Sensitive PlansXML Data Compression in SQL Server 2022Link feature in...

Duration:00:16:12

Episode 141 - Howda Hadr Hader Hadader

6/13/2022
Guy and Eitan talk about a lot of exciting announcements and announcements about a lot of excitements! Does this even make sense? I don't know! Listen to the show to find out! Relevant links: How to HADR Your SQL JobsContained AlwaysOn Availability Groups OverviewPedro Lopes's Slides Deck for SQL Bits 2022How to Identify and Fix TempDB ContentionThe Best Solution for SQL Server Partitioning Sliding WindowRoll_Forward_Transaction_Log_Backups.sqlRestore-DbaDatabase (DbaTools)Tsql2sday - My...

Duration:00:34:39

Episode 140 - Migration Challenges

5/9/2022
Guy and Eitan discuss interesting challenges and news about migrations in SQL Server. Also, we talk about performance considerations of partitioning in SQL Server, a blog post series about how to tune performance, and new scripts in our Madeira Toolbox on GitHub. Relevant links: Data-tier Applications (DACPAC and BACPAC)About: Snapshot ReplicationGenerally available: Azure Virtual Machines increase storage throughput by up to 300%Generally available: Announcing Azure SQL Migration...

Duration:00:22:42

Episode 139 - What's New in 2022

4/11/2022
Guy and Eitan discuss upcoming events and conferences in 2022, and also about new features in SQL Server 2022, and more. Relevant links: SQL Server & Azure SQL ConferenceData Platform Virtual Summit 2022DataGrillenPASS Data Community Summit 2022Get Ready for SQL Server 2022Get Azure recommendation in Azure SQL Migration extensionLinked Server Vulnerability.sqlMaintenance of Azure SQL Databases via Azure Automation and PowershellBalance CPU Cores Across NUMA Nodes.sqlDatabase Design Best...

Duration:00:16:59

Episode 138 - EverSQL

3/14/2022
In today's show, Guy and Eitan host the co-founders of EverSQL, Oded Valin and Tomer Shay. We talk about their automated SQL tuning solution and SQL tuning best practices in general. eversql.com - Official WebsiteSoftware Vendor Mistakes - Erik Darling Data

Duration:00:32:41

Episode 137 - It's That Time of the Month

2/14/2022
It's that time again! The time to talk about SQL Server! We got a bunch of different topics to talk about on this show. Relevant links: Cardinality Estimation: Combining Density Statistics | Paul WhiteSQL Server CE: Multiple single-column statistics connected by ANDSQL Server CE: Multiple single-column statistics connected by ORDetect Low PAGE Compression Success Rates in all Databases | Eitan BluminThe Curious Case of… tracking page compression success rates | Paul Randal The Ultimate...

Duration:00:35:15

Episode 136 - On the First Day of Christmas I got a TSQL Script

1/10/2022
Guy and Eitan discuss some interesting announcements and focus on the topic of Security in SQL Server. Relevant links: Announcing new features for the SQL IaaS Agent Extension! - Microsoft Tech CommunityTroubleshooting SQL Server made easy via Notebooks – seeking your feedback - Microsoft Tech CommunityVeeam security breach: Backup “Removal” Solutions - From Conti Ransomware With Lovesp_helprotect is very useful in permission issue - Microsoft Tech CommunityDatabases and Guests - Vitaly...

Duration:00:38:10

Episode 135 - Announcing SQL Server 2022

12/13/2021
Guy and Eitan talk about the interesting new features announced in SQL Server 2022, a new sp_whoisactive version, and a bunch of Microsoft blog posts on Tech Community. Relevant links: SQL Server 2022:Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovationIntroducing SQL Server 2022 | Bob WardAnnouncing the SQL Server 2022 Early Adoption ProgramSQL Server 2022 | Official MicrosoftThe new version of sp_whoisactive - v12.00Extended Events to the...

Duration:00:31:05

Episode 134 - Availability Sets in Azure and SQL Server

11/8/2021
Guy and Eitan talk about some important news, about Availability Sets in Azure, and several useful T-SQL scripts in our Toolbox. Relevant links: Azure Feedback is back!Troubleshooting SQL Server made easy via Notebooks – seeking your feedbackOpen sourcing the .NET 5 C# Language Extension for SQL ServerReplication enhancements in the SQL Server 2019 CU13 releaseSQL Server 2022Check it out hereAvailability Sets for Virtual Machines in AzureCertificate Management ScriptsShrink All Shrinkable...

Duration:00:46:19

Episode 133 - Good news, everyone!

10/11/2021
Guy and Eitan talk about various topics related to SQL Server, including upcoming virtual events, interesting new scripts from our toolbox, and more! Relevant links: SQL Server 2016 SP3: Last Service Pack for SQL ServerSQL Server Release Dates and Product LifecyclePASS Data Community Summit - November 8-12, 2021Development Lifecycle Basics for DBAsGroup By Conference 2021SSDT Methodologies & Features for DB DevOpsLevel up your skills with Bicep!TRY...CATCH (Transact-SQL)@@TRANCOUNT...

Duration:00:49:04

Episode 132 - Blythe Morrow

9/13/2021
Are you a data professional who needs to be able to convince people that you're right? Blythe Morrow is here to help! Blythe Morrow is our special guest for today, teaching us tech folks how to talk and convince people about topics in regards to Data Platform technologies. Blythe Morrow on LinkedInBlythe Morrow is a Pre-Con speaker at PASS Data Community SummitBlythe Morrow in: Meet the Pre-Con SpeakersPaper Sword B2BPaper Sword B2B is also the agency behind the Group By Conference

Duration:00:56:32

Episode 131 - The First Madeira Toolbox Round-Up

8/9/2021
Guy and Eitan discuss change automation tricks for databases, do a round-up of the newest scripts in the Madeira Toolbox, and more. Relevant links: DbaToolssp_generate_merge by Daniel Nolan (readyroll)Add support for "Prevent saving changes that require table re-creation" option in SqlPackage / SSDT (Azure Feedback)(New feedback item at Microsoft Q&A)Madeira Toolbox Round-Up:Missing Indexes with High ImpactIncrease Database File in Specified IncrementsSSRS Deployment Powershell...

Duration:00:54:48

Episode 130 - We just talk about stuff

7/12/2021
Guy and Eitan shoot the breeze about several interesting topics that you wouldn't want to miss out on! Relevant links: SQL Server 2016 going out of mainstream supportIntelligent Query Processing Capabilities in SQL ServerGroup by conference recordings on YouTubeDynamic search queries in T-SQL - THE NINJA WAY - by Eitan BluminSQL Data Partners Episode 227: SSDT Methodologies for DB DevOpsCall for SpeakersWait Statistics - Torsten StraussGreat Reasons to Run Your Cloud App on Azure SQL MI -...

Duration:00:58:29

Episode 129 - 10 Comments Every DBA Wants to Say

6/7/2021
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 ChantT-SQL Tuesday #123 – Life hacks to make your day easierT-SQL Tuesday #127 – Tips and Tricks to Automate Your LifeT-SQL Tuesday #130 – Eitan’s Laws of AutomationT-SQL Tuesday #135: The Tools of My TradeTest-DbaBackup Powershell cmdlet for automated restore testsMaintenance Script for Integrity Checks split into...

Duration:00:44:15

Episode 128 - Azure and SQL with Anna and Bob

5/10/2021
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 LearnAzure SQL for beginners | YouTube PlaylistDigital event: Transform Your Applications with Azure SQLhttp://aka.ms/newsupdatehttps://aka.ms/sqlworkshopsDataMinutes | Data GrillenSQL Saturday official site

Duration:00:54:47

Episode 127 - The Red-Gate-took-over-and-now-we-get-free-stuff Summit

4/12/2021
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 YouTubeAround the Clock with Azure SQL and Azure...

Duration:00:43:30

Episode 126 - Leading a Zeitgeist in the SQL Server Community

3/8/2021
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 IsraelRedgate Software takes over from PASS and commits to the future of the Summit, SQLSaturday and the communityEducational Series...

Duration:00:42:57

Episode 125 - Monitoring SQL Servers for a managed DBA service

2/8/2021
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 SolutionsSentryOne SQL Sentryclr_http_request - CLR assembly to send HTTP web requests from within SQL ServerCase study - UPDATE STATISTICS causing TempDB stress and Availability Group fail-oversMadeira Data Solutions is a...

Duration:00:39:30

Episode 124 - The Vanguards of Data

1/11/2021
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 useCommunity call for creating the fastest number series generator | Itzik Ben GanSQL Server Feature Request: Adding Multi-column IN clause support by SQL Servermysqlbinlog — Utility for Processing MySQL Binary Log FilesFAQ about the dissolution of PASS | Andy...

Duration:00:36:06

Episode 123 - Beware of the Parallel Plan

12/14/2020
Guy and Eitan take a break from talking about the PASS virtual summit, and celebrate with some interesting content. Relevant links: Part 1Part 2Part 3Part 4Part 5Part 6Conclusions@TrumpDBA@Bernie_DBA@biden_dbaConcatenating Strings in SQL Server | Guy GlantserMaking a more reliable and flexible sp_MSforeachdb | Aaron BertrandPrintMAX by Ben DillPrintMaxMinified by Eitan BluminAccess Violation Error querying from system functions with parallelismSQL Server Cumulative Update releases are...

Duration:00:55:00