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.

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-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.

Instead of replicating transactions within an application or disk blocks, asynchronous replication technology captures changes to any files managed by the server operating system at a byte level.

Among the major elements in the new release, says Jonker, are real-time loading into Sybase IQ, advanced technology for dealing with high-volume transaction replication, and improved performance as it ...

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.