The open source SQL Server Development Assessment project contains the sp_Develop stored procedure. It can be used by database developers, software developers and for performing database code (smell) assessments to adhere to best practices.
NOTE: not all checks have been developed. Browse the Findings to discover other helpful database development best practices. Use the site search to find best practices super quick!
You can use the link in the results tab to navigate to the Findings specific check details. Also, feel free to read through the sections as there might not be a check created yet to incorporate other best practices in your development.
sp_Develop runs on SQL Server 2005, 2008, 2008 R2, 2012, 2014,2016, 2017, 2019, Azure SQL Server
Please consider Contributing to the SQL Server Development Assessment project.