SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be customer information for different clients – but they all...
2010-12-28
49 reads
Jason Brimhall
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give...
2010-12-20
827 reads
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give a little follow-up on how my foray into Powershell...
2010-12-20
5 reads
Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification...
2010-12-16
870 reads
Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification more accessible to the masses. You can read more...
2010-12-16
5 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not...
2010-12-15
541 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not end with the birth of our baby girl two...
2010-12-15
2 reads
T-SQL Tuesday #13 – Business Requirements
Business Requirements
We have made it yet another month and to yet another episode in the continuing saga known as TSQL...
2010-12-14
658 reads
T-SQL Tuesday #13 – Business Requirements
I think a common area that is easily overlooked when it comes to requirements and interpretation of requirements is report creation. A common problem is that there are no...
2010-12-14
1 reads
SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago...
2010-12-13
508 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