Configurations that take effect on RECONFIGURE

SQL Server Collation

SQL Database Snapshots for Reporting, Auditing and Data Recovery

In this article we look at how to create a SQL Server database snapshot and how snapshots can be used for reporting, auditing and more.

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