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 56: What is your favorite SQL Server 2016 Feature?
Episode 55: The new and improved SQL Server Reporting Services
Episode 54: An Executive Panel Interview
Episode 53: THE Argenis Fernandez interview on storage
Episode 52: Statistics are coming to the DB R you ready?
Episode 51: A PowerShell Story
Episode 50: SQL Server Settings
Epsidode 49: Temp Tables VS Table Variables
Episode 48: Is the Data Warehouse Dead?
Episode 47: Helping Your Data Find A Home
Episode 46: Unraveling Code
Episode 45 Service Broker
Episode 44: Azure SQL Data Warehouse
Episode 43: Why is ETL so hard?
Episode 42: Who made that change? Find out with Auditing
Episode 41: Index Maintenance
Episode 40: SQL Server Compression
Episode 39: Set statistics and StatisticsParser.com
Episode 38: SQL Server 2016 Feature Review
Episode 37: PowerBI and the DBA
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