DB Audit Challenge #1
Take the DB Audit Challenge - Intermediate - DB Audit Challenge #1
For those of you who have been following my recent blogs,...
2009-11-01
1,191 reads
Blog Posts
PASS Summit In-flight Note
I'm on a Delta non-stop flight from Atlanta to Seattle for the PASS Summit. This is the first time I've...
2009-11-01
1,274 reads
SQL PASS Summit 2009 – Day Zero
For me, today was the start of a six-day SQL Server adventure at the PASS Summit in Seattle. The day...
2009-11-01
710 reads
Stored Procedure Call Tree
I was reading a post by Linchi Shea in which he demonstrates a Perl script to Find the complete call...
2009-11-01
1,801 reads
Two Very Important Configuration Settings For SQL Server 2005/2008
Two settings that I always enable when I install SQL Server 2005 or 2008 on an x64 production database server...
2009-11-01
5,910 reads
Blogging From the 2009 PASS Community Summit
Like a lot of other SQL Server bloggers, this week I will attempt to write regular blog entries each day,...
2009-10-31
1,383 reads
Not Attending/Presenting at SQL Connections
Given everything that has happened in the last couple of weeks, this is not surprising to those who have kept...
2009-10-31
1,379 reads
PASS Officers for 2010-2011 Announced
Posted yesterday at http://www.sqlpass.org/Community/PASSBlog/articleType/ArticleView/articleId/118.aspx, Rushabh Mehta is the incoming President, Bill Graziano is the VP Finance, and Rick Heiges is...
2009-10-31
1,424 reads
SQL Server 2008 cluster install and slipstreaming!
I was asked to set up a SQL Server 2008 cluster on Windows 2008 R2 this past week. One interesting...
2009-10-31
2,116 reads
The Gift Count
I went by Best Buy this afternoon, with my updated budget, to grab 2 last gifts and blow out the...
2009-10-31
1,452 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