154 episodes

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 Guy Glantser, Eitan Blumin

    • Technology

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.

    Episode 164 - The Good the Bad and the Ugly Transactional Replication

    Episode 164 - The Good the Bad and the Ugly Transactional Replication

    Guy and Eitan continue discussing HADR solutions. But this time focusing on Transactional Replication, its cons and pros and potential use cases.
    Also, some important announcements from Microsoft about Azure SQL!
    Relevant links:
    Data API builder General Availability (microsoft.com) Build REST API with Azure Data API Builder (DAB) (mssqltips.com) Zero ETL, Near-real time replication, Mirroring Azure SQL Databases in Fabric (microsoft.com) Announcing EAP for Vector Support in Azure SQL Database - Azure SQL Devs’ Corner (microsoft.com) Update Policy for Azure SQL Managed Instance - Microsoft Community Hub Transactional Replication - SQL Server | Microsoft Learn MadeiraData/ReplicationManagementMechanism: Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures (github.com)

    • 35 min
    Episode 163 - When and Why to HADR

    Episode 163 - When and Why to HADR

    Guy and Eitan discuss the various High Availability and Disaster Recovery options available to us in Microsoft SQL Server, their main advantages, limitations, and when it's most suitable to use or not to use them.
    Relevant links for further reading:
    AlwaysOn Basic Availability Groups / Database Mirroring AlwaysOn "Enterprize" Availability Groups Failover Cluster Instance Log Shipping Transactional Replication

    • 34 min
    Episode 162 - Backups and Recovery, RTO, RPO, and RCO

    Episode 162 - Backups and Recovery, RTO, RPO, and RCO

    Guy and Eitan talk about some interesting news from Microsoft about SQL Server in Azure.
    And also discuss the topic of Backups and Recovery, RTO, RPO, RCO, and database Integrity Checks.
    Relevant links:
    Microsoft Copilot in Azure extends capabilities to Azure SQL Database (Private Preview) - Microsoft Community Hub Regex in SQL DB (microsoft.com) SQL Server Regular Expressions Library Sample - Microsoft Community Hub STRING_SPLIT (Transact-SQL) - SQL Server | Microsoft Learn Do You Have a Proper Backup Strategy? (madeiradata.com) CHECKDB From Every Angle: Consistency Checking Options for a VLDB - Paul S. Randal (sqlskills.com) Where to Run DBCC on Always On Availability Groups - Brent Ozar Unlimited®  
    Also, check out our previous episode, if you haven't yet:
    SQL Server Radio: Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes)

    • 35 min
    Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes)

    Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes)

    Niko Neugebauer and Vladimir Ivanovic are our esteemed guests for today, and they have a HUGE announcement to make about Azure SQL Managed Instances.
    Extra! Extra! 🗞 Hear all about it on this exclusive scoop here at the SQL Server Radio podcast!
    Relevant links:
    Azure SQL Managed Instance Next-gen GP (microsoft.com) Use Next-gen General Purpose service tier - Azure SQL Managed Instance | Microsoft Learn Try for free (preview) - Azure SQL Managed Instance | Microsoft Learn Next-gen General Purpose service tier brings 500 user dbs, improved storage and more to Azure #SQLMI (youtube.com) (2 min video)

    • 41 min
    Episode 160 - OPTION RECOMPILE and the magical Turbo button

    Episode 160 - OPTION RECOMPILE and the magical Turbo button

    Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated.
    Relevant links for more info:
    OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn Recompile a Stored Procedure - SQL Server | Microsoft Learn Should I use option(recompile)? – SQLServerCentral SQL SERVER - Parameter Sniffing and OPTION (RECOMPILE) - SQL Authority with Pinal Dave

    • 32 min
    Episode 159 - Select * Wastes Money

    Episode 159 - Select * Wastes Money

    Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager.
    Relevant links:
    SQL Server IN Clause With Multiple Literal Values Performance Behaviour | Neeraj Prasad Sharma Could SQL Injection be dangerous even when perfectly safe? | Eitan Blumin The Anatomy of Vardecimals | Mark S. Rasmussen Utility Scripts/ReNumber_Identity_Column.sql Introducing Azure Database Fleet Manager Also, Happy New Year! 🎉🎈🥂

    • 37 min

Top Podcasts In Technology

Search Engine
PJ Vogt, Audacy, Jigsaw
Acquired
Ben Gilbert and David Rosenthal
Lex Fridman Podcast
Lex Fridman
All-In with Chamath, Jason, Sacks & Friedberg
All-In Podcast, LLC
Hard Fork
The New York Times
Darknet Diaries
Jack Rhysider

You Might Also Like

Dear SQL DBA
Kendra Little
SQL Data Partners Podcast
Carlos L Chacon
SQL Down Under
Dr Greg Low
Voice of the DBA
Steve Jones
The Rich Roll Podcast
Rich Roll
Freakonomics Radio
Freakonomics Radio + Stitcher