Standards
-
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice is to format using a 64K allocation unit size. Processes such as the checkpoint and Lazy Writer try to write in extents when possible. Extents are a collection of 8 pages and since each page…
-
Assign SQL Service Account with Group Policy
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy? The answer to this question requires that we step outside the DBA comfort zone since it requires the use of Active Directory and Group Policy Objects. There are many different ways that Active Directory can impact…
-
SQL Naming Conventions with PBM – SPs
How to enforce a stored procedure naming convention with policy based management.
-
SQL Nomenclature
You should have a SQL object naming convention. Enforce it with Policy Based Management.