SqlServer.Rules v5.0.0 has been released, a major update to the open-source static code analysis library for SQL Server database projects. This release adds a large set of new design and performance rules (SRD0078–SRD0096, SRP0026–SRP0030), introduces SQL project/database option checks (SRD0700–SRD0706), and completes the migration from the legacy TSQLSmells package. The library helps teams catch T-SQL anti-patterns, naming issues, and performance problems at development and CI/CD build time rather than in production. Upgrade via the ErikEJ.DacFX.SqlServer.Rules NuGet package.

•2m read time•From erikej.github.io
Post cover image
Table of contents
HighlightsNew and Ported Rules (with docs links)Tooling and cleanupUpgradeFull changelog