In mid-April 2021, I presented a webinar on How to Conduct a Transact-SQL Code Review. If you missed it, you can watch the webinar now on demand <How to Conduct a Transact-SQL Code Review (sentryone.com)>. This session encapsulates the sort of content I would share with my own Dev teams back when I was lead of a large database estate and helped us all improve our personal skills and overall institutional knowledge.
During the webinar, I used an assortment Transact-SQL script to show how to find all sorts of red flags in the Transact-SQL code, both code at rest (like stored procedures and user-defined functions) and code in flight and visible in the SQL Server plan cache. The intention of the scripts is to illustrate common issues with the Transact-SQL code developed by in-house Dev teams and by the Dev teams of ISV products, not to comprehensively point out every issue with an instance of SQL Server or Azure SQL Database.
I've had many requests for the scripts via email and social media, so I'm posting it here for your convenience. I'd love to hear your feedback if you have similar queries of your own that I haven't otherwise covered or if you have suggestions for improving the script.
By the way, this is one in a series of how-to webinars I’ll be presenting over the next several weeks. Other how-to sessions include:
- How to Design and Normalize a Database (great for Devs and accidental DBAs!)
- How to Conduct a Database Code Review
- How to Conduct a SQL Server Configuration Review (coming up on May 12)
For each of the "How-to" webinars, you'll also get a Transact-SQL file to help you identify the red flags in each area. Meanwhile, if you're kicking yourself for having missed the live experience of the webinar, you can subscribe to the SentryOne (now a part of SolarWinds) events calendar <SentryOne Webinar Events Newsletter> towards the bottom of the webpage.
I look forward to seeing you at an upcoming webinar soon! Cheers,
-Kev
