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,241 reads
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,640 reads
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
5,721 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
1,055 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)
6,554 reads
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
5,729 reads
Learn how you can fix the duplicated key error in SSAS without editing the source data.
2020-05-05
8,091 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,977 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
Comments posted to this topic are about the item Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers