SSAS Reporting Action with Date Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want...
2014-01-22 (first published: 2014-01-20)
2,243 reads
SSAS – Using the Euro or Pound currency Symbol in a measure Format String
If you have a set of measures and some of them are US dollars, some are Euros, and some are...
2014-01-17 (first published: 2014-01-13)
2,042 reads
SSAS Dynamic KPI from a table
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or...
2014-01-09 (first published: 2014-01-06)
2,591 reads
SSIS For Loop Skip Files
When running a For Each Loop through a set of files, sometimes you will have specific files that you do...
2013-12-30 (first published: 2013-12-23)
2,677 reads
SSRS Interactive Sorting a Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to...
2013-12-30
1,854 reads
Setting up Security on sub sites in SharePoint 2010
A lot of companies have several departments and want to limit the sub sites users can view. For example, the...
2013-12-20 (first published: 2013-12-16)
1,541 reads
SSAS – Setting Attributes as Properties for Excel
When a user is browsing your cube with excel they may not understand how to slice the data and end...
2013-12-09
1,253 reads
SSRS – Self Referencing Reports or Drill through to same report
When looking at a report and wanting to drill through to get more detail, we often create two reports for...
2013-12-04 (first published: 2013-12-02)
2,989 reads
Reverse or Mirrored Bar Chart in SSRS
There are some pretty charts out there and most of them can be done in Reporting Services. There is one...
2013-11-25
1,182 reads
SSIS Execute SQL error – No disconnected record set is available
If you get the error in SSIS that says:
…failed with the following error: “No disconnected record set is available for...
2013-11-18
2,504 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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