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

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

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

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

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

The technology for inhouse target marketing databases has evolved significantly in recent years. Traditional suppliers that relied on specialized inverted or bitmapped databases to enable quick ...

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip. Written by Arthur Fuller, Contributor March 4, 2004 at 12:45 a.m. PT.