sqlserver

Comprehensive Microsoft SQL Server expert and router covering the full database-management lifecycle across versions 2016-2025 and the cloud (Azure SQL Database, Azure SQL Managed Instance, SQL on Azure VM, AWS RDS, Google Cloud SQL). Routes to specialized skills for operations, monitoring, HA/clustering, engineering, infrastructure, cloud, security, and offline DuckDB-powered analysis & recommendations (advisor). WHEN: "SQL Server", "MSSQL", "T-SQL", "SSMS", "sqlcmd", "DBA", "database administration", general or cross-cutting SQL Server questions, or when the specific management domain is unclear.

Offline SQL Server analysis & recommendations engine: capture read-only system-view/DMV/catalog data from a target instance ONCE, land it as local CSV/Parquet, load it into DuckDB, and run an analysis query library that produces PRIORITIZED, EXPLAINED recommendations across table/schema design, indexing, table sizes & capacity, statistics, query hotspots, and configuration — the PerformanceMonitor 'Lite' pattern. Complements the live diagnostic skills; iterate analysis with zero further load on the source and trend across capture runs. WHEN: "analyze my database", "recommendations to improve the database", "table design review", "what indexes am I missing", "unused/duplicate indexes", "is my schema well designed", "offline database analysis", "DuckDB SQL Server analysis", "database health report", "capacity review", "advisor", "prioritized findings".

SQL Server cloud offerings and migration: Azure SQL Database (DTU/vCore, elastic pools, serverless, Hyperscale), Azure SQL Managed Instance, SQL Server on Azure VM, AWS RDS for SQL Server, and Google Cloud SQL — including feature-parity differences, geo-replication, auto-failover groups, and migration tooling (Data Migration Assistant, Azure DMS, Managed Instance link, log replay, BACPAC, backup/restore to URL). WHEN: "Azure SQL", "Azure SQL Database", "Managed Instance", "SQL MI", "Hyperscale", "elastic pool", "serverless SQL", "DTU", "vCore", "SQL Server on Azure VM", "SQL IaaS", "AWS RDS SQL Server", "RDS", "Cloud SQL", "geo-replication", "failover group", "DMA", "Azure DMS", "MI link", "cloud migration", "BACPAC", "PaaS SQL", "which Azure SQL".

SQL Server development and performance engineering: T-SQL best practices, indexing strategy (clustered, nonclustered, columnstore, filtered, covering/included), execution plans, query optimization, statistics and the cardinality estimator, parameter sniffing mitigation, partitioning, In-Memory OLTP, temporal tables, data compression, and schema design. WHEN: "T-SQL", "write a query", "index", "covering index", "columnstore", "execution plan", "query plan", "query tuning", "optimize query", "SARGable", "cardinality estimator", "statistics", "parameter sniffing", "OPTION RECOMPILE", "partitioning", "In-Memory OLTP", "temporal table", "stored procedure", "schema design", "data type", "normalization".

SQL Server high availability, clustering, and disaster recovery: Always On Availability Groups (synchronous/asynchronous, contained, distributed, basic, read-scale), Failover Cluster Instances (FCI) on Windows Server Failover Clustering (WSFC), database mirroring and mirroring endpoints, log shipping, replication, quorum and witnesses, listeners, automatic seeding, and failover procedures. WHEN: "Always On", "availability group", "AG", "readable secondary", "FCI", "failover cluster", "WSFC", "quorum", "witness", "database mirroring", "mirroring endpoint", "CREATE ENDPOINT", "log shipping", "replication", "distributor", "listener", "automatic seeding", "failover", "high availability", "disaster recovery", "DR", "RPO", "RTO".