Pamela Mooney

Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This year’s question was about their current data platform configuration and usage. Just before it was released, I read the results, and I have to say, some of the things I learned amazed me…until I thought a bit more about it. I worked for a single-platform company for years, or so I thought.

Congratulations! You got the promotion!! Once the excitement and adrenaline rush of a promotion passes, it is common to find yourself staring at the yawning abyss of the unknown. Then you ask yourself the question that we all ask: “Now what?“ Do you know what upper management expects? Do you know where to start? Do you know what a manager does or how to accomplish what is required? If the answer to any of these questions is no for you, it doesn’t mean they picked the wrong person.

BlitzWho, oh how I love thee!  This stored procedure is, by far, my favorite way of figuring out who is doing what on my servers (so that I can ask why). I recently needed a little bit more out of it, though. I was working with a vendor who needed to understand degraded performance in our environment and wanted these sorts of metrics at different times in the process, and as quickly as possible.