Monitoring and Auditing your Azure Analysis Services
Kasper de Jonge shows how you can see who connected to a AS Azure database and what queries were sent.
2019-05-31
Analysis Services (SSAS)
Build an OLAP Cube in SSAS using an ADO.NET Data Provider
SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]
2019-04-30
3,628 reads
Object Security in Analysis Services Tabular 2017
Koen Verbeeck looks at how to hide tables or columns in Analysis Services Tabular 2017 for certain users so they are not able to use them in reports or query them.
2018-03-01
2,612 reads
How to Change an Analysis Services Instance to Tabular Mode
In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode
2016-11-28
47,949 reads
Format Durations in SQL Server Analysis Services
I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, I’d like to show these durations formatted as time using the hh:mm:ss format. How can I do this in Analysis Services (SSAS)? - Koen Verbeeck responds.
2014-11-03
7,093 reads
SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn
What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? When should you use each one for a dimension attribute? Check out this tip to learn more.
2014-07-14
10,530 reads
Introduction to the SQL Server Analysis Services Neural Network Data Mining Algorithm
In data mining and machine learning circles, the neural network is one of the most difficult algorithms to explain. Fortunately, SQL Server Analysis Services allows for a simple implementation of the algorithm for data analytics. Dallas Snider explains
2014-05-19
3,590 reads
DAX: Topn is not a Filter
In this document I will demonstrate how using the TOPN function in a DAX query doesn’t necessarily do what you may expect.
2014-05-01
4,523 reads
Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS
The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.
2014-04-17
3,252 reads
SQL Server Analysis Services ProcessAdd for a Partition
Is there a way to process only the new data for a partition in SQL Server Analysis Services? Yes, this is accomplished in SQL Server Analysis Services with the ProcessAdd option for partitions. Daniel Calbimonte demonstrates how it works.
2014-03-27
4,415 reads
Blogs
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
Forums
SQL 2025 SSMS Nonsense
Yeah, I know this is a 2022 forum, but I don't see a 2025...
PowerBI Question - Data Sources
I don't see a PowerBI forum, so I'm posting here. I have a need...
SQL Server Certificates
Comments posted to this topic are about the item SQL Server Certificates
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers