Call to Action – Mentoring
A few weeks ago I attended the annual PASS Summit conference in beautiful Seattle, Washington. This is an event that I look forward to every year. Being able to...
2019-12-06
5 reads
Blog Posts
Cleaning up the [NOT] NULL for Columns with SQL Prompt 10
SQL Prompt 10 is out and there are a few interesting things that have changed in the product. One of these is the Quick Fixes, inspired by some other...
2019-12-06 (first published: 2019-11-25)
414 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4
This is the fourth and final post in a series about modern Data Lake
Architecture where I cover how we can build high quality data lakes using
Delta Lake,...
2019-12-06
79 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4
This is the fourth and final post in a series about modern Data Lake
Architecture where I cover how we can build high quality data lakes using
Delta Lake,...
2019-12-06
79 reads
HP is the 2019 Laptop Winner
This is for me, not necessarily for you, but I decided to go with the HP Spectre again. I saw an email from Best Buy over the Thanksgiving weekend,...
2019-12-06
49 reads
State of Database DevOps Survey
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe you’re automating all the things or maybe you’ve got a completely manual set of processes....
2019-12-06
53 reads
Collecting Diagnostic data from multiple SQL Server instances with dbatools
Keeping their SQL Server instances under control is a crucial part of the job of a DBA. SQL Server offers a wide variety of DMVs to query in order...
2019-12-05 (first published: 2019-11-24)
856 reads
Containers: Upgrading SQL Server from 2017 to 2019 RTM
Throughout the pre-release of SQL Server 2019, I was demoing an effectively instant, and magical, container upgrade from 2017 to 2019. However, when I finally downloaded the release bits...
2019-12-05 (first published: 2019-11-25)
323 reads
SQLOrlando 2019
We just had our final event of the year and looking back, not bad at all. No event in June or November, but 18 overall (16 listed below, plus...
2019-12-05
26 reads
What's New In SQL 2019? at the Little Rock, AR SQL Server User Group
Thanks to everyone who joined the Little Rock SQL Server User Group for a night all about SQL Server 2019! We got off into tangents and use cases for...
2019-12-05
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...
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