I've been working with SQL Server for the past 12+ 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, 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.
- Benchmark LAN throughput with iPerf3
- Brent Ozar's Black Friday deals are live! Here's why you shouldn't miss them
- Characters displayed as question marks or squares in SQL Server
- Fix implicit conversion when you can’t change the query
- What are implicit conversions in SQL Server?
- Finding Long Values Faster - my solution to Brent's exercise
- Plagiarism and a lesson in hotlinking images
- Script to search for a string in an entire SQL Server database
- Export multiple SQL Server tables to CSV files
- How apps cause ASYNC_NETWORK_IO waits in SQL Server
- Script to delete extra tempdb data files
- Fixing SQL Server connection errors 64 and 233
- Script to search for a string in an entire SQL Server database
- Script to get table sizes in SQL Server
- Setting up a Windows Server 2022 VM in VirtualBox
- Fix for slow VirtualBox VM performance
- Script to decode Asus router configuration backup file
- Setting up an Ubuntu VM for SQL Server 2019 and 2022
- Getting away with multiple NULLs in a unique constraint
- Testing large insert speeds in SQL Server