Continuing to share tips and tricks using dbatools like the Refresh databases that belongs to availability group using dbatools posted a few days ago, today I will share a...
2020-06-12 (first published: 2020-05-28)
2,742 reads
I do think that we want to have diversity, for a number of reasons, but this means in many cases, embracing differences. My editorial today is on Gatekeepers, which...
2020-06-12
15 reads
I was thinking about the story The boy who cried wolf earlier today and realized that it has some lessons ... Continue reading
2020-06-12 (first published: 2020-05-28)
481 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-11
15 reads
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob storage. Now there are more new features for blog storage that I will talk about....
2020-06-11 (first published: 2020-05-25)
275 reads
On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server...
2020-06-11
3 reads
[MSSQLFUN & Decode ITeS becomes a family of 1600 individuals across the globe. Please join us on Facebook & YouTube.] SQL Server Level Principals SQL Server level principals are the only...
2020-06-11
38 reads
Time keeps on running and as I promised in my last article I would like to compare the Process ADD vs Partition Merge technique. In the previous blog I...
2020-06-11 (first published: 2020-05-25)
445 reads
This is all about enabling diagnostics telemetry for Azure SQL databases. For Azure SQL Database there are quite a few options to select from. Below shows the diagnostic settings...
2020-06-10
41 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-10
12 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Comments posted to this topic are about the item Doing Good at SQL Server...
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