70-457 Reviewer #08, Implementing Clustered Instance in SQL Server 2012
This part of the review is still a part of the topic Maintain Instances and Databases which accounts for 17%...
2013-08-01
628 reads
Coffee and SQL
Amazon Partners With Cloud vLab To Teach Developers How To Use AWS
Reblogged from TechCrunch: Nobody has ever accused Amazon Web Services of hiding its complexities. It seems even Amazon acknowledges that...
2013-07-31
1,374 reads
Using MSX and TSX to scale out your maintenance plans
For our front office alone, I manage about 15-20 SQL database servers. Add to that other database servers that I...
2013-07-30
1,341 reads
How secure is your IT career? Really?
I was reading some articles from my favorite influencers in LinkedIn and I came across this one. I was enlightened...
2013-07-30
1,227 reads
SQL Server Management Studio Rainbow Edition
Reblogged from The SQL Pro: Ever wanted to know the reason behind the Database color scheme in SQL Server Management...
2013-07-29
694 reads
What I’m sayin’ is…everything is fine.
Let’s say you are a member of the development team. Your team got a new project in the works, so...
2013-07-29
634 reads
Free Ebooks! Free Ebooks!
There’s a lot to smile on a cool Monday like this. One, it’s 27C outside here in Singapore, a lot...
2013-07-29
700 reads
Go ahead. Laugh.
I came across one of my twitter friends @DBAReactions tumblr site and gosh! I cannot stop laughing! Here is one...
2013-07-27
534 reads
70-457 Reviewer #07, Resolving Concurrency Problems in SQL Server 2012
This topic is part of the lessons covered in Optimization and Troubleshooting SQL Server 2012 which is 14% of overall...
2013-07-25
1,847 reads
Understanding Contained Database in SQL Server 2012
SQL Server 2012 supports contained databases and partially contained databases, which provide a high degree of isolation from the database...
2013-07-24
1,242 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