Dear SQL DBA

✓

Tuntutan

Masukkan bar carian ini ke laman web anda

CARI EPISOD LEPAS

Cari episod lepas bagi Dear SQL DBA.

EPISOD SEBELUMNYA 🔗

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

20 Mei 2024

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 estimator, Tab ...

01:04:36

Power BI Performance Tuning with Eugene Meidinger

15 Jan 2024

Eugene Meidinger stops by to chat about Power BI Performance Tuning with Kendra. We talk about the various engines and languages used in Power BI and big-picture strategies for getting performance from the start. Eugene then talks about the community of tools and techniques that can be used to d ...

00:53:54

Automated Deployments and the Art of the Database with Database Michael J Swart

26 Sep 2023

In this episode, Michael J Swart joins the Dear SQL DBA podcast to talk about databases, automation, and how he's come to illustrate some of the coolest blog posts ever to be written about data. Check out Michael's art and blog posts at michaeljswart.com, and explore his posts by illustration a ...

01:05:28

Jer and Kendar Explore Optimized Locking

4 Sep 2023

SQL Server has a new feature that's currently only available in Azure SQL Database: Optimized Locking. Jeremiah Peschka joins the podcast to talk through the docs and nerd out on locks, blocks, and how to pronounce the acronym "LAQ". Learn more about this feature online: Optimized locking ...

00:28:57

Advice for Technical Leaders with Alex Robson

25 Ogo 2023

Ever wondered what it's like to be a VP or Director of Engineering? Kendra chats with Alex Robson about leadership in technology, what you can get out of coaching or an MBA program (should you be interested), and what makes a high performing team. We'll also chat about recommended content to hon ...

01:00:28

Erik Darling on Performance Tuning

21 Ogo 2023

SQL Server performance tuning expert Erik Darling joins the podcast today to chat about how good queries can go bad, how bad queries can get better, and the question on everyone's mind: if he was a database, what database would he be? This episode contains some mildly explicit language. Erik's ...

00:52:45

What's up with Tech Interviews in 2023? With Jeremiah Peschka.

11 Ogo 2023

Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss.

00:29:06

Data Roles: DBA, DBRE, and Data Engineer

4 Ogo 2023

There are lots of jobs for data folks. In this episode, I'm discussing three hot job titles: Database Administrator (DBA), Database Reliability Engineer (DBRE), and Data Engineer (DE) To see the venn diagrams I made for these roles, visit https://catalyzesql.com/blog/1/01/01/dear-sql-dba-data-ro ...

00:24:52

When NOT to choose SQL Server to store your data

22 Jun 2023

I wrote a blog post inspired by Stephen Vakil's excellent suggested interview question, but I inverted it: When should you NOT choose SQL Server to store your data? My thoughts: * When you don't actually need a database * When you're not using structured data * When you want pure analytics, or s ...

00:14:19