Earlier this week, Jeff Atwood suffered the sort of misfortune we all dread: hard drive failure and no backups. Tony Davis discusses what can be learned from this in terms of the chain of responsibility for an organization's data.
Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.
Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.
Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.
Recent installments of our series dedicated to the most important features of SQL Server 2005 Express Edition have focused on its Full Text Indexing capabilities. This article covers other full text indexing management methods.
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
A sample chapter on clustering from Manning Publishing. Read it to learn a bit on clustering and preview this new book.
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Comments posted to this topic are about the item 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