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://www.spdevelop.org
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.