An Android Update - TMobile G1
I still love my G1, and I got a pleasant surprise recently. I was out at dinner with my wife,...
2009-06-25
1,484 reads
Blog Posts
Exceptional DBA Award Entries Must Be In By July 10, 2009
If you have been considering entering yourself in the Exceptional DBA Awards this year, or nominating a DBA you know,...
2009-06-25
1,596 reads
How to Avoid Database Restore Issues by a Simple Script Edit - A DB Restore Work-around
During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT...
2009-06-25
2,664 reads
My Favorite Bad Movie
My favorite bad movie is The Master Gunfighter starring Tom Laughlin of Billy Jack fame. It’s a Western, and he’s...
2009-06-25
1,499 reads
Plug for a Cool Catalog
Ran across the Levenger site while researching laptop bags and it’s branded as ‘tools for serious readers’. Some of it...
2009-06-25
1,445 reads
Powershell + SMO Error Handling Tips
Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO...
2009-06-25
1,669 reads
Better Know A SSIS Transform – The Sort Transform
This is part 2 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-06-24
8,661 reads
Dell Mini – The Follow Up
Back in January I posted about purchasing a Dell Mini 9, wanting to see what how it worked and a...
2009-06-24
1,371 reads
SQL Server 2008 Encryption - Extensible Key Management
One of the new features with SQL Server 2008 is the addition of extensible key management, allowing hardware devices to...
2009-06-24
3,951 reads
What’s the Typical Resignation Notice Period for DBAs?
I was recently talking to a friend from the U.K about how much notice a DBA should give to their...
2009-06-24
2,007 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