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.
Visit the sp_Develop documentation website at https://un5mjjtj2fugwy5x6kfvewt5eymc0hp3.julianrbryant.com/SQL-Server-Development-Assessment/
There you will find the check findings with database development best practices. Install & usage instructions. Results & parameter explanations, How to skip checks. Develop app settings. Install the test database.