SQL Saturday #408 Houston – June 13th 2015
Call for speakers is now open for SQL Saturday #408 in Houston, TX. If you are interested in presenting please...
2015-03-13
896 reads
Blog Posts
SQL Server Virtualization for VM Admins – SQL Saturday Madison Precon
I am pleased to announce a brand new pre-conference training session, entitled “SQL Server Virtualization for VM Admins“, to be...
2015-03-13
535 reads
Why You Shouldn’t Skip the Infrastructure/Security Architecture Review
It’s not usual for development projects to undergo an architecture review, but too many times these reviews consist only of...
2015-03-13 (first published: 2015-03-09)
5,646 reads
Allowing a User to Create Objects in a Schema
I was testing something the other day and realized this was a security area I didn’t completely understand. I decided...
2015-03-12
1,176 reads
Altering a Column with NOT NULL
A short piece, as I ran into the need recently to alter a column to NOT NULL status. I’ve rarely...
2015-03-12
786 reads
Future of Database Mirroring
One of the beloved feature of SQL server standard edition for HA is database mirroring, since you only have 2-node...
2015-03-12
485 reads
Operational Data Store (ODS) Defined
I see a lot of confusion on what exactly is an Operational Data Store (ODS). While it can mean different...
2015-03-12 (first published: 2015-02-26)
9,563 reads
SQL backup directly to Azure storage
Most companies required to keep their database backup offsite (on tape) for many years due to audit requirement. This normally...
2015-03-12
965 reads
Audit Schema Change Report
In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion. You can read about that here. I recommend reading...
2015-03-11
6 reads
Data Compression–A unique feature PART–II TIP #92
In last post TIP #91 we talked about What is Data compression ? What are the features ? Now in this tip...
2015-03-11
617 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