SQL Server · Azure · Infrastructure

SQL Server and the infrastructure it runs on.

Notes, scripts and tools from twenty-plus years of running SQL Server. Real commands, real versions, real error messages.

Watch on YouTube Code on GitHub

sqlcmd

1> SELECT @@SERVERNAME;
2> GO
------------------------------
WEB01\REPORTING
(1 rows affected)

1> SELECT local_tcp_port
2> FROM sys.dm_exec_connections
3> WHERE session_id = @@SPID;█

Coming soon

The first posts and videos are in the works. Subscribe on YouTube or follow along on Bluesky to catch them when they land.

Streams happen on Twitch.

Projects

SSMS Executor

Runs the T-SQL statement under your cursor in SQL Server Management Studio. Open source, works in SSMS 21 and 22.

Available

View on GitHub

SQL Harness (sqlh)

A lean sqlcmd-style command line tool for AI agents, written in Rust. Windows first, SQL Server 2016 and up.

In progress

About

I started installing SQL Server around 2000 and never really stopped. I have worked as a consultant, spoken at PASS Summit, and now run IT for a company that watches its budget, so I care about what works and what it costs.

The name is a double meaning. SQL is pronounced sequel, and I am a Jr. This site is where I put what I have learned, to inform, to teach, and sometimes just for fun.