Understanding Zonal Redundancy in Azure SQL MI
Do you know what happens when you enable zonal redundancy for your SQL managed instance? Lets define it first (in the context of Business-Critical tier) – zonal redundancy is...
2025-07-16
91 reads
Arun Sirpal
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature enabling you to distribute read-only workloads such as reporting and analytics across built-in replicated secondary...
2025-07-15
110 reads
Secure Azure SQL Server Backups Using Managed Identities
I do believe most people know about the ability to backup your SQL server databases to URL (from Azure VMs). If you recall you would use the storage key...
2025-05-09 (first published: 2025-04-23)
373 reads
Microsoft Entra Authentication for Azure PostgreSQL
Straight from Microsoft’s documentation “Microsoft Entra authentication is a mechanism of connecting to Azure Database for PostgreSQL flexible server by using identities defined in Microsoft Entra ID. With Microsoft...
2025-02-12 (first published: 2025-02-03)
271 reads
Minimize Downtime with SQL MI Disaster Recovery
I speak to many people who use cloud technologies, especially database tech and how little consideration they give to their MISSION CRITICAL Databases that run in the cloud and...
2024-10-18
37 reads
Snowflake + Azure blob
Let’s go back to data platforms today and I want to talk about a very common integration I see nowadays, Azure Blob Storage linked to Snowflake via a storage...
2024-10-18 (first published: 2024-10-04)
166 reads
Blockchain + RWAs
Blockchain technology is still at the hype stage for an emerging technology cycle, it gets a bad image from all the dodgy web3 “crypto” fake projects out there (based...
2024-09-05
17 reads
Tech in 2030
What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...
2024-08-09 (first published: 2024-07-31)
122 reads
WHAT IS A SPV?
Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...
2024-08-09
21 reads
Azure SQL MI License free?
A common setup when leveraging the cloud is to use the cloud for Disaster recovery (DR) purposes, some say it becomes a logical extension of your on-prem / data...
2024-03-11 (first published: 2024-02-27)
442 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...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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