Parents Just Don’t Understand

Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship...

SQL Saturday 74 – Jacksonville FL

I made a 700+ mile round trip down to Jacksonville FL where I was fortunate enough to get to speak...

Foreign Keys Help Performance

I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have...

About

About

Checkpoints and the Lazy writer

Hi,
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason...

A SQL Server Hardware Nugget A Day – Series Recap

Writing a month long series is always a lot more work than you initially expect. You would think that I...

May Question: What’s Your Backup Strategy?

As DBAs, one of our biggest responsibilities is to protect our data with backups. So, for this month’s question, “What’s...

A SQL Server Hardware Nugget A Day – Day 30

For Day 30 of this series, (which is the last day), I am going to talk a little about RAID,...

A SQL Server Hardware Nugget A Day – Day 29

For Day 29 of this series, I am going to talk about some of the basic things that you should...