Blogs

How Do You Stay Motivated? (Dear SQL DBA Episode 47)

How Do You Stay Motivated? (Dear SQL DBA Episode 47)

on September 1, 2017 • 13 min read

Over the years, readers have asked me: “How do you stay motivated?” Sticking with a learning plan, blogging, or becoming a public speaker isn’t easy.

In this 15 minute episode, I share how I think about motivation and what keeps me going.

Continue reading

Why Did My Clever Index Change Backfire? (free video)

Why Did My Clever Index Change Backfire? (free video)

on August 30, 2017 • 1 min read

I had a great time giving a session recently for the 24 Hours of PASS - Summit Preview Edition.

Continue reading

You faked your resume... now what? (video with transcript)

You faked your resume... now what? (video with transcript)

on August 25, 2017 • 12 min read

This week’s question from a reader: “How do I deal with interview questions asking about real-world scenarios when I’ve faked three years of experience on my resume?”

Hear my answer in this 14 minute video.

Continue reading

sp_query_store_flush_db, Query Store, and Backups

sp_query_store_flush_db, Query Store, and Backups

on August 23, 2017 • 2 min read

One of the cool things about Query Store is that you can back it up with the database.

This isn’t perfect for every situation, because you must back up the whole database. If you’ve got a multi-terabyte database, your Query Store isn’t super portable! But still, it’s great to have an option.

Continue reading

How to Get Email Notifications for TSQLTuesday

How to Get Email Notifications for TSQLTuesday

on August 21, 2017 • 2 min read

Lots of us want to write for TSQL Tuesday, but aren’t always on Twitter at the right time each month to see when the announcement comes out using the #tsql2sday hash tag. And maybe we have an RSS feed set up, but we often get behind on a big pile of posts to read. (Guilty!)

Continue reading

Recruiters, Nerves, and Saying No in Interviews (video with transcript)

Recruiters, Nerves, and Saying No in Interviews (video with transcript)

on August 17, 2017 • 6 min read

In this episode of “Dear SQL DBA”, I talk about three articles written by members of the SQL Server community on interviewing that I can’t stop thinking about.

Continue reading

Interviewing Patterns & Anti-Patterns: Advice from the SQL Server Community

Interviewing Patterns & Anti-Patterns: Advice from the SQL Server Community

on August 14, 2017 • 5 min read

Category: indexing

Introduction

I’m glad I picked interviewing as the topic of TSQL Tuesday #93, because people wrote posts chock full of great advice and funny stories. Get ready to learn, be amazed, and laugh out loud as you read these posts, which I’ve indexed by the author’s first name. Don’t blame these authors for the dorky jokes in the cartoons, though. That’s all my fault.

Community Contributions

Aaron Bertrand is “looking back at bad interviews.” In the comments, I give a sure-fire way for you to handle any technical interview questions you don’t know.

Continue reading