Review: Windows Live Writer Backup
Live Writer tends to be one of those applications that you spend a few minutes configuring and then you forget...
2010-02-16
580 reads
Blog Posts
SQL Developers Please Use the Table Name/Alias to Prefix Columns
Note: After I completed this post Aaron Bertrand added this subject to his “Bad Habits to Kick” series for myself...
2010-02-16
871 reads
SQL Server - Checkpoint
What is a SQL Server checkpoint?
A SQL Server checkpoint is the process of writing all dirty datafile pages out to...
2010-02-16
6,845 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-16
4,555 reads
The T-SQL Hammer
The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...
2010-02-16
3,474 reads
Three Turns On The Road
Huh? My story? Okay. It was never easy for me. I was born a poor black child. I remember the...
2010-02-16
1,118 reads
Finding Blog Topics
I used to think that I would run out of things to write about, but a decade after starting to...
2010-02-15
874 reads
First Public Hearing Against Quebec's Pension Fund Manager - The Beginning of Proof that Multiple Laws Were Violated (Before Sabia took over at least)
As mentioned in a previous post, between the months of January and September 2008 I was hired to be a Database...
2010-02-15
7,513 reads
nHibernate Database, First Look
I’m getting my first look at a full-fledged nHibernate database developed by consultants for our company. I thought I’d share...
2010-02-15
1,289 reads
Set your Warehouse Database to Read Only
In most environments new data is added to the data warehouse daily, weekly or even monthly.Even further, these changes typically...
2010-02-15
724 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