Daily Coping 27 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-27
7 reads
Blog Posts
Explain RDBMS and History of SQL Server?
RDBMS means Relations Database Management System. RDBMS is one of the DBMS types where data is stored in 2 dimension structures called “Table”. RDBMS stores data in table format...
2020-04-27
79 reads
It’s 2020, Do I really need to DBCC CHECKDB?
I’ll start by saying that I swear I posted this at some point in the past but I don’t see it looking back at old posts. This is from...
2020-04-27 (first published: 2020-04-15)
1,542 reads
ML Models
In this series I would be talking mostly about Python and R, we would understand the different ML model supported in Python. Python is a great open source language...
2020-04-27
13 reads
Register for Data Platform Discovery on Apr 29
The agenda is out for the US Data Platform Discovery Day. It’s online, and takes place this Wednesday, April 29, 2020. You can register and check out all the...
2020-04-27
7 reads
SSDT: Scripting static data from SQL Server (video)
Out of the box, SSDT covers objects on a database level, like tables, stored procedures, views, functions, etc. That means schema only. In many cases, there is a need...
2020-04-27
106 reads
T-SQL Tuesday Live–28 Apr 2020
Once again, I’ll be live tomorrow, ready to just chat, shoot the breeze, answer tech questions, anything. No agenda, but I’m on for an hour. If you’re bored, struggling,...
2020-04-27
8 reads
What is the datatype SQL_VARIANT
The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. ... Continue reading
2020-04-27 (first published: 2020-04-16)
601 reads
Stairway to Microsoft Azure SQL Database Part 1 : Deployment Options
Recently I started working with Azure SQL Database. It took some time for me to understand the concepts of the Azure SQL database. Earlier I have experience in AWS...
2020-04-26
311 reads
Stairway to Microsoft Azure SQL Database Part 1 : Deployment Options
Recently I started working with Azure SQL Database. It took some time for me to understand the concepts of the Azure SQL database. Earlier I have experience in AWS...
2020-04-26
9 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Forums
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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