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.
Querying External Files With PolyBase
PolyBase and SQL Server external tables expose CSV and Parquet files through schemas, while query plans show whether filters reduce remote work.
Time Ago Labels: Showing ‘5 Minutes Ago’ From a Timestamp
Learn time ago labels in SQL Server with practical examples, clear checks, common traps, and guidance for your own database.
SARGable Date Filters: Stop Wrapping Columns in Functions
Write SARGable date filters as half-open ranges for years, months, days, and rolling windows, then compare plans and logical reads.
SQL SERVER – Importance of User Without Login – T-SQL Demo Script
A T-SQL demo script for a user without login: create the user, impersonate it, check its access, revert and then grant permissions, one step at a time.