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
Learn how to work with SSAS data in Power BI in this article.
2022-07-18
4,736 reads
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
984 reads
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)
5,895 reads
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
5,364 reads
Learn how you can fix the duplicated key error in SSAS without editing the source data.
2020-05-05
7,596 reads
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,406 reads
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,153 reads
In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.
2020-02-10
7,329 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers