MCM – The Knowledge Exam
I recently took the knowledge exam, and I loved it. I thought it was a great exam. I have taken...
2011-03-11
1,674 reads
Blogs
SSRS: My Filter is not Working!!!
I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the...
2011-03-09
2,616 reads
SSRS – Creating and Using Shared Schedules Part 4
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-09
1,154 reads
Changes to the SSIS Slowly Changing Dimension Component
Probably not the kind of change you're expecting. I've recently been contacted by the Kimball Group, and they've asked me...
2011-03-03
2,559 reads
Some Suggested SQL Server 2008 R2 Instance Configuration Settings
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-03-02
2,690 reads
5 Things Every DBA Should NOT Do
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
2011-03-01
5,946 reads
Fundamentals of Storage Systems, IO Latency and SQL Server
A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...
2011-03-01
3,045 reads
Emailing tempdb Query Results to Paul Randal with PowerShell
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
2011-02-28
1,959 reads
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-28
2,838 reads
Renumbering Rows in a Table Variable (or Table/Temp Table)
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...
2011-02-24
2,097 reads
Blogs
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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