Dev Tools: XYplorer (review #1) - Catalog.1
currently on version 14.60
I'm a big fan of finding tools that help automate and streamline things that should are routine...
2014-12-24
1,492 reads
Blog Posts
PowerPivot Saga 2: DAX OR function (OR there is something better)
I didn't realize that the DAX OR function only accepts 2 arguments compared with the similar function in Excel where a limit of...
2014-12-24
12,947 reads
SQLSaturday#380 NYC Event Update - Precons, Speakers....
Just wanted to blog a quick update on SQLSaturday#380 in NYC, happening on May 30, 2015. As you are hanging...
2014-12-24
1,292 reads
Tracing call stacks in SQL Server – Introduction
At this fall’s SQLIntersection conference in Las Vegas I attended, Paul Randal’s (t|b)“Performance Troubleshooting Using Latches and Waits” precon. Where at he asked for some assistance compiling data for a...
2014-12-24
8 reads
Tracing call stacks in SQL Server – Introduction
At this fall’s SQLIntersection conference in Las Vegas I attended, Paul Randal’s (t|b)“Performance Troubleshooting Using Latches and Waits” precon. Where at...
2014-12-24
1,037 reads
WordPress, Project NAMI, and Azure
I’ve been running WordPress for years now and find it to be a solid solution for what I want to...
2014-12-24 (first published: 2014-12-16)
6,385 reads
Playing with the log – VLF order while growing the log
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...
2014-12-23 (first published: 2014-12-17)
5,838 reads
SQL – How to Find Missing Sequence in a table
Problem statement:-
A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?
Download code...
2014-12-23
1,577 reads
SSIS #118–Is it an OLEDB or an SMO Server Connection?
OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...
2014-12-23 (first published: 2014-12-17)
7,866 reads
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office,
not a creature was stirring not even old Maurice.
With merriment going on...
2014-12-23
534 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
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
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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