Have you ever looked at some tsql code and thought--How does even run? I know I have and it can be daunting to take a piece of code and review it for performance or to make a change to it. I enlist the help of Jen McCown from the MidnightDBA team to discuss approaches to unraveling code. We tackle the issues of nested views, documentation, formatting, Hungarian Notation, and visualizing how all the code pieces fit together.
At the end of the day, we just want our code to be understandable and usable for the next person who has to review it, because that next person just might be you. :)
Get the show notes for today's episode at http://sqldatapartners.com/2016/05/31/unraveling-code/ and I'll see you on the SQL trail!
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
Episode 36: SQL Server Virtual Machines in Azure
Episode 35: Position Yourself to Better Opportunities
Episode 34: In-Memory Tables
Episode 33: From Developer To DBA
Episode 32: Up Your Game With PowerShell!
Episode 31: What Has Virtualization Done To My Database?
Episode 30: The Best Investment You Can Make
Episode 29: You Thinking What I Am Thinking?
Episode 28: How Do You Know There Is A Problem? Baselines!
Episode 27: Testing Changes Before You Break Production
Episode 26: DevOps for the Database--Everyone is Doing it, Right?
Episode 25: Stretch Database
Episode 24 Query Store
Episode 23: IO, IO, It’s Off to Tune We Go
Episode 22: Eight Years of sp_whoisactive
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