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

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

Most of the applications you write probably deal with manipulating data one way or another, and changes to the data beyond simple updates are usually handled in transactions. Many business ...

Databases were traditionally highly specialized data stores that were designed for specific tasks and until recently, they've been getting even more specialized. Recall data warehouses? Somebody once ...

Non-relational cloud databases such as Google's BigTable, Amazon's SimpleDB and Microsoft's SQL Server Data Services (SSDS) have emerged. But while these new data stores may well fill a niche in cloud ...

Proper database backup is essential because of the importance of the data they contain, so understanding how the work is also a must. Databases, also referred to as structured data, are an essential ...

NoSQL databases arose in response to the limitations of using SQL (Structured Query Language) for database queries. NoSQL databases store and manage data in ways that enable high operational speed and ...