Leadership
Steve Jones talks about the need for leadership and what managers should be looking to achieve in their efforts.
2010-05-03
165 reads
Editorial
Would You Like a Stay Interview?
For this Friday poll, Steve Jones talks about an interesting concept. The "stay interview."
2010-04-30
383 reads
Man in the MIddle
Are you worried about man in the middle attacks on your database server? If you run Oracle you should be, but SQL Server DBAs should not assume they are safe. Adding communication encryption can be a good idea for SQL Server DBAs.
2010-04-29
288 reads
Regular Service
Steve Jones feels that we ought to get regular service packs from Microsoft to support SQL Server. Not everyone agrees. Do you?
2010-04-28
105 reads
Concrete Code
When building a new database or system, are you designing concrete code? Should you be? Steve Jones comments on matching your needs with your architecture.
2010-04-27
192 reads
Minimal Meetings
Too many meetings happen in software teams. Steve Jones says that when scheduling meeting, you should be aware of the cost, and only include those people that need to be there.
2014-11-27 (first published: 2010-04-26)
211 reads
Financial Data in the Cloud?
Phil Factor believes that there will have to be further compromises between the pioneers of The Cloud and the regulators, before companies feel safe in entrusting their financial data to such an abstract service, seemingly 'remote from sand and iron'.
2010-04-26
354 reads
Spring Cleaning
For a Friday poll this week, Steve Jones is looking at those spring cleaning or annual maintenance activities that you might perform on your systems.
2010-04-23
154 reads
What Do We Want?
Today Steve Jones talks about the challenges of deciding what to include in that next software release. Something that likely isn't as easy as we might think it should be.
2010-04-22
91 reads
Speed Racer
Speed is critical. That's the theme for today's editorial, using the NYSE as an example.
2010-04-21
136 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