Say Seminar, Not Pre-Con for SQLSaturday
I read a note posted on the OPASS LinkedIn site today about our upcoming SQLSaturday and the two pre-cons by...
2012-08-28
1,024 reads
Blog Posts
Suppressing namespace attributes in nested select statements when using FOR XML workaround
I was helping out on the forums the other day with a user who had stumbled across the quirk of...
2012-08-28
6,766 reads
The INSTALLSHAREDWOWDIR command line value is not valid.
I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly...
2012-08-28
1,545 reads
These People Are Exceptional
I should know. I was one of the judges of this year’s Exceptional DBA of the Year award. I had...
2012-08-28
1,008 reads
Upcoming Speaking Events
I will be the inaugural speaker for the Northern Colorado Database Professionals on September 17, in Loveland, CO. I will...
2012-08-28
2,019 reads
At Startup SSMS setting
I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...
2012-08-27
660 reads
Create a SQL Server Reporting Services (SSRS) Catalog Report in 15 Minutes
One big question I have gotten often is “I need data, what kind of reports do you have?” It is...
2012-08-27
468 reads
Five Applicants for the PASS Board
If you haven’t reviewed the list, head to the PASS Election Page. One incumbent, two appointees, one previous candidate, and...
2012-08-27
568 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data...
2012-08-27
3,885 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data Warehouse (PDW) environment. With proper planning and attention to...
2012-08-27
63 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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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