The Geeks Forge: SQL Knowledge Base

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

Topics open in the Content pane. Filenames keep SQL-NN / CLI / SPIKE IDs; menu shows titles only.