Untrusted Foreign Keys
Reading Time: 4 minutes
What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between...
2014-10-17
321 reads
Blog Posts
Why Haven’t You Changed Everything?
The first in what I hope will be many regular reports on what I’m doing on the PASS board.
To answer...
2014-10-17
601 reads
Analytics Platform System (APS) AU2 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has recently released an appliance update (AU2),...
2014-10-16
908 reads
Creating a SharePoint Server Farm on Azure from the Gallery
As many of you know creating a SharePoint farm for testing can be a daunting task. I volunteered to help...
2014-10-16
786 reads
Eliminate Overlapping Dates
I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events...
2014-10-16
974 reads
Insufficient Space to Create Databases For SCOM 2012 R2
Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum...
2014-10-16
699 reads
Learning Options in Seattle Next Month
The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many...
2014-10-16
797 reads
Notes From The October 15, 2014 oPASS & MagicPASS Meeting (The Souza-Thon!)
Both groups met at a special joint meeting last night at Nova University, part of Operation Souza. Before I go...
2014-10-16
764 reads
Query Performance Tuning in SQL Server
I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query...
2014-10-16
677 reads
SSRS report rendered in EXCELOPENXML then something went missing
Recently I had been requested by a client to look into one of their SSRS reports issues. They had one...
2014-10-16
3,160 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