Documenting with Tests
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
2019-10-04 (first published: 2015-05-14)
277 reads
Editorials
2019-10-03
235 reads
Searching for Answers Inside
Learning how an organization, or even just a codebase, works can be a challenge for new employees.
2019-10-02
144 reads
It's Natural to Avoid Problems
Culture change is hard, and it's one of the most difficult things to implement when trying to get your team to work in a DevOps fashion.
2019-10-01
232 reads
Unreliable Data Sensors
Steve doesn't like the idea of cars using data from cameras to update a display instead of a mirror.
2019-09-30
195 reads
Celebrate Success
Today Grant reminds us to not only think about the things we can do better, but remember the good things that we accomplish.
2019-09-28
168 reads
Thanking the Volunteers
Grant takes a moment to thank the SQL Saturday organizers that put on these amazing events.
2019-09-27
114 reads
Would a Duress Password be a Good Idea?
Today we have a guest editorial from Andy Warren. Should we adopt a duress password, just in case we find ourselves in a movie situation while at work?
2019-09-26 (first published: 2015-04-21)
492 reads
The Multi-skilled Developer
Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.
2019-09-25 (first published: 2015-06-08)
623 reads
Is Data the Future of the Vibrant Web?
There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.
2019-09-24
172 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