NodeXL – Accessible Network Graph Analysis, part 3 (Twitter)
This is the third blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.
If you are interested,...
2014-05-27
376 reads
Blog Posts
SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014
This event promises to be a highlight of the Canadian SQL Server calendar year.
The presenters are all 'first class'.
All...
2014-05-27
807 reads
Webcast Follow-Up: 5 SQL Server Indexing Myths
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-05-27
898 reads
Attaching All Databases with PowerShell–Finding My MDF Files
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-05-26
1,530 reads
Database Backup Encryption with SQL Server 2014
A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...
2014-05-26 (first published: 2014-05-19)
5,745 reads
Dealing with SQL Server LOCK resource errors.
I was recently doing some testing that required a fairly large table. I created the test table, and set it...
2014-05-26
805 reads
How Database Mail works in SQL Server ?
Database Mail is email feature in SQL Server from SQL Server 2005 onwards. This feature used for mailing alerts, notification,...
2014-05-26
1,055 reads
It’s Time to End Password Reuse
Last week Ebay announced that some accounts were compromised, including passwords with as yet unstated encryption. Those who aren’t tech...
2014-05-26
684 reads
Languages of Big Data Apache Hadoop
Languages of Big Data
Big Data is here and rapidly growing. If you are just starting to learn about Big Data...
2014-05-26
866 reads
Last Weeks Top “Reading” Links #85
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-05-26
646 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