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 216: EDI vs ETL
Episode 215: Azure Data Factory
Episode 213: New Goals for 2021
Episode 212: 10 Things You Need to Know About Data Security
Episode 211: Solorigate
Episode 210: The Elephant in the Room
Episode 209: Career Ready: Advice to New Graduates
Episode 208: SQL Server and Graph Data
Episode 207: SQL Trail 2020 Retrospective
Episode 206: .NET Core Interactions with SQL Server
Episode 205: Data Modeling for Power BI
Episode 204: IoT in Azure
Episode 203: Spark in Action
Episode 202: Virtual Conferences
Episode 201: Common Data Model
Episode 200: Anything but the Cowboys . . .
Episode 199: Technical Debt
Episode 198: Cloud Infrastructure
Episode 197: Power Query in Power BI
Episode 196: Teleworking
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