More Time to Certify
You have more time to earn that MCSA, MCSE, or MCSD, thanks to Microsoft and the pandemic.
2020-04-08
190 reads
Editorials
2020-04-07
208 reads
Have You Made a Difference?
In this time of crisis, it's up to each of us to make a difference in some way.
2020-04-06
206 reads
Next Person Up
Steve wonders today about the need to compete in our jobs, especially with employers that view us as resources.
2020-04-02
130 reads
Cursors Without Performance Penalties
Imagine how coding might take place if cursors were as efficient as complex SELECT statements.
2020-04-01
363 reads
2020-03-31
67 reads
Now Is a Good Time for Choices
The whole world is going through some interesting times. Chances are pretty high that you’re working from home and your principal interaction with others is through virtual means. I know I’m that way as is my company, Redgate Software. It can be challenging or rewarding, depending on how you go about it. What’s even more […]
2020-03-28
128 reads
Taking Stock of Your Career
With almost a quarter of 2020 gone, Steve notes it's be time to stock of your career.
2020-03-27
498 reads
A Data Controversy
A request to rapidly gather data caused some friction recently. Is that something that organizations ought to be prepared to handle?
2020-03-26
149 reads
The Challenge of Contracting
The nature of work might be changing, and Steve has a few thoughts on thinking about your job as always contracting.
2020-03-25
116 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