Episode 164 - The Good the Bad and the Ugly Transactional Replication
Release Date: 06/10/2024
Episode 176 - SQL Server 2025 and more
SQL Server Radio
Many announcements and interesting releases came out this past month, so we got a lot to talk about in this episode! Relevant links:
info_outline
Episode 175 - Migrating from on-prem to AWS RDS
SQL Server Radio
Guy talks about a recent migration project he was working on to move an on-prem SQL Server to AWS RDS. Eitan talks about a new AI-related feature in Azure SQL Databases. And we also discuss the new SNAPSHOT backup T-SQL command in SQL Server 2022. Relevant links:
info_outline
Episode 174 - Is SQL Server quality in decline? Or is it just friction?
SQL Server Radio
Guy and Eitan worry about the decline in SQL Server feature quality. But maybe there's something else behind it? Relevant links:
info_outline
Episode 173 - SQL Noir and the fate of Azure Data Studio
SQL Server Radio
Guy and Eitan discuss a few interesting topics. Including a fun new game called "SQL Noir", how to implement statistical clustering model in SQL, about surrogate and natural keys, and the recently announced deprecation of Azure Data Studio. Relevant links:
info_outline
Episode 172 - Between SQL Squid Games and SSMS
SQL Server Radio
Guy and Eitan answer an interesting question from the forum regarding the logic of NOT BETWEEN. And also, checking out the SQL Squid Game, discussing SQL Audit, and sharing some tips for SSMS. Relevant links: Tell us how you did and whether you survived the SQL Squid Game! 😉
info_outline
Episode 171 - Clueless about SQL Server 2025
SQL Server Radio
Guy and Eitan talk about SQL Server 2025 (well, they try to, at least), and its various interesting upcoming features. Relevant links:
info_outline
Episode 170 - Interesting topics from PASS 2023 sessions
SQL Server Radio
Guy and Eitan go over the most popular sessions released from the SQL PASS archive of 2023, and discuss some other topics. Relevant links:
info_outline
Episode 169 - Resumable Incremental Database Integrity Checks
SQL Server Radio
Guy and Eitan discuss the common challenge of long-running database integrity checks (DBCC CHECKDB) and a solution to resolve it, and why do we need integrity checks at all? Relevant links:
info_outline
Episode 168 - New data types in SQL Server and a question about index fragmentation
SQL Server Radio
Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation. Relevant links: Resources from Microsoft: Index fragmentation: Index fragmentation scripts: Upcoming webinar at the Cloud Data Driven Meetup:
info_outline
Episode 167 - Let's Troubleshoot SQL AG Synchronization Latency
SQL Server Radio
Fair warning for all listeners! Before starting to listen to this podcast, very strongly recommended: Have the diagram at the bottom of this page ready in front of you, so that it'll be easier for you to follow along: (sorry in advance!) Additional relevant links:
info_outlineGuy 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)