Choosing where data and log files live means checking storage behavior, capacity, install defaults, and a tested move procedure.
Who Changed a Server Setting in SQL Server? How to Find Out
Who changed a server setting in SQL Server? The error log records what changed and when, and the default trace adds the login, the computer and the program. Tested with one harmless change that is put back at the end.
Checking Which Accounts the SQL Server Services Run As
Inventory SQL Server services and their accounts, compare virtual and managed identities, and verify permissions after a change.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
The global configuration list shows configured and effective SQL Server settings. I compare both before deciding that a change has taken effect.
Three Scripts for a First Look at Any Server
A first look at any server needs three read-only T-SQL checks: configuration, databases and backups, and current activity.
Windows Settings That Affect SQL Server
Windows settings can influence SQL Server CPU speed, file growth, memory stability, and security scanning; learn what to inspect and validate.
Standard Settings for a New SQL Server Install
Review standard settings for a new SQL Server install, including memory, MAXDOP, tempdb, backups, and alerts before users depend on it.