2023-04-29
137 reads
Editorials
The Survivors
There have been a lot of layoffs in the last year. Steve has some empathy for both those let go and those that remain. He also reminds us to manage our own careers.
2023-04-28
162 reads
Creating Documentation
Who should create documentation for software? In many companies, it's the developers. In fact, in Redgate, often our developers are tasked with updating articles for products on our documentation site. We do have a streamlined process that has developers can submitting changes in some format (markdown? ) and an automation process that automatically updates the […]
2023-04-26
219 reads
A Case for Document Storage
Someone makes a case for using a Document DB rather than a RDBMS. Steve has a few thoughts.
2023-04-24
173 reads
AI Concerns
With the ChatGPT and AI crazy sweeping through the media, Steve has a few thoughts on what this might mean for data professionals.
2023-04-22
198 reads
A Third Break
Steve talks about a sabbatical as an amazing corporate benefit and is planning his third.
2023-04-21
126 reads
Data Modeling Information
Data modeling can be challenging for many reasons. Steve talks about the choices you make in how you store data should be a part of that.
2023-04-19
286 reads
Coming Out of the Cloud
Google announced a local version of their cloud databases that companies can install for developers.
2023-04-17
198 reads
Moore's Law: Navigating the Pace of Technological Change
Technology has always been a driving force in shaping our world, propelling us forward into new realms of innovation and progress. One of the most famous concepts in technology is Moore's Law, which suggests that the number of transistors on a microchip doubles approximately every two years, leading to exponential increases in computing power. In […]
2023-04-15
152 reads
The Loss of Knowledge
The loss of developer knowledge can be impactful for an organization. Steve notes that they should do more to retain their staff.
2023-04-14
187 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