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
Nov 10
Episode 181 - The new SSMS is still blue
Guy and Eitan talk about the new preview version of SSMS, application locks, and stupid troubles with TempDB shrinkage. Relevant links: Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub Release Notes for SQL Server Management Studio (SS ... Show More
33m 23s
Oct 13
Episode 180 - Computed Columns with PERSISTED and Indexed Expressions
We let a dice roll decide today's topic, and the winner ended up being: Computed Columns with PERSISTED and Indexed Expressions. We give our thoughts about it, best practices, pit falls, and tips. Relevant links: SQL Server 2025 Preview RC1: Now Supporting Red Hat Enterprise Linu ... Show More
37m 55s
Sep 8
Episode 179 - SQL Server 2025 RC0 announced and weird latch timeouts
Guy and Eitan discuss several interesting announcements and updates from Microsoft related to SQL Server and VS Code. And also Eitan talks about a weird issue he encountered involving page latch time-outs during DBCC CHECK command. Please fill out the SQL Server on Linux adoption ... Show More
34m 40s
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
<p>Things to consider when choosing a database</p><ul><li>Speed &amp; Latency</li><li>Consistency, ACID Compliance</li><li>Scalability</li><li>Language support &amp; Developer Experience</li><li>Relational vs. Non-relational (SQL vs. NoSQL)</li><li>Data types</li><li>Security</li ... 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
<p>It's all about data management this week on the podcast as <a href="https://twitter.com/briandorsey">Brian Dorsey</a> and <a href="https://twitter.com/markmirch">Mark Mirchandani</a> talk to Google Cloud Product Marketing Manager, <a href= "https://twitter.com/amykrishnamohan" ... Show More
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