Microsoft SQL Server
Everything with SQL Server. We mean everything.
From a single instance that has never been tuned to a multi-site Always On estate, we cover the full life cycle of Microsoft SQL Server: architecture, installation, performance, high availability, security, migrations to Azure and day-to-day DBA work.
- Performance tuning: wait statistics, query plans, indexing, partitioning
- High availability and disaster recovery: Always On, log shipping, mirroring, replication
- Upgrades and migrations: SQL Server 2008 through 2022, Azure SQL and Managed Instance
- Security and compliance: Dynamic Data Masking, TDE, X.509 certificates, GDPR
- Remote DBA and 24x7x365 monitoring
-- where is this instance actually waiting? SELECT TOP (10) wait_type, wait_time_ms / 1000.0 AS wait_s, signal_wait_time_ms / 1000.0 AS signal_s FROM sys.dm_os_wait_stats WHERE wait_type NOT IN ('CLR_SEMAPHORE', 'SLEEP_TASK', 'WAITFOR') ORDER BY wait_time_ms DESC;
Where almost every performance engagement starts: the wait statistics, not the symptoms.


