Showcase Your Figma Designs on WordPress P2
Figma — one of the most popular and fastest growing digital design tools today — was recently voted “the most exciting design tool of 2021.” In many organizations, a...
2021-02-09
5 reads
Blog Posts
Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...
2021-02-09
184 reads
T-SQL Tuesday #135 – Awesome Tools
It’s blog party week for T-SQL Tuesday, and I think this is a good choice for a topic. The host this month is Mikey Bronowski, and his invitation is...
2021-02-09
157 reads
T-SQL Tuesday #135 – The Tools That Make My Job Awesome!
Blog posts have been few and far between from SQL Undercover lately but what better to try and get us back in the swing again than with T-SQL Tuesday....
2021-02-09
138 reads
T-SQL Tuesday #135 – Tools Used for Getting Organized
This month’s T-SQL Tuesday is being hosted by Mikey Bronowski. The subject he chose is “The outstanding tools of the trade that make your job awesome.” Tools are the...
2021-02-09
17 reads
T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome
It’s been a while since I’ve posted on a T-SQL Tuesday topic and glad to see the topic being discussed by Mike Bronowski (blog) on tools. Throughout my career,...
2021-02-09
154 reads
2020 Advent of Code–Day 1
This series looks at the Advent of Code challenges. I started the Advent of Code at the beginning of December 2020, but life quickly got in the way. Weekends...
2021-02-08 (first published: 2021-01-27)
266 reads
3 new PowerShell functions for refreshing Power BI reports on a Power BI Report Server
I just wanted to give everyone a heads-up that a new version of the ReportingServicesTools module went out last week, and it includes 3 new PowerShell functions for working...
2021-02-08 (first published: 2021-01-28)
742 reads
Daily Coping 8 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-08
21 reads
SQLpassion Online Training about Locking, Blocking, and Deadlocking
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-02-08
5 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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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