When good enough is good enough
Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not ... Continue reading
2022-08-30
24 reads
Blog Posts
AWS RDS Restore To A Point In Time
The single most important part of backups are not backups. The single most important part of backups are restores. It doesn’t matter a lick if you have 100, flawless...
2022-08-29
11 reads
Daily Coping 29 Aug 2022
I 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...
2022-08-29
13 reads
Power BI guidance documentation
Recently there has been a number of great articles published on Power BI that I wanted to make you aware of that go beyond the features descriptions found in...
2022-08-29 (first published: 2022-08-09)
556 reads
Setting up SQL Server 2022 s3 Object Storage Integration using MinIO with Docker Compose
In this blog post, I’ve implemented two example environments for using SQL Server 2022’s s3 object integration. One for backup and restore to s3 compatible object storage and the...
2022-08-29 (first published: 2022-08-13)
643 reads
Daily Coping 26 Aug 2022
I 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...
2022-08-26
16 reads
T-SQL Tuesday #153: The Thing That Changed Everything for Me – SQLFamily
Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell us the story of how attending an IT conference or event
The post T-SQL Tuesday #153:...
2022-08-26 (first published: 2022-08-09)
281 reads
T-SQL Tuesday 153: The conference that changed everything
This month’s T-SQL Tuesday is hosted by my dear friend Kevin Kline (b | t) . Kevin’s call is for us to ‘Tell us the story of how attending an IT conference or...
2022-08-26 (first published: 2022-08-09)
300 reads
Daily Coping 25 Aug 2022
I 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...
2022-08-25
12 reads
Explicit and implicit datatype conversions
Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because ... Continue reading
2022-08-25
40 reads
Blogs
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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