Running SQL code in SSMS starts with F5 or the Execute button. This post covers running only a selection, what a batch is, why GO is not T-SQL, why variables disappear after GO, and how GO with a number repeats a batch.
Data and Information: Why Every Business Runs on a Database
Data and Information are not the same thing. Data is the raw facts a business stores, and information is the answer you get when a query processes them. This post uses a small bookshop table to show the difference, and why a database does the job better than a ledger or a spreadsheet.
The Four Window Functions You Will Actually Use
Learn four practical window functions with SQL examples for numbering rows, ranking ties, comparing previous values, and calculating running totals.
SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server
A common question I get: how do you go about detecting low disk space on SQL Server? Here are two ways, including xp_fixeddrives, and the one I prefer.
A Crossword Helper in T-SQL: Matching Word Patterns With LIKE
Match word patterns with LIKE and SUBSTRING, build sorted-letter anagram signatures, and use a leading-letter index for crossword searches.
Reordering a List in SQL Server: Move One Row, Write One Row
Reordering a list in SQL Server means changing a sort key, and the best design writes the fewest rows. This post compares three designs for dragging an item to a new place: renumber everything, shift the rows in between, and leave gaps. Each one is measured by rows written on a list of 1,000 items. Every result comes from SQL Server 2025.
Schema Snapshot: Prove a Deployment Script Is Safe to Run Twice
A schema snapshot records a table’s columns, indexes, constraints and rows, so you can prove a deployment script is safe to run twice. This post runs a plain script twice and watches a price change again. It then guards each step, runs the guarded script twice, and shows that the two snapshots match. Every result comes from SQL Server 2025.






