SqlKraft.

Enterprise SQL Server Reference Hub

Curated high-performance static encyclopedia for the DBA community.

DMV Directory

Dynamic management views across execution, I/O, memory, indexing, transactions, and OS internals.

Wait Statistics

Wait types categorized by severity — baseline, triage, top-consumer, blocking, and high-signal.

Troubleshooting Cookbook

Scenario-based troubleshooting guides linking DMVs, waits, scripts, and errors into diagnostic paths.

T-SQL Scripts

Diagnostic and administrative scripts — indexing, performance, security, backup-restore.

Extended Events

Event-driven diagnostics — system_health, deadlock capture, query tracking with zero polling overhead.

Stored Procedures

System and diagnostic procedure reference for administration and troubleshooting.

Catalog Views

System metadata views — objects, indexes, partitions, schema, security, configuration.

System Functions

Built-in function reference — aggregate, string, date, math, metadata, and system.

Error Codes

SQL Server error lookup — severity, cause, and common resolution patterns.

T-SQL Reference Architecture Operations