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.
Gapless Invoice Numbers That Restart Every Year
Finance hates a missing invoice number. A small counter table and one short transaction keep the numbers gapless and restart them each year.
SQL SERVER – Order By Numeric Values Formatted as String
A column holds alphanumeric values that start with a number, and ORDER BY sorts them as text. Here is how to sort the rows by the Numeric part instead.
Merging Overlapping Date Ranges Into Continuous Periods
Use running end dates when merging overlapping ranges, choose boundary rules, and return continuous periods without losing nested intervals.
Server Configuration as Code
Configuration as code keeps SQL Server instance settings in reviewed scripts, with environment values, drift checks, and repeatable application.
SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post
People ask me for the secret to success. At John Sansom’s invitation, I wrote the true story of who I am and how I got here.
FileTable: Files You Can Open in Explorer and Query in T-SQL
Set up FileTable prerequisites, create a Windows-accessible file namespace, query stored file metadata, and compare simpler path storage.
SQL SERVER – Finding Different ColumnName From Almost Identitical Tables
A reader had archive and current tables in pairs, but the schemas drifted apart. Here is my way of finding different ColumnName values in almost identical tables.
Audit Columns From Day One: CreatedAt, UpdatedAt and Who Changed It
Add audit columns with UTC timestamps and trusted change identities, maintain updates in procedures, and know when history is needed.










