Our major goal in terms of log maintenance for all databases under our care is to optimize for write performance, in order to support all activities that require SQL Server to write to the log, including data modifications, data loads, index rebuilds, and so on. However, it's also important to keep an eye on possible log fragmentation, which, as described previously, can affect the performance of processes that need to read the log, such as log backups and the crash recovery process.

A Rolling Filtered Index in SQL Server

by Additional Articles

MSSQLTips.com

Filtered Index

I recently resolved an issue where a query pulling data from the last 30 days would time out due to the table’s size and the lack of a supporting index. Creating a supporting index is possible, but not ideal; it will be very large and may not be useful for most queries and use cases. I wonder how I could implement a filtered index that follows time and is always limited to the last n days.

Requiring Technical Debt Payments

by Steve Jones

SQLServerCentral

Steve found someone using an interesting approach to get developers to address some technical debt.

Using the FP-Growth Algorithm to Mine Useful Patterns in Data

by Daniel Calbimonte

SQLServerCentral

This article looks at using the FP-Growth algorithm from Python to mine data in SQL Server.

How to Use the New PRODUCT() Function in SQL Server 2025

by Additional Articles

SimpleTalk

SQL Server 2025

Introduced in SQL Server 2025 CTP 1.3, the PRODUCT() function acts similarly to SUM(), but multiplies values rather than adds them. It is an aggregate function in SQL Server and therefore operates on a data set, rather than on scalar values.

Learning a New Language

by Steve Jones

SQLServerCentral

Steve is using AI to help him learn new things.

Guidelines and Requirements

by Steve Jones

SQLServerCentral

We have some requirements that we meet a particular setting or value, but often we have guidelines and recommendations. Do you know the difference?

Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric

by Koen Verbeeck

SQLServerCentral

Power BI

This article shows how you can easily create connections in your Power BI workspace that use Identity Authentication to connect to your data.

SQL Server Triggers for Business Rules Automation

by Additional Articles

MSSQLTips.com

Triggers

The advantage of using triggers is that the same processing can occur regardless of where or how the data has been inserted, updated or deleted. In this article, we look at several examples of where and why triggers could be useful along with an example use case.

Concerns over AI Chat Privacy

by Steve Jones

SQLServerCentral

Data Privacy and Protection

Many of the GenAI services are using the free model of the past, where they use your data in ways you might not expect. Now, a court is ensuring OpenAI keeps your chat data around.

Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log

A Rolling Filtered Index in SQL Server

Requiring Technical Debt Payments

Using the FP-Growth Algorithm to Mine Useful Patterns in Data

How to Use the New PRODUCT() Function in SQL Server 2025

Learning a New Language

Guidelines and Requirements

Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric

SQL Server Triggers for Business Rules Automation

Concerns over AI Chat Privacy

Blogs

Enterprise AI Operating Rhythm – Top 5 practices for 2026

Stop Being Surprised by Your Azure Bill: Use Budgets

Resetting on the AI hype train

Forums

The Max PK Length

My experience using the GitHub Copilot in SSMS 22

The Microsoft SQL Year in Review

Question of the Day

The Max PK Length