Episode 159 - Select * Wastes Money

Up next

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

. 29min 33sec

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

. 30min 6sec

Recommended Episodes

164: Choosing a Database For Your Project With Kris Zyp

Programming Throwdown

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 31min

Can NULLs Improve your Database Queries Performance? - The Backend Engineering Show

The Backend Engineering Show with Hussein Nasser

In this episode, we will discuss NULLs in database systems. I’ll go through the following:

What is Null?

NULLs persistence

<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

. 22min 41sec

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

Dear SQL DBA

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 4min

Training Resources for SQL Noobs

Dear SQL DBA

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/

. 29min 10sec