Episode 159 - Select * Wastes Money

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

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

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

<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

<p>In this episode, we will discuss NULLs in database systems. I’ll go through the following:</p> <p>What is Null?</p> <p>NULLs persistence</p> <ul> <li>Whether you store a 0 or 2 billion value in the field 32bit integer field it costs 32 bit</li> <li>when you store a NULL in 3 ... Show More

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

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/ 

<p>MySQL is clustered by default on the primary key which means inserts have to be ordered, let us discuss why UUID (random in nature) has bad performance in MySQL and whether postgres wins here. We will also explain why Sequential Writes are Faster than Random in MYSQL and &nbsp ... Show More

<p>SQL is the most important data skill you can learn on your journey. And it doesn’t need to be complicated. In this episode, dive into a short SQL introduction, basic SQL commands and know how SQL can help you land your data job.</p> <p>Tune in now!</p> <p><br></p> <p><a href=" ... Show More

<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

Hey Hussein I have a 2 million row table used in my CRUD python app, I’m worried that as the table grow my inserts will slow down, should I consider sharding my database or partition the table? thank you I’m avid of simplicity in design if I can do it in one machine I’ll do it. S ... Show More

<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