SQL Server Administration - SQL-FineBuild/Common GitHub Wiki
| Previous Best Practice Guidelines | Separation of Duties Next |
|---|
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 should be followed by any organisation running SQL Server. Because these are manual processes, they can not be automated by SQL 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 |
| 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 Naming Standards | Suggested naming standards for SQL Server |
Copyright FineBuild Team © 2013 - 2021. License and Acknowledgements
| Previous Best Practice Guidelines | Top | Separation of Duties Next |
|---|