dbatools: SQL Server Administration Made Practical
Managing SQL Server day-to-day isn't just about setting it up, it’s about keeping it running smoothly: managing logins, scheduling jobs,...
Week Seven Onwards
The first six weeks in a new DBA role are often a blur, equal parts learning, adjusting, and firefighting. There’s a lot to take in:...
dbatools: Simplifying SQL Server Configuration with PowerShell
SQL Server configuration used to mean a lot of clicking around in SSMS, memorizing registry tweaks, or juggling half a dozen scripts....
Week Four: sp_WhoIsActive Automation – Smarter Query Monitoring
For Week Four, I've put up the work in a more systematic way. If Week Three was about collecting baselines, Week Four is about using that...
Week Three: Baselining Part 2 – Microsoft's Best Practices Checker for SQL Server
In Part 1 of this Week 3 dive into SQL Server baselining, I used Invoke-DbaDiagnosticQuery from dbatools to run Glenn Berry’s diagnostic...
Week Three: Baselining Part 1 - Glenn Berry’s Diagnostic
Week three goal was pretty starightforward: Baselining a critical task to ensure our SQL Server instances are running smoothly. To gather...
Week Two: Laying the Groundwork
The first week marked the beginning of my journey in this new role. I spent that first stretch getting my bearings meeting the team,...
Starting Fresh: My First Week in a New Role
Updated: Just added some new resources under "My Essential SQL Tools" that should be more useful. I recently stepped into a new chapter...











