I've been working with SQL Server for the past 13+ years focusing on query performance, database security, and automation, with the bulk of my experience being gained while working with large production environments.
I am a Data Platform MCSE, as well as an OSCP and PNPT, with a passion for InfoSec and PowerShell.
In my spare time I work on PSBlitz - a PowerShell-based tool that helps you find and diagnose issues on SQL Server/Azure SQL DB/ Azure SQL MI, post on my blog, and play around in my home lab.
- 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.
 
- SQL Server Management Studio 22 Preview 3 – first impressions
 - PoCs for two SQL Injection vulnerabilities fixed in SQL Server 2022 GDR KB5063814
 - Diagnosing SQL Server with PSBlitz – 3-year anniversary post
 - My PowerShell coding setup
 - No, SQL Server CTEs do not store results
 
- 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
 - Fixing SQL Server connection errors 64 233
 - Script to get table sizes in SQL Server
 - Setting up a Windows Server 2019 VM in VirtualBox
 
- Securing SQL Server's service account
 - Testing large insert speeds in SQL Server
 - Script to decode Asus router configuration backup file
 - Script to search for a string in an entire SQL Server database
 - Script to measure write speeds in SQL Server
 





