My Toolbox - Everything
Foreword
Not everything in the general sense, but a tool called Everything by voidtools (Download link). Usually, I have to make this distinction when googling.
No matter how great is my...
2022-09-27
38 reads
Blog Posts
SQL Server In Place Upgrades
Good morning dear blog reader. Today’s episode is fresh from a great weekend with the family. It is always fun to go on a road trip with my wife...
2022-09-27
2,519 reads
Daily Coping 26 Sep 2022
Today’s coping tip is to enjoy photos from a time with happy memories. On vacation today in Venice, so I ought to get more, but I’ve started to put...
2022-09-26
10 reads
Learning PostgreSQL: The Tools
In case you don’t know, I’ve been writing a series of articles over on Simple-Talk as I learn PostgreSQL. It’s all from the point of view of a SQL...
2022-09-26 (first published: 2022-08-01)
264 reads
T-SQL Tuesday #154 – SQL Server 2022
This month’s T-SQL Tuesday is being hosted by Glenn Berry , and the subject he chose is “SQL Server 2022.” Microsoft has recently released the RC0 version of SQL...
2022-09-26 (first published: 2022-09-13)
373 reads
Daily Coping 23 Sep 2022
Today’s coping tip is to notice what you are feeling without any judgment. Today I’m stressed. I have been traveling a bit and trying to work remotely from my...
2022-09-23
16 reads
Look Into Chocolatey
Just a suggestion, but I’d say you should look into Chocolatey. Let me explain why. Sabbatical For those who don’t know I was recently on a six-week sabbatical from...
2022-09-23 (first published: 2022-09-12)
349 reads
Snowflake – Where is the explain/execution plan?
Whatever your database background is you will have heard of an execution / explain plan. Snowflake is no different. Coming from a MS SQL background I was used to...
2022-09-23
118 reads
Using Snowflake – Hands On
Now let’s start the process of creating a snowflake account in the Azure Cloud. You can sign up for a free trial from here – https://signup.snowflake.com/ I am going...
2022-09-23 (first published: 2022-07-26)
388 reads
Daily Coping 22 Sep 2022
Today’s coping tip is to ask a trusted friend to tell you what strengths they see in you. On one hand this would seem easy. On the other, it...
2022-09-22
10 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