One runaway load can fill a shared drive and take every database down with it. A MAXSIZE cap moves the failure to one database.
Metadata-Only Column Changes: Which ALTER COLUMN Is Instant
Six ALTER statements look equally small, but their log cost is not. Here is how to measure each one before the change window.
Point-in-Time Restore: Getting Back Rows Deleted by Accident
Plan a point-in-time restore after an accidental DELETE, preserve the log chain, recover a separate copy, and return reviewed rows.
Resumable Index Rebuilds: Pausing Maintenance Without Losing Progress
Run a resumable index rebuild with ONLINE and MAX_DURATION, pause and resume it, inspect progress, and weigh edition and log costs.
Data Ingestion: Batch Loads, Change Data Capture and Streams
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.