Complexity. How it is calculated.
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
687 reads
SQL Code Guard
Varchar "miracle" and best practice
I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...
2014-05-20
664 reads
ExpressProfiler: The New Kid on the Block
I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools...
2014-05-15
613 reads
Psst! Wanna some API?
If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool...
2014-05-11
696 reads
A few words about simplicity: Using Red-Gate Ecosystem framework
In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...
2014-05-04
530 reads
When issue is not exactly "issue"
In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.Eg - ST012 "Consider using temporary table instead of...
2014-04-27
560 reads
New release 2.4.5222
Today we released new version of SQL Code Guard - 2.4.5222There are many fixes and improvements, some new rules were added.Full...
2014-04-20
327 reads
Why I Developed SQL Code Guard: A Fairy Tale from a DBA
A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...
2014-02-24
826 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