Onboarding a new DBA starts with safe access, a server map, tested runbooks, and a first month of supervised operational tasks.
SQL SERVER – 2005 – Best Practices for SQL Server Health Check
Best practices for a SQL Server Health Check: run one every 6 to 12 months, document everything, and plan fixes afterward instead of fixing during the check.
Configuration Drift Between Servers
Find configuration drift between SQL Server instances, establish a baseline, and separate approved exceptions from settings that need repair.
SQL Server Permissions Without the Guesswork
Understand SQL Server permissions through principals, securables, roles, and ownership chains, then inspect what the current account can do.
Handling Time Zones in SQL Server
Handling time zones in SQL Server means storing an instant, converting with AT TIME ZONE, and testing daylight saving gaps.
Finding Unused Indexes
Finding unused indexes requires a measured window, SQL Server usage counters, and a safe removal test before an index earns a drop decision.
Writing T-SQL Somebody Else Can Maintain
Write maintainable T-SQL with clear names, explicit results, focused procedures, and comments that explain the business reason behind the code.