Spider-Man Homecoming Twitter Sentiment
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing movie with a fantastic cast. Both of us are...
2017-07-10
3 reads
SQLBalls
Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the...
2017-03-10 (first published: 2017-03-01)
2,230 reads
Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the big four zero.... 40. A little wiser? Maybe. Despite...
2017-03-01
3 reads
How Do I Add an R Package to SQL Server from In-Database R?
Hello Dear Reader! I'm working on some really fun stuff with in-database R using SQL Server 2016.
I needed to...
2017-02-28
911 reads
How Do I Add an R Package to SQL Server from In-Database R?
Hello Dear Reader! I'm working on some really fun stuff with in-database R using SQL Server 2016. I needed to add a couple packages to my R engine so...
2017-02-28
6 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network,...
2017-02-07 (first published: 2017-02-03)
1,858 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some...
2017-02-03
6 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem....
2016-12-21 (first published: 2016-12-05)
3,320 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem. They had a large amount of skewness/data skew. This...
2016-12-05
6 reads
SQL Azure, Hekaton, and Bob Dorr is Awesome
Hello Dear Reader! I had recently written a blog for the PFE blog, "How Many Tables Can I Have In...
2016-08-29
930 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