Kevin Hill reminisces and warns:
Installation defaults that are going to bite you (not version specific, and the installer is getting better):
-
Files all on the C drive
-
One TempDB data file (improved in SQL 2016)
-
Backups on C drive
-
No automated backups
-
Allow SQL to use ALL the memory
-
Allow SQL to use ALL the CPUs
-
Builtin\Administrators group not default*
-
Compressed backup set to OFF
There’s good advice here, so read on.