ASF 016: Chris Webb interview
Introduction Chris Webb is independent consultant specialising in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in...
2018-11-23
228 reads
Blog Posts
Parameterized dynamic SQL is parameterized.
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic...
2018-11-23 (first published: 2018-11-15)
2,530 reads
Power BI Monthly Digest – November 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-11-23 (first published: 2018-11-14)
2,398 reads
Where to Store Index DDL
Recently I was asked my opinion, via Twitter, on where to store the index DDL for a single database that had multiple clients with varied usage patterns. You can...
2018-11-23
7 reads
Where to Store Index DDL
Recently I was asked my opinion, via Twitter, on where to store the index DDL for a single database that...
2018-11-23
219 reads
Counting blessings – from Summit V2.0 and beyond
I have been a regular attendee at PASS Summit for 15 years now. This year (2018) marked my 15th year...
2018-11-22
197 reads
Learning Better Presentation Skills (T-SQL Tuesday #108)
This month’s T-SQL Tuesday is hosted by Malathi Mahadevan (@SqlMal). The topic is to pick one thing I would like to...
2018-11-22 (first published: 2018-11-13)
2,093 reads
Setting Memory–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-11-22 (first published: 2018-11-05)
2,251 reads
SQLpassion Black Friday Deal 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-11-22
221 reads
Using RANKX in Computed Column and MEASURE
This is my first blog for PBI – DAX. I lately started working on DAX and trying to understand it in depth. While looking for a DBA hat, getting...
2018-11-22
22 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