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
10,589 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,597 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
1,011 reads
2012-11-15
865 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
1,001 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,137 reads
2012-11-12
1,607 reads
2012-11-09
1,614 reads
2012-11-08
3,221 reads
2012-11-07
941 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers