An Introduction to Conatiners and Docker: Switch to Windows Containers
This is Chris Gibson's second post. This post follows on from his first post called: An Introduction to Containers and...
2017-03-23
1,005 reads
Gethyn Ellis
UK Budget 2017 – The Death Knell for Small Business?
Well I suspect not however I suspect it will likely have a major impact. What has this got to do...
2017-03-21
508 reads
An Introduction to SQL Server 2016 Query Store
By David Postlethwaite
David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this...
2017-03-18
718 reads
An Introduction to Containers and Docker
By Chris Gibson
This is the debut blog post of Chris Gibson. Chris is in expert in Microsoft Windows and is...
2017-03-16
1,479 reads
Do you need a degree to be DBA?
This question gets asked a lot and reoccurs over the years. Do you need a degree to be DBA? I have seen...
2017-03-02
430 reads
Permanent Employment v Contracting: How the figures stack up
In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over...
2017-02-24 (first published: 2017-02-21)
3,497 reads
Valentine's day love from Learning Tree...
The latest course offer is in from Learning Tree!! And It's Valentine's Day!
Learning Tree are showing you the love with...
2017-02-14
339 reads
How to Count the Total Number of Rows Across Multiple Tables
I have been working on SQL Server Consulting assignment, a SQL Server 2014 migration for a new client over the...
2017-01-31 (first published: 2017-01-22)
44,810 reads
SQL Server 2008 RTM - Maintenance Plans need Integration Services installed
The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not...
2017-01-31
900 reads
Enabling Remote Access to the Dedicated Admin Connection
Recently I was running a health check on one of my clients SQL Servers and I noticed that access to...
2017-01-30
2,928 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