SQL Server Problems We Don’t Have Anymore
There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.
Microservices
Steve doesn't think microservices work with relational databases, but maybe you can convince him otherwise.
Date Tables are Great for Users, but Not So Great for Performance
If you haven’t used a date table before, here are a couple of primers on how to create one and use it.
Better Government Security Through DevOps
DevOps can help provide better security for your databases.
SQL Server Interview Questions for Developers on Querying
In this article we look at some simple ways to test a SQL Server developers T-SQL skills with some query questions and answers.
Configuring Availability Groups in Ubuntu
In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]
Data Analysis Without a Server
The ability to analyze lots of data on a workstation can be a way to test things without overloading server systems until you are sure your code works.
Redgate Streamed Returns
Our virtual community event is back with a global feel. Featuring speakers including Donovan Brown, Abel Wang, Kendra Little & Damian Brady, we have a full day of live content & networking opportunities, spanning world-wide time zones. So, wherever you are in the world, join us live on Wednesday August 26.
Subset in R including List, Data Frame, Matrix and Vector
In this article we will examine the R Language subsetting operators, types of subsetting and differences in behavior for different R objects like vectors, lists, and data frames.
An Introduction to Azure Synapse Analytics Workspace
Introduction The Azure Synapse workspace is in preview mode as of July 2020. The workspace brings together enterprise data warehousing and big data analytics. This workspace has the best of the SQL technologies used in enterprise data warehousing, Spark technologies used in big data analytics, and pipelines to orchestrate activities and data movement. Here, I […]
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