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.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

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

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.

FCIs afford two major advantages: inclusion in the Standard Editions of SQL Server and protection for the entire SQL Server instance, including system databases.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Microsoft on Wednesday announced the release of SQL Server 2014 Service Pack 3 (SP3). SP3 brings new capabilities to Microsoft's relational database management system.