A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
234 reads
Editorials
The Network Bottleneck
Computer networks are critical for our work, but if they get clogged with new types of data, we might have a problem.
2019-11-08
239 reads
2019-11-07
224 reads
Predictions for PASS
Steve is missing the PASS opening keynote, but he has a few predictions for the day.
2019-11-06
166 reads
Logging Tables
Today Steve Jones looks at the need to log data from an application or process. Are there good and bad ways to design the structures to log information?
2019-11-05 (first published: 2015-09-25)
615 reads
2019-11-04 (first published: 2015-11-13)
425 reads
A Faster tempdb
I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]
2019-11-02
1,153 reads
A Mindset Shift
Microsoft has grown and changed their culture in the last few years, which greatly impresses Steve.
2019-11-01
315 reads
2019-10-31
284 reads
Falling Behind and Digital Bankruptcy
The challenges of information overload can weigh on technology workers.
2019-10-30
200 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