T-SQL Tuesday #122: How I’ve Confronted Impostor Syndrome


Welcome back to another edition of T-SQL Tuesday! This month’s edition is hosted by Jon Shaulis and his chosen topic is Impostor Syndrome.

Continue reading

Kicking Off 2020 Events – Where’s Andy At?

Like most of you, I’m focusing on new things for 2020.

In 2019, I spent a lot of time on the road. I presented at over 25 events (conferences, SQL Saturdays, and User Groups), flying over 60,000 miles (a LOT for me)! On the other hand, I hardly blogged at all, so I’m resolving to change that in 2020!

My passion for speaking and presenting is as strong as ever. So to kick of my blogging efforts in 2020, I’m going to start a “Where’s Andy At?” monthly series. Hopefully it’ll help promote the awesome conferences, SQL Saturdays, and User Groups that I’m fortunate enough to attend and present at!

Where’s Andy At?

SQL Saturday Nashville – Jan 18: Presenting Let’s Dive Into SQL Server I/O To Improve T-SQL Performance
SQL Saturday Cleveland – Feb 1: Presenting Let’s Dive Into SQL Server I/O To Improve T-SQL Performance

Looking Ahead

Beyond those two events, I have other User Group engagements, SQL Saturdays, and conferences in my pipeline! I can already announce that I’ve had the honor of being selected for Data Grillen 2020! And I again part of the core organization team for SQL Saturday Chicago in March!

Need A Speaker?

If you happen to run a User Group, I’d love to speak at yours! I can easily manage remote presentations and offer a great amount of flexibility around those. Sometimes I can also visit your city in-person too, thanks to SentryOne! Contact me and ask!

Hope you see you at an event in 2020!

Looking Back on 2019 & Planning for 2020

Most folks do a year-end review later in December. But strangely enough, I’m finding myself doing one today. Maybe it’s because I just turned 42? In either case, let’s do a quick recap of 2019!

  • SQL Saturdays: 14
  • Presentations Given: 35
  • Conferences: 3 (SQLBits, SQL Intersection, PASS Summit)
I’ve also traveled enough to attain Platinum status with American Airlines & Diamond status with Hilton! Crazy!

In my Mid Year Update, I mentioned that I was going to debut two new sessions. I accomplished that, and presented them a total of 11 times! I plan to continue submitting them, but also have my mind’s eye on new session content.

  • SQL Server 2019: Intelligent Query Processing
    As someone who has specialized in T-SQL, IQP capabilities in SQL Server 2019 are HUGE! When GA was announced, I had my SQL Server 2019 RC install upgraded within 15 minutes! I’m super excited about this new feature set and look forward to seeing more folks adopt SQL Server 2019.
  • Advanced Plan Explorer
    At PASS Summit, I had the pleasure of co-presenting with Kevin Kline about SentryOne’s (FREE) Plan Explorer tool. Plan Explorer has been around for many years, but this experience really opened my eyes to the need for a more advanced session around how to use PE to dissect execution plans.
At this point, I’ve already got my eye on a number of 2020 events. I’ll be kicking off the year with SQL Saturday Nashville (session TBD) and I plan to submit to SQLBits 2020, Data Grillen 2020, and several SQL Saturdays whose CFS’s are already open. And of course, I’m again part of the SQL Saturday Chicago 2020 planning team! And finally I am going to attempt to blog more regularly!

2020 is already shaping up to be a very busy year. And I couldn’t be more excited!

24 Hours of PASS: 2019 Summit Preview Edition

PASS Summit 2019 is coming up fast, and PASS is holding their 24 Hours of PASS Preview Edition next week! I’m again honored to be presenting a preview edition of “Everybody Has A Story To Tell: Developing Your First Presentation” next week!

You might think, “Andy, you’ve been doing that session for a few years now. It’s nothing new!” Yes, it is several years old… BUT since it was selected for PASS Summit 2019, I’m making a number of enhancements! I’m very excited about some of the ideas I’ve come up with to improve this session and am eager to share some of them next week.

So if you’ve ever thought about presenting, but are still unsure… or a relatively new presenter and want to enhance your craft, be sure to register and join me!

Sept 10, 2019 @ 15:00 CDT
Sept 10, 2019 @ 20:00 UTC

Mid-Year Update

It’s been an extremely busy year for me. Here’s a quick recap by the numbers:

January – June:

  • 15 events attended
  • 20 presentations given
  • 28,000 miles flown
  • 15 hotel stays


I just wrapped up a week at SQL Intersection. I did not present at this conference, but did represent on behalf of SentryOne. But I did have the luxury of attending some sessions, which was awesome. I chose to focus on some of the cutting edge tech and was not disappointed. Highlights include sessions with Buck Woody on Machine Learning, Pam Lahoud on TempDB Impovements in SQL Server 2019, and several sessions with Bob Ward on Containers, Kubernetes, and SQL Server 2019.

I came out of this past week re-energized and wanting to get back into personal R&D, which I intend to blog about! Here’s a list of personal projects I wish to tackle, both big and small:

  • Docker:
    I want to get Docker operational on my laptop WITHOUT Hyper-V. I use VMWare Workstation and prefer to continue with it, meaning Docker for Windows Desktop is a no-go (it requires Hyper-V). But

  • ostress.exe
    I’ve used sqlcmd batch files for my workload scripts, but I finally want to convert them over to using ostress.exe.

  • Azure Data Studio + notebooks
    Bob Ward used ADS Notebooks for his demos, and after seeing him do it, I was amazed at how easy it was! I’m curious to see how I can manage some other aspects for some of my demos (use of XE, execution plan analysis, etc.) but am eager to take the plunge and give it a go.

  • New Sessions!
    I must develop TWO new sessions that I’ll be presenting in July & August. These were also my PASS Summit submissions, so am keeping my fingers crossed that one will be selected!

With all of these pet projects, I’m curious to see how much I can really knock out. But I am going to try my best to ride this wave of inspiration as long as I can AND blog about it all!

Here’s to the 2nd half of 2019!

T-SQL Tuesday #111: Why I Do What I Do

This month’s T-SQL Tuesday is by Andy Leonard, who asks bloggers to answer ‘What is Your “Why?”

To answer that, I’m going to answer a different question first. This is a very typical question that I get in interviews, that sort of drives me nuts.

“What do you see yourself doing in 5 years?”

Uhh… working unless I’ve won the lottery? And hopefully not working in a job that sucks? :-p

Smart ass response aside, what I always say to this is that regardless of the job/role that I’m in, I want to continue doing one key thing – helping companies leverage SQL Server to its fullest potential.

I think back to some of my past jobs, and what I’ve done to help both companies. At one company, I was brought in because of a SQL Server based system had outgrown its original architecture and performance was beyond dismal. At another company, I became a liaison to a primary SQL Server customer, in part thanks to my personal drive to remain on the cutting edge of what Microsoft was doing with SQL Server.

But I’ve also tried to help individuals too. And in all of my recent roles, I’ve made sure to evangelize the SQL Server PASS community, and all of the phenomenal training and resource offerings that can be found in our awesome community.

All of this, because one of my core characteristics is that I am a “Giver.” I want to help.

Today, I am proud to be a Solutions Engineer with SentryOne. In my current role, I’m “evangelizing” SentryOne’s monitoring software, because I personally believe that it is a true solution that can improve the lives of SQL Server data professionals.

Would me, 5 years prior, have been able to predict that I’d be working for SentryOne in such a role? No way. But am I still staying true to my overarching goal of helping others leverage SQL Server more effectively? Absolutely!

And that’s why I do what I do.