What do you do when you can't avoid huge transaction logs in SharePoint and your files are too large? Last month, I wrote about how to avoid having ginormous transaction logs within SharePoint ...

So, I just had a chat with my boss about Oracle and concurrency and she just shattered everything that I've ever understood about database and transactions. My understanding was that, in a transaction ...

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

If there was just one aspect of relational databases that led to the explosion of non-relational alternatives over the last 10 years, it was the ACID transaction model. ACID transactions were ...

There isn’t a week that goes by that I don’t hear or read about an organization seeing ginormous transaction log (.ldf) files, while the associated data (.mdf) file is at the size it should be when ...

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

Relational SQL databases, which have been around since the 1980s, historically ran on mainframes or single servers—that’s all we had. If you wanted the database to handle more data and run faster, you ...

Data estates are expansive. Organizations in all business verticals are operating data stacks that run on a mixture of legacy technologies that work effectively but aren’t always easy to move or ...

Poke around the infrastructure of any startup website or mobile app these days, and you’re bound to find something other than a relational database doing much of the heavy lifting. Take, for example, ...

Online transaction processing systems are purpose-built to handle large numbers of transactions by large numbers of concurrent users, while guaranteeing the integrity of the data. Online transaction ...