logo
episode-header-image
May 13
30m 6s

Episode 187 - Transactional Replication ...

Guy Glantser, Eitan Blumin
About this episode
tail spinning
Up next
Jun 8
Episode 188 - Virtualization pitfalls and best practices with SQL Server
Guy talks about an interesting incident involving performance problems in a virtual environment. And also, we talk about the SSMS StatisticsParser extension and the question of SSMS extensions in general. Relevant links: vmware.com/docs/sql-server-on-vmware-best-practices-guide H ... Show More
29m 33s
Apr 13
Episode 186 - Automatic Index Compaction and New DB DevOps Tooling
Guy and Eitan discuss several very interesting new features recently announced by Microsoft. Relevant links for more info: Stop defragmenting and start living: introducing auto index compaction | Microsoft Community Hub Automatic Index Compaction - SQL Server | Microsoft Learn Da ... Show More
31m 16s
Mar 9
Episode 185 - The Liar's Dividend
Guy and Eitan talk about Erik Darling's new monitoring app, which reminds us of similar tools we had experience with long ago. And, again, it's time to talk about AI. Specifically, a side-effect of it called "The Liar's Dividend". Relevant links for more information: Free SQL Ser ... Show More
35m 30s
Recommended Episodes
Apr 2025
Sequential Scans in Postgres just got faster
This new PostgreSQL 17 feature is game changer. They know can combine IOs when performing sequential scan. Grab my database coursehttps://courses.husseinnasser.com 
27m 36s
Aug 2024
803: The SQLite Takeover with Turso’s Glauber Costa
Scott and Wes chat with Glauber Costa from Turso about the evolution of databases and the fascinating technology behind Turso. They dive into topics like the benefits of massive multi-tenancy, vector search, and why Glauber made the switch from NoSQL to relational databases. Sho ... Show More
1 h
Sep 2017
Do I Need to Master PowerShell?
As a SQL Server DBA, do you need to be a killer with scripts? In this episode I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell. 
9m 6s
Sep 2019
Episode 286: 286: SQL Smart with Nancy Sheleheda
Nancy Sheleheda, Senior Director of Application Development at PCT, joined Brittany to discuss why it is important to learn SQL, to engage in a debate on differences between a developer and a DBA and introduce some great resources to leveling up on SQL. Links for this episode:SQL ... Show More
30m 28s
Jun 2024
D2C244: When the Cloud was Born
Eric Chou was there for the birth of the public cloud. Before DevOps or SREs were a thing, before Azure was Azure, Eric was a network engineer for Amazon, helping them build out their retail technology platform. Of course, that platform evolved into the world’s leading public clo ... Show More
45m 10s
Oct 2024
Big data is dead, analytics is alive
We are on the other side of “big data” hype, but what is the future of analytics and how does AI fit in? Till and Adithya from MotherDuck join us to discuss why DuckDB is taking the analytics and AI world by storm. We dive into what makes DuckDB, a free, in-process SQL OLAP datab ... Show More
50m 19s
Oct 2017
The Death of SQL Server Service Packs
SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs, and the process of updating SQL Server. 
11m 32s
Oct 2024
839: Prisma ORM: Local First, Typed SQL Queries and Serverless with Søren Bramer Schmidt
Scott and Wes talk with Søren Bramer Schmidt, Founder and CEO of Prisma, about database best practices, including the latest developments in serverless, local-first, and typed SQL solutions. Show Notes 00:00 Welcome to Syntax! 02:55 Søren’s thoughts on GraphQL 03:53 Brough ... Show More
54m 51s
Jan 2025
867: Zero Sync is the Future of Data Loading
What’s the deal with Zero Sync? Scott and Wes dive into this cutting-edge database tech, exploring its real-time interactivity, blazing-fast performance, and how it stacks up against the competition. Plus, they break down setup, querying, authentication, and whether it’s ready fo ... Show More
29m 5s
Listen to millions of songs and podcasts on Anghami