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

 

Server Settings (last updated 2018-02-16)

Disk Settings (last updated 2018-09-04)

Database Settings (last updated 2018-02-16)

Checklist v0.1 (last updated 2018-02-16)

 

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