A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases.

Over the past several SQL Server releases, Microsoft has improved the concurrency and performance of the tempdb database.

In SQL Server 2000, we had a nifty little utility called rebuildm.exe which would rebuild the master database in emergency situations. This utility was removed in SQL Server 2005 and has not been ...

Ahead of today’s announcement, I talked to Rohan Kumar, the general manager of Microsoft’s Database Systems group, to get a bit more info about the history of this project and how his team ...

Without awareness and understanding about these challenges - and their potential consequences - an organization's upgrade to SQL Server 2012/2014 can be costly, inefficient, and plagued by system ...

The new ledger feature in SQL Server 2022 provides blockchain-based security to ensure data isn't tampered with.

Today, we announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability.

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data.