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 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
Episode 219: SQL Server Inventory
Episode 218: File Growths
Episode 217: A Little Something About A Few Things
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