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,529 reads
Analysis Services (SSAS)
Comparing Azure Analysis Services with On-Premises SQL Server Analysis Services
Organizations working with on-premises SQL Server Analysis Services may not be able to guarantee optimized deployment of their models and secure and compliant data, especially during peak usage. The more companies invest in hardware and software licenses, the less the deployment of on-premises SSAS solutions becomes attractive, especially for smaller organizations with limited or narrow budgets.
2024-01-01
How to Connect to an Analysis Services Database in Power BI
Learn how to work with SSAS data in Power BI in this article.
2022-07-18
5,546 reads
Are Cubes Dead?
Is the idea of an Analysis Services cube something that is no longer relevant for modern data analysis? Steve thinks it might be.
2022-06-06
1,037 reads
How To Install SSAS 2019
In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.
2020-12-22
2020-10-28 (first published: 2020-10-14)
6,450 reads
Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
5,645 reads
How to Resolve a Duplicate Key Error in SSAS
Learn how you can fix the duplicated key error in SSAS without editing the source data.
2020-05-05
8,008 reads
Stairway to SSAS Tabular Level 9: Security and Roles
In the ninth level of this stairway, learn how to add security to the tabular model.
2022-06-22 (first published: 2020-03-11)
8,861 reads
Implementing Drill Through Actions in SSAS
Business users get great value from SSAS cubes. In this article, learn how to create a drill-through action in an SSAS multi-dimensional model cube.
2020-03-09
5,359 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers