-
Notifications
You must be signed in to change notification settings - Fork 10
SQL Server Administration
EdVassie edited this page Mar 26, 2021
·
3 revisions
| 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 |
|---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP