A second week at SQLskills – performance tuning
G’day,
Back in February, I was lucky enough to attend a week of training on SQL internals from the people at...
2011-08-14
1,163 reads
Blog Posts
Change User Desktop Folder Path by Using PowerShell
We could change your desktop folder location by using the following powershell script. Actually we need to change values of...
2011-08-14
5,199 reads
Counting code lines in SPs with Powershell
One of interesting tasks I once had is to check the # of code lines for all user stored procedures (SPs)...
2011-08-14
1,401 reads
Great new analytical functions in SQL Server 2011 “Denali”
SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read...
2011-08-14
649 reads
Recursively Enumerating Local and AD Groups
If you ever need to flatten out groups which may include nested local and AD groups there’s a really easy...
2011-08-14
4,251 reads
Database Administration Operation Road Map
In my company, every two years, we have a tradition to collectively ponder at the technology road map for the...
2011-08-13
2,327 reads
Gradually Deleting Data in SQL Server
If you have a situation where you have a very large table in SQL Server, where you need to periodically...
2011-08-13
1,615 reads
SQL MCM Training – Day 5
Today I've not taken too much notes, because the whole afternoon was about the Management
Data Warehouse and Multi-Instance Management. But...
2011-08-13
1,376 reads
Can You Dig It? – Researching Index Scans
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post.
"She can dig it!"...
2011-08-12
633 reads
Check Mount Points and Disk Free Space with PowerShell
Those who know me will know that this post is a little out of the ordinary… I am posting about...
2011-08-12
3,756 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