The advantage of using one connection for multiple statements is that it reduces the overhead of establishing multiple connections, while allowing multiple statements to access the database. The ...

Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

It was about 25 years ago that I first started working in system development. My first assignment was to simply create ...

The first step in learning how to avoid deadlocks in SQL Server databases is preparedness. Knowing about deadlocks -- in particular, what causes them -- is the key to preventing them and resolving ...

A research-paper retrospective explains how separating query processing, logs, pages and storage changed the scaling behavior of Azure SQL Database.

AI success depends on whether enterprise data is ready, reachable, and close enough to the workloads that need it. In this eSpeaks episode, Dell Technologies’ Vrashank Jain explains why fragmented ...

A database start up, NuoDB, reached out to me to talk about a project they were working on to address the need for extremely scalable, web scale, transaction oriented database engines. The ...