SQL Server + Full Recovery Mode?
Een losse Full Backup of handmatige log backup kan meer stukmaken dan je denkt.

Ik leg in m’n blog uit waarom — en wat de juiste aanpak is.
🔗 www.sennin-it.nl/post/waarom-...

#SQLServer #FullRecoveryMode #DatabaseBackup #TransactionLog #ITPro

Transaction logs enable point-in-time recovery in financial databases. By replaying log entries up to a specific moment, a system can reconstruct its exact state before a failure, data corruption, or erroneous transaction.

#TransactionLog #Fintech #DataIntegrity

you can do snapshots perhaps every minute. rolling back just means that your database has to use its transactionlog after rebooting, thats ist, did it thousand of times the last decade. i am maintaining about 200 proxmox zfs hosts, so yes. zfs is the thing that rocks

“Use #transactionalprocessing.” This supports various features of a relational database in a #datalake. #DeltaLake is here to rescue you. It has many awesome features like #ACIDtransactions, #timetravel, #transactionlog, #SQLAPI and many more. Read on:...

Life of a #SQLQuery. Excellent improvements with 1. #Optimizer with #AdaptiveQueryExecution 2. #ExecutionEngine with re-written C+ and ~10X faster (#JVM #Presto) 3. #Caching with fast store 4. #AuxiliaryDataStructure: #DataSkipping with #DeltaLake transactionlog #dataaisummit