Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.
Baton Rouge, LA. LSU. Free Training. Come visit, learn a few things, and enjoy meeting other SQL Server pros.
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
This Friday Steve Jones talks performance reviews. The system in place at Microsoft is a tough one, which allows some to thrive, and some not to. Is it one you'd like to have in place?
Arshad Ali shows you how to create standard/custom report templates in SQL Server Reporting Services (SSRS), to ensure consistency throughout the organization in both the look and feel of reports.
A look at the performance of SQL Server compared to SQLite for single user applications.
An interesting reuse of technology in a completely new way caught Steve Jones' eye. See if you agree that this is rather amazing.
Annette continues her popular series for SSIS beginners by showing how a data flow task can be used in a package to move data from a SQL Server database to an Excel file, and insert an additional column into the Excel file that’s based on derived data.
Today Steve Jones talks about one of his pastimes: reading. He recommends you read more, and share the books you enjoy.
The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services, for use within the pipeline without code or a SQL Server connection. As featured in The Microsoft Data Warehouse Toolkit by Joy Mundy and Warren Thornthwaite from the Kimbal Group.
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