Month: February 2017

DBA 101: What you may be missing with “Missing indexes”

Daniel Janik9 Comments

If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I will say they are improving every day and maybe, just maybe, we will see the day when you can click happily away and do everything you want. Sadly, this is not the day.

A while back, SSMS added the “Missing Index” data to the graphical query plan. They even made it really easy to add.

Read More »

DBA 101: Altering a column

Daniel Janik3 Comments

People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly say that I don’t love any tools and you shouldn’t either.

My time at Microsoft placed me at nearly 300 different clients. As a Microsoft employee I never liked saying, “Go grab this tool so we can look at your problem because SSMS isn’t good enough.”

Read More »