Watch the tempdb version store with per-database space DMVs, find transactions that delay cleanup, and plan capacity from trends.
SQL SERVER – Enumerations in Relational Database – Best Practice
Marko Parkkola from Finland shares a best practice for enumerations in relational database design: the right way to store them and one clearly wrong way.
Backing Up SQL Server Express Without Agent
Backing up SQL Server Express requires a BACKUP script, sqlcmd, Windows Task Scheduler, retention rules, and proof that restores work.
Opening a Microsoft Support Case: What to Gather First
Prepare a Microsoft support case with version details, a clear timeline, error logs, system_health, dumps, LogScout, and redaction notes.
Staying Current Without Chasing Every Update
Staying current on SQL Server takes a repeatable CU cadence, fast security response, and a patch policy your team can actually keep.
A Migration Cutover Checklist
A migration cutover checklist covers final backup, logins, jobs, linked servers, DNS, validation, and an explicit go or no-go decision.
Explaining Database Risk to Managers
Explain database risk to managers by turning backups, patching, and capacity into clear impact, likelihood, cost, and action choices.