Back in my day, we used a courier for log shipping.

3 Things I Wish I’d Learned Earlier as a SQL Server DBA

Back in my day, we used a courier for log shipping. Hindsight is everything. I was lucky to be trained by a great team of DBAs back when I first started with SQL Server. But it’s hard to know exactly what you really need to know, particularly as new tools are becoming available. Here’s the three things I wish I’d caught on to sooner. 3. How to See What’s Running in SQL Server (and How Long It’s… (Read Me)
The grass is always greener on the other cluster

Useful Whitepapers for Planning SQL Server Migrations

The grass is always greener on the other cluster. Planning to move to new hardware for your SQL Server? Techniques like log shipping and database mirroring can be incredibly useful to make the change fast and painless– but you’ve got to pick the right techniques for your environment ahead of time, and know how to do a few things that aren’t in the GUI. Here are some of my favorite whitepapers and resources… (Read Me)

New Class! “SQL Server Index Formulas: Problems and Solutions” for just $99 in Huntington Beach, California

My new one day training session, “SQL Server Index Formulas: Problems and Solutions”, is now available for just $99! Join me on Friday, April 1, 2016 in Huntington Beach to learn about choosing the right index keys (in the right order), the glories and disasters of included columns, pitfalls and triumphs with indexed views and filtered indexes, how to identify the right scenarios for partitioning, and… (Read Me)
A new sample database is born!

Free Sample Database for Download: SQLIndexWorkbook

A new sample database is born! A little while back, I wrote about free sample datasets on the internet. One of my favorite datasets is the list of names given to babies in the United States each year since 1880. The data is simple enough to be small, and just weird enough to be fascinating. The data’s published in 134 .csv files (and counting– it’s one per year), which takes a little fiddling to get into… (Read Me)

Join me at SQLBits for a Day of Index Design and Tuning

May 4-7, 2016 – Liverpool. Ready to learn to design and tune indexes in SQL Server in just one day? Join me in Liverpool on Wednesday, May 4, 2016 at SQLBits! My day long training session is: SQL Server Index Formulas: Problems and Solutions. This training session is all new material, and it’s got more demo scripts and examples than I’ve ever shown before. You’ll get all of those scripts to… (Read Me)

Why Teaching Makes You a Better DBA and Performance Tuner

I’ve known for a long time now that teaching makes me a better database administrator and performance tuner. But I’ve had a hard time figuring out why. At first I thought preparation was the differentiator. Writing a presentation requires extensive research and testing. You see some details that you might not otherwise notice. That’s true enough, but that’s not actually the big differentiator.… (Read Me)
It was only as I watched it burning that I realized it was in the wrong recovery model.

3 Things Every Junior SQL Server DBA Must Know

Sometimes we learn things in the wrong order. Or skip a step. If you’re just starting out as a SQL Server DBA, here are three questions that you need to be able to answer at any given time. If you aren’t 100% sure that you can handle these questions at 3 AM when you’ve had a few drinks, it’s time to revisit them. 1. Is My SQL Server Service Healthy? This seems like it should be really simple to check.… (Read Me)

How to Write a Presentation Abstract for a Tech Conference

I Hate Writing Abstracts. I love writing presentations. I like outlining them, I like writing the demos, putting the slides together. I even like reconsidering everything, backing up, scrapping it, and starting from a new approach! But I hate writing abstracts. It’s just tough to capture your vision in the format a conference organizer wants. And often, if I’m writing the abstract before the presentation… (Read Me)