The Geeks Forge: SQL Knowledge Base

Home
Overview
  • Overview
Start here
  • Maintenance Outline
Ops maintenance (01-10)
  • Agent jobs
  • Alerting & runbooks
  • Backup & restore
  • Capacity & growth
  • HA/DR
  • Index & statistics
  • Inventory baseline
  • Patching & upgrades
  • Performance health
  • Security hygiene
Stored Procedures
  • Config / instance procs
  • Extended procs (xp)
  • Object help procs
  • Security & principals procs
  • SQL Agent procs
  • Stored procedures
  • System stored procedures
Functions
  • Built-in functions
  • User Defined Functions
T-SQL deep-dives (13-17)
  • APPLY & set-based
  • Dynamic SQL
  • Error handling
  • Indexing for procs
  • Temp vs table vars
T-SQL deep-dives (18-23)
  • MERGE & upserts
  • Query Store
  • Synonyms & cross-DB
  • Temporal / history
  • Transactions & isolation
  • TVPs Blazor/PS
T-SQL deep-dives (24-29)
  • Constraints
  • Extended Events
  • Filtered indexes
  • JSON in T-SQL
  • Pagination
  • Parameter sniffing
T-SQL deep-dives (30+)
  • Common Table Expressions
Implementation spikes
  • Agent fail board
  • Alert evaluate + ack
  • Backup heat map
  • Build out-of-date
  • Capacity tight volumes
  • Inventory MVP
  • Perf triage board
  • Security exceptions
SQL CLI
  • Azure CLI SQL
  • bcp
  • sqlcmd / go-sqlcmd
  • sqlpackage
  • SqlServer PowerShell module