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!
Epsiode 96 Building Community Tools
Episode 95 Polybase
Episode 94 Qlik Technologies
Episode 93 Making Mistakes
Episode 92 SSDT
Episode 91 DBA Tools
Episode 90 Check DBCC
Episode 89 Lone DBA
Episode 88 SharePoint
Episode 87 Resource Governor
Episode 86 TsqlT
Episode 85 2016 Speedbumps
Episode 84 MVP
Podcast 83 Data Visualizations
Episode 82 Indexes Part 2
Episode 81 Indexes Part 1
Episode 80 Containers
Episode 79 SSIS Catalog
Episode 78: Conversion to 2016
Episode 77: New Reporting 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