Data Ingestion is how data moves from the systems that create it into the platform that analyzes it. This post compares batch loads, change data capture and event streams, and shows the captured rows from a small SQL Server table.
Data Files and Log Files: What Each One Does in SQL Server
Data Files and Log Files are the two kinds of file every SQL Server database needs. This post explains what lives in each, why the log is written first, and how to list both with a query on sys.database_files.
Change Data Capture or Change Tracking
Change data capture or change tracking serves different sync needs; compare captured detail, retention, cleanup, and operating cost before choosing.
Backup Retention: How Long to Keep What
Backup retention should preserve restore chains while meeting recovery, legal, and storage needs across full, differential, and log backups.
Optimal Backup Methods: Full, Differential and Log Plans Compared
How to pick the optimal backup methods for your server: choose a recovery model first, then compare Full, Differential and Transaction Log backup plans. The chart lists the pros and cons of each.
log_reuse_wait_desc: Why the Transaction Log Will Not Shrink
log_reuse_wait_desc tells you why SQL Server cannot reuse its transaction log, so you know why a shrink gives nothing back. This post causes LOG_BACKUP and ACTIVE_TRANSACTION on purpose in a test database on SQL Server 2025, measures the log and fixes each one.
SQL SERVER – Move Database Files MDF and LDF to Another Location
Your new database sits in the default location and keeps growing. Here is how to move the MDF and LDF database files to another disk or drive.