Migrating from Access to SQL Server can keep the familiar front end while tables move, linked tables are tested, and Access queries are rewritten.
JSON_OBJECT: Decide Whether Missing Values Become Null
JSON_OBJECT constructs a typed object payload. Choose null or absent properties deliberately and preserve empty strings as present values.
Staging, Warehouse and Mart: Why Three Layers
Staging, warehouse and mart give data loads, trusted history, and focused reporting separate jobs; learn when each layer earns its place.
geometry STTouches: A Shared Boundary Is Not Interior Overlap
geometry STTouches tests whether shapes meet without their interiors intersecting. I keep that predicate separate from a general intersection check. Sharing an edge and sharing an area are different spatial relationships.
CAST to date: Remove Time Without Moving the Day
CAST to date keeps the calendar day from a typed datetime2 value. The example preserves the original time and contrasts actual removal with a display that merely hides it.
LEAD Defaults: Missing Rows Differ From NULL Values
LEAD defaults handle a missing following row. Keep that boundary separate from a present row containing NULL and choose replacement policy explicitly.
SQL SERVER – Validate an XML Document in TSQL using XSD by Jacob Sebastian
Jacob Sebastian shows how to validate an XML Document in T-SQL with XSD. An XML Schema Collection checks the structure and values of an XML column or variable.