Horizontal scrolling makes code hard to read. In this SQL in Sixty Seconds video I show how to wrap SQL code in SSMS without changing anyone’s formatting.
Sharding: When One Server Is Not Enough
Sharding splits SQL Server data by a stable key when one server cannot meet scale needs; learn routing, cross-shard costs, and simpler options first.
SQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video
Look before you delete. This SQL in Sixty Seconds video shows one script to select duplicate records and another to delete them while keeping the latest row.
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video
A sixty second video on how to concat strings in SQL Server, from the plus sign to the SQL Server 2012 CONCAT function that needs no casting.
Why Opening an MDF File Directly Goes Wrong
Before you attach MDF file copies, check SQL Server versions, service permissions, and missing files, then choose a safer restore or attach path.
SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video
Many developers still use a cursor to copy data from one table to another. This SQL in Sixty Seconds video shows INSERT INTO SELECT and SELECT INTO instead.
Structured, Semi-Structured and Unstructured Data Explained
Structured, Semi-Structured and Unstructured Data differ in where the schema lives and how you query them. This post compares the three shapes and runs one query across a table, a json column and free text in SQL Server 2025.