Additional Articles

All authors

Technical Article

Strategy, Tactics, and Business Intelligence

There is a lot of talk these days about “business intelligence” (BI for short). Pick up any magazine aimed at business or technology professionals, and you’re sure to read about things like data warehouses, dashboards, cubes, ETL, SCD, and a seemingly endless list of other specialized terms and acronyms. One might be left wondering, is this something to which I should be paying attention?

2006-06-06

2,524 reads

External Article

SQL Server Performance Testing

This (new) design bothered me. It violated one of the fundamentals that I'd learned and read about for years; namely keeping the primary key small and narrow. It also looked like it would be difficult to maintain. Finally, after arguing back and forth about the merits and drawbacks of each of the designs, we decided that testing them was the only way to be sure

2006-06-02

4,359 reads

External Article

SQL Server 2005 Integration Services - Transaction Support - Part 25

The latest article in our series discusses improvements in the transactional support implemented in SQL Server 2005 Integration Services. The more granular scope of transactions, which now can be assigned to arbitrarily designated Control Flow tasks and containers, makes it is possible to limit their impact or execute several of them in parallel. However, even with this improved functionality, you need to keep the blocking issues they might potentially introduce in mind.

2006-06-01

2,138 reads

External Article

Talking Technical

Should IT managers understand technical issues, or is a full appreciation of the technology somehow unworthy and unnecessary for senior staff? In such a rapidly changing industry where fortunes are made and lost by attempting to exploit gaps in the market too thin to see with the naked eye, the answer would seem obvious. However, I have repeatedly come across amazing gaps in the technical knowledge of managers.

2006-05-31

2,425 reads

All authors

Blogs

AI Step 1

By

RANK() vs DENSE_RANK(): #SQLNewBlogger

By

I haven’t done one of these in awhile, but I saw an article recently...

Using CAT for Testing of Data Agents

By

In last months one of the scenarios where you can use AI has been...

Read the latest Blogs

Forums

Missing the Jaro Winkler Distance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Missing the Jaro Winkler Distance

25 Years Later: What SQLServerCentral Meant to Me

By Brian Knight

Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...

Doing Good at SQL Server Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Doing Good at SQL Server...

Visit the forum

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