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
7,000 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
3,314 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
993 reads
2012-11-15
839 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
982 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,119 reads
2012-11-12
1,589 reads
2012-11-09
1,594 reads
2012-11-08
3,197 reads
2012-11-07
923 reads
Blogs
Why i use a smaller docker image part I
What is Docker? Docker is a famous platform for building, shipping, and running container...
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Forums
SSIS Installation Issues
Hello all, I am attempting to install the SSIS package into VS2019 CE. I've...
SQL blocking caused by running ALTER VIEW script
Hello experts, One of our developers tried to alter a view and reported to...
script to find the frequent used login information in the sql
Hi, Kindly some one share the script or query to get the login information...
Ask SSC