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 195: Understanding DAX
Episode 194: PolyBase Use Cases
Episode 193: Power BI Premium
Episode 192: The DBA is Dead! Long Live the DBA!
Episode 191: Power BI Row-Level Security
Episode 190: SQL Server 2019
Episode 189: Power BI Common Data Model
Episode 188: Databricks
Episode 187: Power BI Performance Tuning
Episode 186: Analytics & Security: Find Pain Points, Make a Plan
Episode 185: DBATools in a Month of Lunches
Episode 184: Where do people get stuck with Power BI?
Episode 183: SQL Server Big Data Clusters
Episode 182: XEvents
Episode 181: Paginated Reports in Power BI
Episode 180: PolyBase in SQL Server 2019
Episode 179: SQL Trail Recap & Buying Power BI
Episode 178: Database Design
Episode 177: Lock Pages in Memory
Episode 176: Power BI Storage Options
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