Kendra Little's podcast discussing database performance tuning, software development, and working with data.
…
continue reading
1
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
1:04:36
1:04:36
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
1:04:36
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, Table Variables, Automatic Plan Correction, Batch Mode, index…
…
continue reading
1
Power BI Performance Tuning with Eugene Meidinger
53:54
53:54
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
53:54
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 dig in and solve performance problems in Power BI. Euge…
…
continue reading
1
Automated Deployments and the Art of the Database with Database Michael J Swart
1:05:28
1:05:28
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
1:05:28
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 at https://michaeljswart.com/browse-articles-by-illustra…
…
continue reading
1
Jer and Kendar Explore Optimized Locking
28:57
28:57
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
28:57
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 article from Microsoft Learn Transaction locking and row ver…
…
continue reading
1
Advice for Technical Leaders with Alex Robson
1:00:28
1:00:28
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
1:00:28
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 hone your tech leadership skills. Alex Robson's site and …
…
continue reading
1
Erik Darling on Performance Tuning
52:45
52:45
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
52:45
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 blog: https://erikdarlingdata.com/blog/ Erik's YouTube:…
…
continue reading
1
What's up with Tech Interviews in 2023? With Jeremiah Peschka.
29:06
29:06
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
29:06
Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss.Oleh Kendra Little, Jeremiah Peschka
…
continue reading
1
Data Roles: DBA, DBRE, and Data Engineer
24:52
24:52
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
24:52
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-roles-dba-dbre-de/…
…
continue reading
1
When NOT to choose SQL Server to store your data
14:19
14:19
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
14:19
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 something other than a workload involving OLTP * When y…
…
continue reading
It's Down Tools Week at Redgate. I share what "Down Tools Week" is, what I'm working on this week, and why I think it's a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization, whether you are a developer, DBA, or ha…
…
continue reading
1
3 Things That Shouldn't Be Normal in Database Development
28:12
28:12
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
28:12
Many people use entrenched processes for database development that have been in place so long that it's hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development-- but which are incredibly common. This episode is inspired by the book, "The Unicorn Project", by Gene Kim.…
…
continue reading
1
Everything I Never Wanted to Know about Collation
13:53
13:53
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
13:53
I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more. One small localization correction: the default collation on a SQL Server install will be "the oldest available version that's associated with each spe…
…
continue reading
1
The Manager's Guide to Git Training for DBAs
19:02
19:02
Main Kemudian
Main Kemudian
Senarai
Suka
Disukai
19:02
Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful. The cheat sheet I mention in the episode is at https://littlekendra.com/2019/11/27/my-git-cli-cheat-sheet/…
…
continue reading