Build customer arrays with JSON_ARRAYAGG and settings objects with JSON_OBJECTAGG in SQL Server 2025, with explicit order and null rules.
SQL Server Instance or Database: What Is the Difference?
A SQL Server instance is the engine and a database is one set of data inside it. What each level owns, why a login and a user are different objects, and which line to draw when you separate customers or teams.
Piecemeal Restore: Bringing the Primary Filegroup Online First
Rehearse a piecemeal restore that brings PRIMARY and current data online first, then restores archive filegroups with the right log chain.
SQL SERVER – How to Use Instead of Trigger
Triggers come in two kinds, Instead of and After. Here is how an Instead of Trigger can intercept an insert, update or delete on a table, with an example.
Grandfather-Father-Son Retention: Choosing Which Backups to Keep
Which backups survive when you keep three days, two weeks and two months? A small query answers it, and then you check the real files.
Designing a Date Dimension
A date dimension makes reporting calendars explicit with fiscal periods, holidays, weekdays, and a repeatable SQL Server build script.
Why Table Size Numbers Disagree: Reserved, Used and Unused Space
Reconcile table size reports by reading reserved, used, data, index, and unused pages from sys.dm_db_partition_stats on SQL Server.