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 239: Bi-directional HA/DR to Azure SQL
Episode 238: Getting Started with Power BI - Part 2
Episode 237: Getting Started with Power BI - Part 1
Episode 236: Database Monitoring with SQL Sentry
Episode 235: SQL Trail 2021 In-person Q&A
Episode 234: Communication Tips for the IT Pro
Episode 233: ScriptDOM
Episode 232: Giving Technical Presentations
Episode 231: Mental Health and Wellness in IT
Episode 230: RTO & RPO
Episode 229: Data Migration Assistant
Episode 228: Predicting Application Problems with Database Metrics
Episode 227: SSDT Methodologies for DB DevOps
Episode 226: SQL Server IaaS Agent Extension
Episode 225: Dashboard Design Principles
Episode 224: The Standup Meeting
Episode 223: Podcast Update
Episode 222: Azure Arc-enabled Data Services
Episode 221: SQL Trail March 2021 Retrospective
Episode 220: Microsoft Ignite Recap
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
The Unbelivable Truth - Series 1 - 26 including specials and pilot