Hangout #18 with Boris Hristov
Yesterday evening I had the honour and pleasure of recording one of his famous SQL Hangout with my friend Boris Hristov (b|t).
We...
2014-04-18
248 reads
Blog Posts
Improving Query Performance by using correct Search Arguments
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-18 (first published: 2014-04-08)
6,566 reads
MDS: A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2014-04-18
1,592 reads
Reblog: April 11 to April 17
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-04-18
496 reads
Speaking at SQL Bits XII
I’m heading back to SQL Bits for the third time and I’m excited to be going again. I think that...
2014-04-18
654 reads
Upcoming Presentations in May
Next month, I’ll be making a couple of stops at SQL Saturday events in the south. On May 3, I’ll...
2014-04-18
762 reads
Bringing Power BI Q&A to your Organization Recording and Q&A
I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15...
2014-04-17
971 reads
oPASS Tonight! (April 17, 2014)
I’m presenting tonight at oPASS, two presentations worth! If you’re in Orlando I hope you’ll attend, details at http://orlando.sqlpass.org/.
2014-04-17
530 reads
SSMS Auto Recovery
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write...
2014-04-17
833 reads
The One Million Row T-SQL Test Harness
So far in our blogs, we have talked a bit about performance, but today we’re going to show you a...
2014-04-17 (first published: 2014-04-08)
4,658 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