SQL Database Overview

Learn about what a SQL database is, what is stored in a database and how to interact with a database.

Columnstore Index Limits in SQL Server 2019

Mirroring Endpoint Authentication

Shrink and Release

Challenging Trends

Steve notes the changes in the world might affect how to view and use data in our work.

Data Cleanup

Steve wishes we could do some data cleanup and archival every year. Or even more often.

Database Snapshot Sparse Files

Building blocks of Extended Events data collection

Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.

Improving performance with instant file initialization

Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.

SQL Server and hyperconvergence

To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.