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.
- 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?
- 0A000086 and command not found with latest mssql-tools for Linux
- Create a SQL Server container with Podman
- 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