They run, they return data. So what? Some SQL queries just waste your time and resources. Here’s what to stop writing – and the much smarter alternatives. Sure, your...
2025-05-31
168 reads
falesia– n. the disquieting awareness that someone’s importance to you and your importance to them may not necessarily match – that your best friend might only think of you...
2025-05-30
16 reads
I read Brent’s first look at SSMS and Copilot in there. He didn’t have a great opinion of the tool, especially comparing it to Gemini or Claude. I haven’t...
2025-05-30
100 reads
Another KDA case: Digitown’s utility bills suddenly doubled for no good reason. With the election coming up, I got pulled in to figure out what went wrong. I’ve got...
2025-05-30 (first published: 2025-05-02)
202 reads
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These silos lead to ineffective decisions from incomplete data, wasted resources through redundant efforts, and missed...
2025-05-30 (first published: 2025-05-12)
411 reads
As discussed in my blog and book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” (Amazon), organizations are often challenged with...
2025-05-28 (first published: 2025-05-06)
714 reads
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't just handy—it's crucial. Whether you’re making different data types play nice together or boosting query...
2025-05-28 (first published: 2025-05-14)
545 reads
The Two-Layer Model Explained “We added them to the database, but they still can’t connect.” Sound familiar? That’s the kind of confusion SQL Server’s two-layer security model creates when...
2025-05-28
107 reads
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts WHERE post_parent = 94341; ) UPDATE p SET...
2025-05-28
144 reads
Wondering which database to tackle first? I’ve got the lowdown on the top free choices for anyone new to SQL, and I’ll tell you exactly why they’re stellar for...
2025-05-28
629 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Comments posted to this topic are about the item Doing Good at SQL Server...
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