These are my collected best practices that I’ve come to rely on after 20 years with SQL Server.

 

Server Settings (last updated 2019-10-09)

Disk Settings (last updated 2018-09-04)

Database Settings (last updated 2019-02-21)

Checklist v0.2 (last updated 2019-02-19)

 

I’m constantly updating and adding information to this page.