MDX (MultiDimensional Expressions) in 148 minutes
If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful.
2019-05-07
511 reads
OLAP
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
2,376 reads
Day 7 of The OLAP Sprint
The final day of Simon's journey to improve his OLAP knowledge and build a prototype cube.
2012-11-16
989 reads
2012-11-15
830 reads
Day 5 of The OLAP Sprint
Day 5, the first real day of the Summit. Amir Netz' session and a little cube work.
2012-11-14
969 reads
Day 4 of The OLAP Sprint
Day 4 is the halfway point. Another pre-con, this one from Peter Myers that looks at Power View and Matrix reports.
2012-11-13
1,105 reads
2012-11-12
1,563 reads
2012-11-09
1,564 reads
2012-11-08
3,171 reads
2012-11-07
910 reads
Blogs
What does the Machine Learning process look like?
By damianwidera
This is the second article in the Machine Learning area. I have explained a...
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract,...
Quick 6 month check – how are those learning goals going…?
By HamishWatson
So in January I wrote a blog post on some goals I had this...
Forums
DB Snapshot on TDE Enabled Database
Dear All, I have a DB on which TDE is enabled. When trying to...
Installing SQL 2017 Error
I am trying to install SQL Server 2017 Enterprise Edition. It is an Iso...
Select n records in table X from a field on table Y
Hi, hope someone can help with this. I've the table gifts_to_give: Id_give number_of_gifts name ...
Ask SSC