logo
episode-header-image
Mar 2020
38 m

Episode 114 - Lots of catching up to do

Guy Glantser, Eitan Blumin
About this episode

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
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
May 13
Episode 187 - Transactional Replication Between Availability Groups
Guy and Eitan discuss a few new things in the latest SSMS update, and Eitan tells about a very peculiar use case involving transactional replication and AlwaysOn Availability Groups, and Guy talks about a use case involving deletion triggers. Important note: The part about SQL Se ... Show More
30m 6s
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
Recommended Episodes
Jun 2018
Training Resources for SQL Noobs
New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up. Links from the episode are at: https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/ 
29m 10s
May 2024
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath)   Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality ... Show More
1h 4m
Sep 2023
164: Choosing a Database For Your Project With Kris Zyp
Things to consider when choosing a database Speed & Latency Consistency, ACID Compliance Scalability Language support & Developer Experience Relational vs. NoSQL) Data types Security Database environment Client vs Server access Info on Kris & Harper: Website: harperdb.io Twitter: ... Show More
1h 31m
Aug 2021
Table Clustering (Clustered Index) - The pros and cons
In this episode of the backend engineering show, I discuss database clustering. This is also known as table clustering, clustered index or Index organized table all names represents the same thing. I will talk about the benefits of clustering and also the disadvantages of impleme ... Show More
28m 33s
Sep 2023
Exploring SQL and ETL
<p>The evolution of SQL and the ease of access to ever larger sizes of computational power has made SQL and ETL a useful pairing for practitioners in the data space. But how do they work together exactly? And what challenges can it pose?</p> <p>Bharani Subramaniam and Madhu Podil ... Show More
31m 57s
Mar 2020
Data Management with Amy Krishnamohan
tail spinning
29m 44s
Sep 2023
Episode 486: High Performance PostgreSQL for Rails with Andrew Atkinson
If you love taking about databases, this is the episode for you. Ahead of the launch of his new book, High Performance PostgreSQL for Rails, Andrew Atkinson joined the show with special guest co-host, Pat Bair, to talk about why he wrote a book, why he focused on PostgreSQL and h ... Show More
31m 29s
Listen to millions of songs and podcasts on Anghami