Check and Detect T SQL Code Analysis
summary
Shows three concrete tools and what they do: SQLCheck CLI produces fast C++ text output and flags issues like vague primary key names but fails on edge cases because it uses regex parsing; ScriptDOM visitor pattern is a .NET parser that builds an AST and reliably detects constructs (demo finds SELECT and later a NOLOCK parsing quirk); and SQL Database Projects run code analysis at build time, can treat rules as warnings or errors, and pick up community rule sets like tsql-smells 50+ rules*.
AI-written summary · about
chapters (8)
- 0:00T-SQL code analysis intro
- 2:10SQL code quality in dev
- 8:13SQL Check CLI tool
- 11:24ScriptDom parsing SQL
- 21:03SQL projects and analysis
- 29:19Customizing SQL rules
- 33:34Future of SQL analysis
- 36:46Summary and Q&A
related talks
49mHow to Conduct a Transact-SQL Code Review
36mCode Analysis: Empowering developers to write performant, reliable, and safe C++
47mStatic Code Analysis: Judging a Forest by Its Trees
53mStatic Analysis Saved My Code Tonight
37mStatic Code Analysis For Kotlin
01h 05mImprove your code with Clang Tooling
20mExcellent Database Adventure: From Code Errors to Reliable Releases
52mDetecting Malicious Activity: Unveiling the Secrets of MS-SQL Logging