Plan for data retention from the start.
The post Data Retention Policies, Often Forgotten appeared first on SQLServerCentral.

This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
The post Estimating Data Compression Savings in SQL Server appeared first on SQLServerCentral.

In this article we cover how to implement a batch Databricks Change Data Feed process through an end-to-end exercise.
The post Databricks Delta Change Data Feed appeared first on SQLServerCentral.

Join Kevin Davis, DBA Manager at Tower Loan to hear their playbook for successful distributed estate monitoring, and the role of SQL Monitor.
The post Tower Loan: Monitoring our estate and insights for your success appeared first on SQLServerCentral.

Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.
The post Learning the SQL GROUP BY Clause appeared first on SQLServerCentral.

Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
The post Building blocks of Extended Events data collection appeared first on SQLServerCentral.

This article looks at moving data in three related tables to Azure SQL Database using the change tracking feature in SQL Server to determine which rows have been changed.
The post Incremental Data Loading Using ADF and Change Tracking appeared first on SQLServerCentral.

Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server.
The post SQL Server Diagnostic Memory Queries appeared first on SQLServerCentral.