Use running end dates when merging overlapping ranges, choose boundary rules, and return continuous periods without losing nested intervals.
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.
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.
A Multi-Tenant Schema With a TenantId Column: Keys, Indexes and Safety
Design a multi-tenant schema with composite keys, tenant-first indexes, trusted session context, and row-level security checks.
Backing Up msdb: Jobs, History and Mail Live There
Your user databases come back, but the jobs and mail setup do not. A short demo of what lives in msdb and how to protect it.
Cleaning Address Data in T-SQL: Trimming, Casing and Standardizing
Start cleaning address data with preserved originals, normalized spaces, careful casing, street-word mappings, and postal-code review flags.
Rolling Out Database Changes Gradually
Roll out database changes gradually with expand-and-contract steps, feature flags, data checks, and a rollback path for each stage.