Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
177 reads
Jason Brimhall
Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
930 reads
Message in a Bottle of XE
Considering this "feature" for everything that is SQL Server related, does this mean that all Extended Events related messages are accessible in sys.messages?
Related Posts:
Implicit Conversion Fail May 31, 2019...
2017-12-27
5 reads
12 Days Of Christmas and SQL
In the spirit of the 12 Days of Christmas and Giving, I have a 12 Day series that I generally try to do each Holiday Season. The series will...
2017-12-26
4 reads
12 Days Of Christmas and SQL
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
447 reads
12 Days Of Christmas and SQL
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
178 reads
Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
142 reads
Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
1,264 reads
Best New(ish) SSMS Feature
Enabling the scrollbar map has saved me oodles of time - even without the preview option enabled. I can much more quickly hop to different segments of code with...
2017-12-26
4 reads
Extended Events Permissions
Some view the permissions for Extended Events as a limitation. I see the required permissions as an appropriate set and recommend all to work with XE and permissions to...
2017-12-26
131 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