Power BI with Narrative Science: Look Who's Talking (Part 3: On or Off premises)
[2017-May-08] Listening to a car radio with many different talk shows available, it comes more often to my mind, that...
2017-05-08
669 reads
Data Adventures
DAX calculations with hierarchies: Set the order straight.
[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of...
2017-05-10 (first published: 2017-04-30)
4,785 reads
SSIS Web Service Task: misleading role of WSDL file
[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just...
2017-03-31
3,515 reads
External SQL files vs. Stored procedures in SSIS development
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...
2017-02-23 (first published: 2017-02-21)
3,296 reads
How to compare two SSAS databases with a custom MDX query
[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...
2017-01-29
2,759 reads
Open Data is like a soup
[2016-Nov-04] Open data is like a soup, some people like it hot (or made with all the latest updates); some people...
2016-11-04
611 reads
Power BI with Narrative Science: Look Who's Talking (Part 2: Predicting the Future)
[2016-Oct-18] I read a book one time about the importance of using visual aids in teaching. They also used a well...
2016-10-28 (first published: 2016-10-18)
1,752 reads
Historical Reports vs. Predictive analytics: Rear view mirror look vs. Forward-looking view. Really?
[2016-Sep-30] Working with reports based on historical data is like driving a car while looking in the rear view mirror. I heard...
2016-09-30
1,567 reads
Power BI with Narrative Science: Look Who's Talking?
[2016-Aug-31] Someone said a picture is worth a thousand words and this is true that in most cases a visual representation...
2016-08-31
1,165 reads
Power BI: If you have a Cloud of Words, let them Fly!
[2016-July-31] Last week was my 2nd time participating at the local Toronto Open Data meetup (https://www.meetup.com/opentoronto/). The audience of this meetup...
2016-08-02 (first published: 2016-07-31)
2,621 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
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...
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