Erik-Darling

Tag: erik-darling

Dear SQL DBA - Performance Tuning with Erik Darling

Dear SQL DBA - Performance Tuning with Erik Darling

By Kendra Little on August 18, 2023

SQL Server performance tuning expert Erik Darling joins the podcast today to chat about how good queries can go bad and how bad queries can get better.

He also answers the question on everyone’s mind: if he was a database, what database would he be?

Continue reading

Even Smart People Make Terrible Data Modeling Decisions

Even Smart People Make Terrible Data Modeling Decisions

I was doing a bit of data analysis, and the resulting numbers didn’t quite add up.

I double-checked my queries. Had I goofed in my sql? Nope. Next, I looked into if some of the data was in an inconsistent state.

What I found was worse than what I’d imagined. As a data person, it made me feel sad and icky.

Continue reading