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 116: Are people still using PSSDiag?
Episode 115: The Companero Conference Retrospective
Episode 114: How do you start consulting?
Episode 113: Standing on the shoulders of giants
Episode 112: Keeping up with patching
Episode 111: How do you prepare for conferences?
Episode 110 How do I build trust with my team
Episode 109: To certify or not to certify?
Episode 108: The Future of the Relational Database
Episode 107 BI for the Little Guy
Episode 106 Temporal Tables
Episode 105 When is enough, enough?
Episode 104: Keeping up with technology
Episode 103 Plan Reuse
Episode 102 Monitoring Availability Groups
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
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast