MySQL has this feature that SQL Server needs
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because...
2017-11-22
344 reads
Blog Posts
Parens (Really) Matter for Unions
In the course of testing a major upgrade, one of my users in Accounting happened upon a problem with one of her scenarios. The web app we were working...
2017-11-22
3 reads
SQL SERVER ON LINUX INSTALLATION – PART2 – INSTALL SQL SERVER ON RHEL
In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we...
2017-11-22
816 reads
Stretch database to cloud.
Microsoft Azure stretch database Purpose Information regarding the new feature in SQL Server 2016. Reading time +/- 20 minutes References Microsoft...
2017-11-22
211 reads
Thankful DBA
This week is Thanksgiving in the United States, so I thought it fitting to write a quick blog on what...
2017-11-22
409 reads
Using Plaster To Create a New PowerShell Module
Chrissy, CK and I presented a pre-con at PASS Summit in Seattle last week
Tracey Boggiano T | B came along to our...
2017-11-22 (first published: 2017-11-09)
1,475 reads
Does The Join Order of My Tables Matter?
Photo by pan xiaozhen on UnsplashI had a great question submitted to me (thank you Brandman!) that I thought would make for a...
2017-11-21
424 reads
Does The Join Order of My Tables Matter?
I had a great question submitted to me (thank you Brandman!) that I thought would make for a good blog post:
...I've been wondering if it really matters from a...
2017-11-21
9 reads
How do I use VSTS variables in YAML CI Build definitions?
Hey, VSTS YAML builds are my new favorite thing, by like a million miles.
If you have a yaml build definition...
2017-11-21
431 reads
How do I use VSTS variables in YAML CI Build definitions?
Hey, VSTS YAML builds are my new favorite thing, by like a million miles.
If you have a yaml build definition...
2017-11-21
40 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