SQL Ops Studio extension development : Starting an adventure
I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...
2018-04-26
1,193 reads
Blog Posts
SQL Server 2016 – SQL Server Telemetry \ CEIP Services
CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage...
2018-04-26
8,958 reads
SQL Server Advanced Aggregations Part 1 Grouping Sets
This post is part 1 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...
2018-04-26
108 reads
SQL Server database Backup and Restore strategies
One of the most important roles of a database administrator is to constantly protect the integrity of the databases and...
2018-04-26
552 reads
Benefits for Veterans
Wanted to share a few things I came across recently with regards to benefits for veterans:
You can get a printed...
2018-04-25
347 reads
Dates and Times in SQL Server: T-SQL functions to get the current date and time
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...
2018-04-25
389 reads
Exploring the Caves of Code Analysis in #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-25 (first published: 2018-04-16)
2,296 reads
In-Memory OLTP: A Case Study
Watch this week’s episode on YouTube.
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start...
2018-04-25 (first published: 2018-04-17)
2,942 reads
Live, Learn, and Grow
Ever look back at old work and wonder what was I thinking when I did that? Or even better you...
2018-04-25
329 reads
Quick tip: format source code in html
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
90 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