Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster Recovery (DR), load balance your applications or any other...
2017-10-04
21 reads
SQLDbaInternals
Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster...
2017-10-03
723 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of some performance recommendations. This first post will list and...
2017-09-16
11 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of...
2017-09-16
140 reads
SQL Server Replication snapshot initialization taking long time to be applied
Hello all,In today's post I want to share a tip that helped me troubleshoot an issue I was facing and couldn't find much documentation about it. To my friends...
2017-08-25
6 reads
SQL Server Replication snapshot initialization taking long time to be applied
Hello all,
In today's post I want to share a tip that helped me troubleshoot an issue I was facing and...
2017-08-25
4,095 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL Server also listed some resources you can use to...
2017-08-21
7 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL...
2017-08-21
135 reads
Training and tips to get certified with Microsoft (Part 3)
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.With this third post I'll keep answering the question Where did...
2017-08-11
4 reads
Training and tips to get certified with Microsoft (Part 3)
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.
With this...
2017-08-11
181 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