News

Consider the following scenario: You use Microsoft SQL Server 2017 on Windows, SQL Server 2016, 2014, or 2012 Change Data Capture for Oracle by Attunity. You create a CDC instance to capture changes ...
SQL Server 2014 will come with a new in-memory OLTP engine, one built with the company’s Heckaton set of technologies, first developed by Microsoft Research.
La réplication transactionnelle est une technologie intégrée à SQL Server depuis SQL Server 6.5. Il s'agit d'une technologie très mature et éprouvée que la plupart des administrateurs de bases de ...
In-Depth Tour de SQL Finale, Part IV: Replication Our final sprint to the finish line stretches over replication: its limitations, high availability and the many improvements since the last version.
We are, however, mirroring the database within site 1. We are not mirroring at site 2. I'm thinking merge replication might be better than transactional with queued updates.
In addition to speeding transactional system performance, SQL Server 2014 could also cut hardware costs, because the efficiencies wrought from the new technologies would reduce the computational ...
In SQL Server 2005 and later, you can create a transaction log backup while a full or differential backup is occurring, but the log backup will not truncate the log due to the fact that the entire ...
In addition to speeding transactional system performance, SQL Server 2014 could also cut hardware costs, because the efficiencies wrought from the new technologies would reduce the computational ...