Community driven content discussing all aspects of software development from DevOps to design patterns. The SQL specification defines four transaction isolation levels, although a fifth transaction ...

Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging ...

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come with a ...

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...