blog / gray area / projects / about /

Hello! I’m Chandler Gray.

I'm a Cloud Migration Specialist specializing in database administration and automation who leverages analysis, T-SQL, Terraform, and scripting to diagnose challenges and automate repeatable, scalable solutions.

Latest posts

Understanding SQL Server Deadlocks Through the Prisoner's Dilemma

Your queries are prisoners. They're both holding what the other needs, and neither will let go.

sql-server
How to Migrate Data Using bcp

Step-by-step guide to bulk copying a date-filtered SQL Server table to another server using bcp format files and native mode.

sql-server
How to Timeout an External Process in PowerShell

How to use WaitForExit(Int32) to give an external process a time limit in PowerShell, and what to do when it runs out.

powershell
Wide vs Narrow Table Design in SQL Server

A practical benchmark of month-as-columns vs month-as-rows using SQL Server IO, time, plans, and storage.

sql-server
How to Merge SQL Server Data Files

Taking a database with one MDF and several NDFs, and gradually moving all data back into a single data file using `EMPTYFILE`.

sql-server

Gray Area

See all Gray Area posts

Does First-Pitch Strike Rate Actually Predict Pitcher Performance?

I used 2024 first-pitch strike rate to predict 2025 FIP and wOBA allowed for 329 pitchers. Here is what the regression showed.

baseball
wOBA By Count

How much does the count shape hitter production in MLB?

baseball
Welcome to Gray Area

A place for sports, analytics, and the interests that don’t fit under SQL Server.

Recent projects

See all projects

Inside My Fantasy Baseball Analyzer

How I put together a full toolset for fantasy baseball using ESPN data, FanGraphs projections, and some practical stats.

Let’s Connect

If you want to get in touch or just say hi, you can find me here.

LinkedIn /
GitHub /
BlueSky /
X (formerly Twitter)

© 2026 • Chandler Gray

Press Esc or click anywhere to close