In what has to be one of the most downloaded SQL Server scripts on the planet with over 73,000 downloads, sp_whoisactive has been providing active session information to data professionals for eight years. I catch up with Adam Machanic to talk a bit about how the procedure came to be, how he uses it and what is in store down the road.
If you are using SQL Server and haven’t used sp_whoisactive before, I invite you go and download it right now, then come back and listen to the program. We will wait for you. Ready? Let's do this.
Have fun on the SQL trail compañeros.
You can see the show notes for today's episode at http://sqldatapartners.com/2015/12/15/sp_whoisactive/
Episode 101 Inspecting a new Database
Episode 100 Role Reversal
Episode 99 Imposter Syndrome
Episode 98: The first change you make
Episode 97 Transactional Replication
Epsiode 96 Building Community Tools
Episode 95 Polybase
Episode 94 Qlik Technologies
Episode 93 Making Mistakes
Episode 92 SSDT
Episode 91 DBA Tools
Episode 90 Check DBCC
Episode 89 Lone DBA
Episode 88 SharePoint
Episode 87 Resource Governor
Episode 86 TsqlT
Episode 85 2016 Speedbumps
Episode 84 MVP
Podcast 83 Data Visualizations
Episode 82 Indexes Part 2
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
Lex Fridman Podcast
Elliot in the Morning