Two Important ‘ONLINE’ Column-Level Operations in SQL Server
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
346 reads
Editorials
2020-01-13
269 reads
2020-01-11
288 reads
2020-01-10
306 reads
A Problem with Cowboy Coding
Cowboy coding can be a problem, and in a case Steve talks about, a temptation for someone to get more work.
2020-01-08
513 reads
Great Writers Get Hired
Steve thinks one of the ways you can stand out with your resume or CV is by writing well and attracting the attention of hiring managers.
2020-01-07
176 reads
Quick Security Mistakes
Steve reminds you to be careful of taking shortcuts, as these can compromise security. Automation and DevOps might help you avoid mistakes.
2020-01-06
286 reads
The Art of Commenting
This week Steve talks about the ways in which comments are important in our code.
2020-01-04
289 reads
The Time to Patch
Microsoft has spent years working on building a reliable and dependable patch process for their software. While some products have had more sporadic updates, SQL Server has moved to a fairly regular schedule. Not quite a predictable "Patch Tuesday" schedule, but you can count on a CU arriving every month or two for SQL Server. […]
2020-01-03
816 reads
2020-01-02
330 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