DBA Infrastructure Tools Hub
Centralized directory for core administration IDEs, open-source performance diagnostics utilities, and advanced engineering research focus areas.
💻 Base Core Tools & Engineering IDEs
| Tool | Category | Latest Version Link |
|---|---|---|
| SSMS | Management | Download SSMS (Latest) |
| VS Code | IDE | Download VS Code |
| Visual Studio | IDE | Download Visual Studio |
| Git Hub | Source Control | GitHub Desktop |
| Azure DevOps | CI/CD | Azure DevOps Portal |
⚡ Advanced Query Performance & Optimization Tools
| Utility / Toolkit | Diagnostic Target Focus | Resource Link |
|---|---|---|
| sp_WhoIsActive | Real-Time Session Monitoring | Download sp_WhoIsActive |
| Brent Ozar First Responder Kit | Server Auditing (sp_BlitzCache) | Get First Responder Kit |
| dbatools.io (Query Store Module) | PowerShell Automated Query Store Management | dbatools QueryStore Docs |
| Darling Data Toolkit | Advanced SPI Diagnostics Scripts | Explore Erik Darling Data |
| sp_QuickieStore | Surgical Query Store Metric Analysis | Get sp_QuickieStore GitHub |
🔬 Targeted DBA Research Focus Areas
📈 Automatic Tuning in Query Store
Investigating automated regression correction algorithms. Focus tracks database self-healing actions, specifically focusing on the automatic enforcement of the last known working execution plan when regression signals are detected by the engine.
🔍 SQL Server Extended Events (XEvents)
Deep-dive analysis of ultra-lightweight performance tracing. Designing low-overhead telemetry captures to replace deprecated SQL Profiler traces for tracking blocking patterns, deadlocks, and high-frequency execution metrics.