It’s a fact that most MS SQL servers running in organizations are not built by DBAs. Small, medium and even larger organizations don’t hire professional DBAs. Even in environments where there are DBAs, it will happen quite often that databases servers were built by sysadmins for various reasons.
Microsoft did a great job as it’s easy to setup a SQL server, probably too easy and it will run “fine” without too much effort… for how long? And it could probably run faster with less pressure on your infrastructure.
This is the first of a series of articles dedicated to all my sysadmins friends who are building MS SQL servers to the best of their knowledge.
Continue reading “How to setup a MS SQL server for non-DBA systems administrators”