TiDB is a prime example of an intrinsically scalable and reliable distributed SQL database architecture. Here’s how it works. In the good old days, databases had a relatively simple job: help ...

These books cover everything from beginner SQL queries to advanced database architecture.Perfect for developers, data ...

Another enhancement here is the Accelerated Database Recovery feature in SQL Server 2019, which makes the undo phase of recovery much faster. Each server uses an SSD-based cache using RBPEX on ...

SQL Server has evolved from its humble beginnings as a relatively easy-to-use and less expensive database (compared with high-end commercial enterprise databases) for small-scale transactions and ...

About 5,500 of the SQL Server faithful came out for the PASS Summit 2018 in Seattle last November. As usual, the event had the feel of a great big family reunion. It's always a fun time, with lots of ...

SQL Server configuration settings at the instance-level, database-level, and connection-level. Also be sure to catalog the sp_configure settings, as well as the sp_dboptions settings for the user ...

Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...

Noting how legacy applications manage “client-side and server-side logic and infrastructures within a closed, monolithic architecture,” Jauregui shows the advantages of serverless architecture ...