Data integration patterns in SQL Server cover full reloads, incremental pulls, change capture, and file drops with clear restart rules.
Checking 32-Bit Leftovers: Linked Server Providers and ODBC Drivers
Find 32-bit dependencies in linked servers, Agent steps, SSIS execution choices, and Windows ODBC drivers before a server move.
Recording Table Row Counts Every Day
Recording table row counts each day creates a useful SQL Server trend when a scheduled job, history table, and change review support it.
A Daily DBA Checklist You Can Run as One Script
Run a daily DBA checklist that reports stale backups, failed jobs, offline databases, recent errors, low volume space and current blocking.
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.
CDC Cleanup and Capture Jobs: Keeping the Log and Change Tables Small
Keep CDC cleanup and capture jobs healthy by checking log reuse, job settings, retention, polling, and a stopped-job alert.
A Minimal BI Stack on SQL Server
A minimal BI stack can start with SQL Server tables, stable views, one scheduled load, and one reporting tool that a small team can run.