Chandler Gray
chandlercgray.bsky.social
Chandler Gray
@chandlercgray.bsky.social
I work in data and actually like it. Minnesota sports fan for better or worse.

chandlergray.com
Sometimes I write posts just so I remember the steps later. This one covers how I set up my local FTP servers.

Read here: chandlergray.com/blog/setting...
Setting Up an FTP Server on Ubuntu with vsftpd | Chandler Gray
Step-by-step guide to setting up an FTP server on Ubuntu using vsftpd, from VM creation to testing connections on your local network.
chandlergray.com
September 26, 2025 at 7:54 PM
SQL Server = Monty Hall. Pick the first plan, get a goat. Parameter sniffing locks you in. Learn how to switch doors here:

chandlergray.com/blog/the-mon...
The Monty Hall Problem That Made Me a Better DBA | Chandler Gray
How Monty Hall helped me understand SQL Server’s bad plan choices.
chandlergray.com
July 22, 2025 at 8:50 PM
Reposted by Chandler Gray
Wolves in five.
May 15, 2025 at 1:47 AM
Here's my first attempt at building a real-world useful #Python application. This is for all of the #FantasyBaseball nerds out there. Any feedback is welcome!

chandlergray.com/projects/fan...
Inside My Fantasy Baseball Analyzer | Chandler Gray
A walkthrough of how I built a fantasy tool that merges ESPN and FanGraphs data to optimize decisions.
chandlergray.com
May 12, 2025 at 8:40 PM
Inherited a SQL Server environment with “creative” autogrowth settings? Here’s how I standardize filegrowth across all databases with a simple script.

New Blog Post: How to Set SQL Server Autogrowth for All Databases (and Why You Should)

#sql #sqlserver

chandlergray.com/blog/how-to-...
How to Set SQL Server Autogrowth for All Databases (and Why You Should) | Chandler Gray
Standardize SQL Server autogrowth settings across all databases with a simple script. Learn why setting consistent filegrowth sizes helps control VLF fragmentation, improves performance, and avoids le...
chandlergray.com
May 12, 2025 at 8:39 PM
How to Install SQL Server 2022 on MacOS

chandlergray.com/blog/how-to-...
How to Install SQL Server 2022 on MacOS | Chandler Gray
A guide to running SQL Server 2022 on macOS using Docker.
chandlergray.com
April 30, 2025 at 2:14 AM
Using PowerShell to Automate Glenn Berry’s SQL DMV Queries

What Is dbatools? The Script Accessing the Script Prerequisites How to Use the Script Pro Tip I find myself using Glenn Berry's SQL Server DMV queries more than any other performance tuning or diagnostic tool. Due to the frequency with…
Using PowerShell to Automate Glenn Berry’s SQL DMV Queries
What Is dbatools? The Script Accessing the Script Prerequisites How to Use the Script Pro Tip I find myself using Glenn Berry's SQL Server DMV queries more than any other performance tuning or diagnostic tool. Due to the frequency with which I execute these queries, I needed a way to quickly connect to a server, collect the necessary data, and move on until I have time to review the information thoroughly.
chandlergray.com
April 22, 2025 at 2:45 AM
Identifying and Removing Duplicate Indexes in SQL Server

Why Duplicate Indexes Are Problematic The Script How It Works Gathering Basic Index Information Retrieve Key Columns Retrieve Included Columns Drop Index Statement Find the Duplicates in my Results Limitations In an earlier post, I mentioned…
Identifying and Removing Duplicate Indexes in SQL Server
Why Duplicate Indexes Are Problematic The Script How It Works Gathering Basic Index Information Retrieve Key Columns Retrieve Included Columns Drop Index Statement Find the Duplicates in my Results Limitations In an earlier post, I mentioned I was looking for ways to simplify my performance tuning efforts. One of the approaches I've taken is finding exact duplicate indexes. Duplicate indexes on a table are problematic because anytime you insert, update, or delete a record on that table, SQL Server needs to update that same index multiple times.
chandlergray.com
April 22, 2025 at 2:44 AM
How to Improve SQL Server Performance by Avoiding Key Lookups

Investigating the I/O Performance Adding the Index Including Columns Recently I've been looking into simplifying my performance tuning efforts. One of the more straightforward methods for improving the performance of a query is to…
How to Improve SQL Server Performance by Avoiding Key Lookups
Investigating the I/O Performance Adding the Index Including Columns Recently I've been looking into simplifying my performance tuning efforts. One of the more straightforward methods for improving the performance of a query is to eliminate key lookups. A key lookup occurs when SQL Server retrieves additional columns not included in a non-clustered index, requiring it to access the clustered index or the table itself for the missing data.
chandlergray.com
April 22, 2025 at 2:43 AM
How to Download and Install the Latest Cumulative Update for SQL Server

Download the Latest CU Installing the CU Post Installation Tasks Microsoft isn't perfect. Because of this, they need to push out regular updates to SQL Server. These come out in several formats but most often we see this in…
How to Download and Install the Latest Cumulative Update for SQL Server
Download the Latest CU Installing the CU Post Installation Tasks Microsoft isn't perfect. Because of this, they need to push out regular updates to SQL Server. These come out in several formats but most often we see this in the form of a Cumulative Update (CU). Cumulative Updates release roughly once every 30 days, but there is no exact pattern. Below you will find the steps to download and install the latest CU to your SQL Server.
chandlergray.com
April 22, 2025 at 2:43 AM
How to Download and Install SQL Server Management Studio (SSMS)

Downloading SSMS Installing SSMS Post-Installation Next Steps SQL Server Management Studio (SSMS) is Microsoft's official tool for interacting with Microsoft SQL Server. SSMS is an essential for Database Administrators that need to…
How to Download and Install SQL Server Management Studio (SSMS)
Downloading SSMS Installing SSMS Post-Installation Next Steps SQL Server Management Studio (SSMS) is Microsoft's official tool for interacting with Microsoft SQL Server. SSMS is an essential for Database Administrators that need to both read/write T-SQL and review execution plans. Developers often utilize SSMS, but there are some plugins for Visual Studio Code, such as this one, but it doesn't offer the same experience that SSMS does.
chandlergray.com
April 22, 2025 at 2:42 AM
How to Download and Install Microsoft SQL Server 2022

Downloading SQL Server 2022 Installing SQL Server 2022 Post-Installation Installing SQL Server 2022 is a straightforward process if you follow the right steps. Below, I’ll walk you through how to download the installation media and successfully…
How to Download and Install Microsoft SQL Server 2022
Downloading SQL Server 2022 Installing SQL Server 2022 Post-Installation Installing SQL Server 2022 is a straightforward process if you follow the right steps. Below, I’ll walk you through how to download the installation media and successfully install SQL Server 2022 Downloading SQL Server 2022 To guarantee you’re downloading the latest and official version of SQL Server, visit Microsoft's SQL Server Downloads page…
chandlergray.com
April 22, 2025 at 2:42 AM
Resolving SQL Server Instance and Database Collation Discrepancies: Step-by-Step Guide

Recently I experienced a situation while migrating a database to a new SQL Server instance where the instance collation was different than the database collation, causing tempdb to become unusable. This…
Resolving SQL Server Instance and Database Collation Discrepancies: Step-by-Step Guide
Recently I experienced a situation while migrating a database to a new SQL Server instance where the instance collation was different than the database collation, causing tempdb to become unusable. This discrepancy rendered tempdb unusable and caused JOIN, ORDER BY, GROUP BY, and other operations to fail. Facing a strict deadline to get these applications migrated, I decided to rebuild the instance collation to match the new application databases.
chandlergray.com
April 22, 2025 at 2:41 AM