How a simple Extended Events session can turn you from a silent guardian to a developer’s best ally. There is an old, undeniable paradox in the life of a Database Administrator: If you do your job perfectly, nobody remembers you exist, only when you resolve problems. When queries are fast, backups are pristine, and the […]
2026-08-31
1,914 reads
This article presents a way to audit your SSAS cubes using PowerShell to prepare for any audit questions about who has access to the data.
2026-08-19
1,363 reads
From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.
2026-07-29
2,292 reads
A real world story of how someone moved from Enterprise Edition to Standard for not only the SQL Server database engine, but also with SSRS, SSIS, and SSAS.
2026-07-22
3,438 reads
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,687 reads
Spotting synchronization disconnects between a primary and a secondary data center in a distributed availability group configuration can be hard, so here are valuable tools to help you with it
2025-10-10
1,633 reads
2025-09-02 (first published: 2025-08-04)
1,007 reads
This article describes the process to create a read-scale cross-platform SQL Server Availability Group where the primary is Linux and the secondary is Windows.
2025-07-23
414 reads
2025-07-23
6,428 reads
This article shows the final step of an availability group creation, specifically for a distributed clusterless one.
2025-07-14
5,204 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers