The Hidden Security Risks of Role Combination in SSAS Tabular
See how security in SSAS tabular models might not work as you expect, and how you could easily fail an audit.
2026-10-09
891 reads
Pablo Echeverria
- Interests: technology
- Skills: programming, databases
- LinkedIn: www.linkedin.com/in/pablo-echeverria
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Diagnosing memory issues can be hard. This article shows how one administrator used custom tracking to determine whether SQL Server, SSAS, or SSRS was the issue.
2026-09-25
2,102 reads
How Can SQL Server Detect Application Errors When Developers Can’t?
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,555 reads
Automating SSAS Multidimensional Security Audits with PowerShell
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,463 reads
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.
2026-07-29
2,601 reads
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
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,616 reads
Create and Read the Analysis Services Flight Recorder
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,745 reads
Distributed Availability Group Health: T-SQL and Zabbix
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,719 reads
2025-09-02 (first published: 2025-08-04)
1,123 reads
Migrate from Linux to Windows with Availability Groups
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
451 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Pasar Kenari Telp:08218200203
Telp/Wa 628218200203 Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, RT.2/RW.3, Kenari, Kec. Senen,...
Alamat BCA KCP Biak Telp:08217555651
Telp/Wa 628218200203 Jl. Biak No.44 AB, RT.8/RW.11, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Plaza Index Telp:08217555651
Telp/Wa 628217555651 Gedung Plaza Bank Index Ground, Jl. M.H. Thamrin No.57 Floor Suite GF-21,...
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers