Daily Coping 16 Mar 2023
Today’s coping tip is to take three calm breaths at regular intervals during the day. I had to travel recently, crossing time zones and moving between planes, trains, and...
2023-03-16
11 reads
Blog Posts
Book Review – SQL Query Design Patterns and Best Practices
Disclaimer: The publisher – Packt – sent me a free copy of the book for the intended purpose of a review. At the time of writing, the book is...
2023-03-15 (first published: 2023-03-05)
510 reads
Daily Coping 15 Mar 2023
Today’s coping tip is to slow down if you find yourself rushing too often. The modern world encourages rushing around. We try to do so many things, get to...
2023-03-15
11 reads
Stellar Repair for MS SQL – Product Review
If you’re experiencing delays and errors while working with SQL Server databases due to corrupt database files, you may feel frustrated and helpless. Fortunately, Stellar Repair for MS SQL...
2023-03-15
47 reads
Tales From The Field Weekly Wrap Up for the Week of 02-27-2023 & Some Changes
Hello Dear Reader! Change is the one constant in life and over here at Tales from the Field we've been hard at work making some changes. Over the last 5...
2023-03-15 (first published: 2023-03-07)
88 reads
Daily Coping 14 Mar 2023
Today’s coping tip is to notice how you speak to yourself and choose to use kind words. I was downtown recently for a few days with my wife, staying...
2023-03-14
9 reads
FIRST Robotics Competition 2023
For the past few years, I have been a mentor for FIRST Lego League and now FIRST Robotics Competition at our school. When I was in high school, I...
2023-03-14
18 reads
JC Bootcamp Stories – Nikola
Od minulého roku jsme spustili náš 4-týdenní Joyful Craftsmen Bootcamp pro budoucí Data Engineers. Jedná se o intenzivní studium přímo u nás v Joyful Craftsmen HUBu, které posouvá datové...
2023-03-14
19 reads
Continuing on the Journey of Azure Synapse Analytics
Azure Synapse Analytics has always enamored me. With its analytics service capabilities bridging the gap between enterprise data warehousing and Big Data analytics, it provides the end users much...
2023-03-13 (first published: 2023-03-03)
322 reads
Daily Coping 13 Mar 2023
Today’s coping tip is to start today by appreciating your body and that you’re alive. I greatly appreciate my body today. I had a long weekend, with a lot...
2023-03-13
7 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
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