Commissioning a SQL Server (a checklist)


SQL Server’s been installed. Now what?

Before a database server can be used it needs to be “commissioned”. I use the word commissioned deliberately, as distinct from “configured”.

Configuration happens for the entire life of a server.

Commissioning, to me, is readying the server for use, reviewing defaults and applying best practices, and setting it up for a particular purpose and environment. Once commissioned, a database server is ready for databases and operational use.

With this in mind, here’s a sample checklist to commission a server: