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
2,406 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,427 reads
From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.
2026-07-29
2,455 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,509 reads
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,710 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,673 reads
2025-09-02 (first published: 2025-08-04)
1,063 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
436 reads
2025-07-23
6,578 reads
This article shows the final step of an availability group creation, specifically for a distributed clusterless one.
2025-07-14
5,267 reads
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers