This project has moved. For the latest updates, please go here.

Previous Best Practice Guidelines Development, Test and Production Environments Next

SQL Server Administration

It is relatively easy to comply with Best Practice guidelines for the administration of SQL Server.

Most of what is necessary are operational principals that need to be followed by the organisation running SQL Server. Because these are manual processes, they can not be automated by FineBuild.

The main items relating to Best Practice for SQL Server Administration are shown below:
Item Description
Separation of Duties Minimise risk by separating roles for servers and accounts
Development, Test and Production Environments Dedicated environments for each stage of deployment
SQL Client Tools Installation and use of Tools for managing SQL Server
SQL Administration Server Dedicated server for administering SQL Server
DBA Role Accounts Individual accounts for each DBA Role
SQL Service Accounts Individual accounts for each SQL Server service
Software Install Account Dedicated account for installing software
SQL Naming Standards Suggested naming standards for SQL Server

Copyright FineBuild Team © 2013 - 2016. License and Acknowledgements
Previous Best Practice Guidelines Top Development, Test and Production Environments Next

Last edited Aug 27, 2016 at 1:23 PM by EdVassie, version 6