Unlock Your Notion Data with SQL
If your Notion workspace feels more like a data graveyard than a command center, you're not alone. I’ll show you how to connect SQL to your Notion setup so...
2025-08-28
67 reads
Blog Posts
Azure SQL Migration Wizard: Features, Benefits & Real-World Use Cases
🌐 What is Azure SQL Migration Extension? The Azure SQL Migration Extension for Azure Data Studio is a powerful tool that simplifies the process of migrating on-premises SQL Server...
2025-08-27 (first published: 2025-08-06)
234 reads
SQL Server I/O Bottlenecks: It’s Not Always the Disk’s Fault
“SQL Server is slow.” We’ve all heard it. But that doesn’t always mean SQL Server is the problem. And “slow” means nothing without context and ability to verify. More...
2025-08-27 (first published: 2025-08-06)
503 reads
SQL Server 2025 Release Candidate Available
For those testing SQL Server 2025 before it officially releases, Microsoft has made the first release candidate available. There's a lengthy article on all the new features that are...
2025-08-26
134 reads
AI Transformation and Security in Microsoft’s 2025 Announcements
Microsoft’s latest wave of announcements in July 2025 offers a compelling snapshot of how the tech giant is navigating innovation, security, and global responsibility. For tech leaders, these updates...
2025-08-25 (first published: 2025-08-04)
556 reads
Deploying SQL Server to Kubernetes via SQL Server 2025
Following on from my previous post about hitting the Kubernetes API from SQL Server 2025 let’s go a little further and deploy SQL Server 2025 to Kubernetes from…SQL Server...
2025-08-25 (first published: 2025-08-01)
359 reads
70 Years of Artificial Intelligence History in 15 Minutes
How long has AI been around in different domains? What was it called before we starting using the phrase, "Artificial Intelligence?" Is Clippy included in said history? Here is...
2025-08-22 (first published: 2025-08-05)
509 reads
A New Word: Rivener
rivener – n. a chilling hint of distance that creeps slowly into a relationship – beginning to notice them laugh a little less, look away a little more, explain...
2025-08-22
14 reads
From Zero to Dashboard: A SQL Project for Total Beginners
Let's build a real data dashboard. This guide will walk you through the entire process using free tools like BigQuery and Looker Studio, even if you’re just getting your...
2025-08-22 (first published: 2025-08-04)
1,063 reads
Accessing the Kubernetes API from SQL Server 2025
The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit external rest endpoints…which opens up quite a few interesting options. I was thinking about this...
2025-08-20 (first published: 2025-07-31)
516 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