What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
2009-12-18
160 reads
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
2009-12-17
263 reads
Some change requests, such as deploying a new stored procedure or trigger, are relatively easy to manage whereas others, such as data deployments, tend to thwart all attempts at standardization. And yet, there must be a way, and Rodney Landrum believes that DBA-developer co-operation lies at the heart of it.
2009-12-16
300 reads
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
101 reads
A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.
2009-12-14
437 reads
Steve Jones looks at query optimization, and based on some blogging from Microsoft, the level of impact that you can have on a system.
2009-12-14
92 reads
For today's Friday poll we have a guest editorial from Jeff Moden. The head of the anti-RBAR alliance has spent a lot of time trying to help others write better T-SQL and solve their problems with code that performs well. However this Friday Jeff asks about the CLR and how you are using it, or not using it, in the real world.
2017-08-11 (first published: 2009-12-11)
754 reads
A guest editorial from Andy Warren today looks to inspire you with a few thoughts about how you might force yourself to grow a little next year.
2009-12-10
112 reads
What's the most important thing about your application? The code? The accuracy of its calculations? The layout of the reports? Steve Jones has another opinion.
2014-10-17 (first published: 2009-12-09)
204 reads
This editorial was orignally published on Dec 8, 2009. It is being re-run as Steve is on vacation. Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.
2014-10-01 (first published: 2009-12-08)
153 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Comments posted to this topic are about the item 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