Orlando 101 For SQLRally Attendees: Shopping
The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the...
2011-05-05
667 reads
Blog Posts
Orlando 101 For SQLRally Attendees: Where To Eat
The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the...
2011-05-05
689 reads
Outlook Productivity Tricks
I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...
2011-05-05
2,102 reads
The First Post
I have been a SQL Server DBA and Developer for nearly ten years. In that time I have amassed a...
2011-05-05
442 reads
Designing Reports with Custom MDX Queries – part 2
…continued from part 1:
Building a Report
For the remainder of this article, I will demonstrate query and report design techniques by...
2011-05-04
1,678 reads
Designing Reports with Custom MDX Queries – part 3
Start at part 1
…continued from part 2:
Handling Parameters
When an MDX query is created using the graphic query designer, parameters can...
2011-05-04
1,212 reads
How do you create or update stored procedures.
G’day,
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system...
2011-05-04
17,934 reads
Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One
Advertisements
Meme Monday: I Got 99 SQL Problems and the Disk Ain’t One
I am a bit late to this party. I have seen...
2011-05-04
469 reads
PASS 2011 Summit Abstract Submissions
Today is the last day to submit session abstracts for the PASS 2011 Summit. I was lucky enough to speak...
2011-05-04
478 reads
Policy-Based Management and Local Password Policy
This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to...
2011-05-04
1,395 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