More SQL Server Updates
Updates this week for SQL 2014, 2016, 2017 and SSMS have Steve thinking about the pace of patching.
2018-03-22
65 reads
Editorial
2018-03-21
115 reads
Are You a Traffic Cop?
A traffic cop isn't a great analogy for a DBA, but all too often it is an accurate one.
2022-09-19 (first published: 2018-03-20)
289 reads
If only the US would follow ...
Governments are requiring better security, and Steve wishes the US would follow.
2018-03-19
90 reads
2018-03-19
96 reads
2022-09-26 (first published: 2018-03-16)
361 reads
Great Developers Use Source Control
The title says it all. The great developers will use source control. This habit might not make you great, but it will help you improve.
2018-03-15
77 reads
2018-03-14
105 reads
The Reliable DBA
One of the important qualities for a database is being reliable. However, as your organization grows, you might need to ensure that your account for your people as well.
2023-06-23 (first published: 2018-03-13)
251 reads
2018-03-12
296 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...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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