vince-winkintel/sql-server-skills

1

sqlserver-backup SQL Server backup and restore operations — full, differential, and log backups, RESTORE with NORECOVERY/RECOVERY, RES…

vince-winkintel/sql-server-skills

2

2

sqlserver-diagnostics Identify SQL Server performance bottlenecks using DMV queries. Covers wait stats, slow queries, active requests, perf…

vince-winkintel/sql-server-skills

2

3

sqlserver-execution-plans Capture and interpret SQL Server execution plans. Identify bad operators (table scans, key lookups, hash spills), dia…

vince-winkintel/sql-server-skills

2

4

sqlserver-indexes SQL Server index management — find missing indexes, analyze fragmentation, identify unused indexes, design covering i…

vince-winkintel/sql-server-skills

2

5

sqlserver-monitoring SQL Server monitoring — SQL Agent jobs, error log, database health, blocking chains, deadlock analysis, long-running …

vince-winkintel/sql-server-skills

2

6

sqlserver-query-optimization Fix SQL Server stored procedures, views, and T-SQL anti-patterns. Covers non-SARGable predicates, implicit conversion…

vince-winkintel/sql-server-skills

2

7

sqlserver-schema SQL Server DDL patterns — CREATE TABLE with proper data types, ALTER TABLE, idempotent migrations, foreign keys, comp…

vince-winkintel/sql-server-skills

2