Adam wrote sp_WhoIsActive, a troubleshooting tool used by tens of thousands of DBAs all over the world. It’s incredibly powerful, it’s saved my butt countless times, and I use it every single week. He gives it away for free to help you. He hasn’t updated it in years – because he doesn’t need to. It’s that good.
He co-founded and still runs SQLblog.com. He hosts a blogging platform where a lot of really smart SQL Server people share a lot of really good articles for free. Here, Adam’s a force multiplier – he makes it easier for people to teach others.
He helps run the New England SQL Server User Group, and he’s been doing it for almost a decade.
Adam has been an MVP since 2004. He’s been awarded eleven consecutive MVP awards, and he doesn’t get it for brown-nosing. He’s refreshingly honest about challenges with SQL Server.
He shares his knowledge at conferences around the world. Hard-core T-SQL geeks love his SQLbits session videos on query tuning mastery.
He writes and edits books, even in this day and age of crappy royalties, including the upcoming T-SQL Querying with Itzik Ben-Gan, Dejan Sarka, and Kevin Farlee.
Update: He started T-SQL Tuesday, and participates in #SQLRun events. Aaron Bertrand and Steve Jones pointed those out.
And oh yeah, he’s got a day job and a family.
Today, you should tweet him thanks at @AdamMachanic. Why? Because he’s been helping you and me for over a decade, and today is as good a day as any other. Go make it happen.
Really, you had me at “Adam wrote sp_WhoIsActive”. That sproc captures what is happening now so effectively. It’s the first thing I run when someone complains of blocking or timeout.
Wow, thanks Brent!
I am glad to help; any success I’ve had in my own career has been because so many people have been willing to help ME. So I’m just giving back.
As for that photo…wonderful to relive the memory of the time I gave you crabs!
sp_WhoIsActive pulled my bacon out of the fire again just last Thursday. Thanks Adam.
He’s easily one of the foremost authorities on sql server in the world. That’s one heck of a title. The greatest free tool on the market today is sp_whoisactive. When I’m asked who I’d choose to assemble dream team Adam’s on that list.
Co-signed a hundred times over.
You rock Adam! Just don’t let this go to your head and forget what I told you at the Summit though:) Keep up the great work my friend.
Let me add my voice to the chorus of thanks ! You are one of the bloggers I read on a regular basis. I always find something of interest and useful information (and useful tools). Thanks!
Oh yeah…sp_whoisactive have saved me n number of times and I really appreciate everything which Adam does for the community…True hero !
Thanks Brent for this post.
He helped me write my first session abstract for my first SQL Saturday. That combined with sp_WhoIsActive and I would say he is one of the people responsible for changing the entire direction of my career, and consequently, my life. Thanks for being awesome Adam!
sp_WhoIsActive – it’s a powerful script, which helped me a lot, of course to all.
Thanks Adam for giving a such excellent script!
One small script from Adam, One giant of script for the DBAKind.
Without question, one heck of a SQL legend!
I lost count a long time ago just how many times sp_whoisactive has jumped to the rescue and needless to say it still is to this day.
So yes, BIG thanks to the man!
Also T-SQL Tuesday was Adam’s invention,
Even more reason to thank Adam!
Adam also came up with a couple of cool formulas for conversions of Adjacency Lists to Nested Sets.
Well deserved. Thanks Adam. And to add to the list Adam also wrote the CLR code for splitting text, which a lot of DBAs used before SQL Server 2016
Not only whoisactive but many other articles and blogs. Surely this should be included in ssms.
What is great about the script is that it can be deployed by less experienced users! Keep on keeping on Adam