Have We Devalued SQL Server Consulting?
Reading Time: 3 minutes
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training...
2014-11-21
336 reads
Blog Posts
MDX #45–Find all the Calculated Sets and Their Calculation Scripts
Now we know how to find all the calculation scripts in a cube by querying the DMV $SYSTEM.MDSCHEMA_MEASURES.
MDX #43–Find a MDX...
2014-11-21 (first published: 2014-11-14)
5,725 reads
NJSSUG SSIS Performance Tuning
On November 18, 2014 I had presented to the New Jersey SQL Server User Group (NJSSUG) on SSIS Performance Tuning. ...
2014-11-21
409 reads
Reblog: November 14 to November 20
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-11-21
837 reads
SQL Server Management Studio Reports
SQL Server Management Studio Reports
Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within...
2014-11-21 (first published: 2014-11-17)
7,605 reads
SQLSaturday Austin
I was pleased to get the email yesterday confirming that I was selected to speak at SQLSaturday #362 on January...
2014-11-21
599 reads
Encryption in Colorado Springs – Encrypting in the Application?
Last night was my annual presentation at the Colorado Springs SQL Server User Group. I try to make sure I...
2014-11-20
924 reads
FUD Makes Security Harder
The US government’s illogical screeds against better personal encryption for data and communications is well documented. Then comes this reported...
2014-11-20
682 reads
How to disable constraints of a table ? TIP #74
You are reading this post just because of two reason
1) You are curious whether it is possible or not...
2014-11-20
282 reads
In-Memory Virtual Chapter Co-Lead
It is official – since a couple of weeks I have become a co-leader of one of the newest Virtual Chapters...
2014-11-20
276 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