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
Blog Posts
Developer Q&A: John Kostak of Web Dev USA
"We can really be dangerous if we want, without being too afraid of it."
2024-09-05
25 reads
How Learning SQL Basics Transformed My Productivity
As a data analyst, my switch from Excel to SQL was revolutionary. This article reveals how an online SQL basics course dramatically improved my workflow. I've always depended on...
2024-09-04
172 reads
Microsoft Fabric reference architecture
Microsoft Fabric uses a data lakehouse architecture, which means it does not use a relational data warehouse (with its relational engine and relational storage) and instead uses only a...
2024-09-04 (first published: 2024-08-12)
499 reads
SQL Saturday Boston 2024 Plans
I was accepted to speak at SQL Saturday Boston 2024, which is taking place on October 5, 2024. One month away. This is a fun event that takes place...
2024-09-04
18 reads
State of the Database Landscape Survey 2024
Hello all! This post is nothing but a simple request. Please, if you have a few spare minutes, meander on over to this link and fill out the State...
2024-09-04 (first published: 2024-08-13)
155 reads
Simple Talks Episode 5
The fifth episode of Simple Talks is out. Simple Talks is the Redgate podcast from myself, Grant, Ryan, and Louis. The main page is here, and it has links...
2024-09-03
47 reads
The Secrets of One of the World’s Largest Ad-Free Blogs
There are no secrets about how PostSecret handles millions of visitors.
2024-09-03
17 reads
The Secrets of One of the World’s Largest Ad-Free Blogs
There are no secrets about how PostSecret handles millions of visitors.
2024-09-03
14 reads
Using T-SQL Snapshot Backup - Point in Time Recovery - Azure Edition
Introduction In this post, the third in our series on using T-SQL Snapshot Backup, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server...
2024-09-03
26 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