I'm a Microsoft Data Platform MVP specializing in SQL Server performance, security, and automation.
With 14+ years in large, mission-critical environments, including substantial Oracle tuning work, I bring a cross-platform edge to every project.
Holding a Data Platform MCSE, OSCP, and PNPT, I combine deep database expertise with an attacker's perspective on security.
I'm the author of PSBlitz, an open-source SQL Server diagnostic tool, and I write about SQL Server, InfoSec, and PowerShell on my blog.
- PSBlitz - A PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files
- SQL-Server-Scripts - Various T-SQL/PowerShell SQL Server-related scripts.
- T-SQL Tuesday #200 – things that make me instantly think a query is bad
- From Attendee to Speaker: My first Data Saturday session
- Get an Extra 10% Off Brent Ozar's Live Classes
- PSBlitz 6.1.0: new backup and security checks, Excel improvements
- SQL Server permissions that can lead to privilege escalation
- Script to search for a string in an entire SQL Server database
- Finding Long Values Faster - my solution to Brent's exercise
- Plagiarism and a lesson in hotlinking images
- Export and import multiple SQL Server tables to and from CSV files
- How apps cause ASYNC_NETWORK_IO waits in SQL Server
- Script to delete extra tempdb data files
- Script to search for a string in an entire SQL Server database
- Setting up a Windows Server 2019 VM in VirtualBox
- Fixing SQL Server connection errors 64 233
- Script to get table sizes in SQL Server
- The hidden costs of heaps in SQL Server
- Script to decode Asus router configuration backup file
- Using SQL Server Startup Procedures to automate sp_BlitzWho
- Get access to SQL Server when you don't have the SA password
- Getting the sysadmin role via trustworthy database