Trigger Based Change Data capture
This script capture INSERTs / UPDATEs / DELETEs on SQL Server table and logs to single table in JSON Format.
2017-12-22 (first published: 2017-12-01)
2,418 reads
This script capture INSERTs / UPDATEs / DELETEs on SQL Server table and logs to single table in JSON Format.
2017-12-22 (first published: 2017-12-01)
2,418 reads
Stored procedure to ensure CDC job will be started once failover happen.
2017-08-25 (first published: 2017-08-22)
727 reads
Describes a design pattern for using CDC to power fast and efficient incremental data loads.
2013-06-07 (first published: 2011-01-17)
27,494 reads
This will generate a rollback procedure for any table with CDC enabled for all columns
2009-11-02 (first published: 2009-10-08)
898 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers