Connect() live stream for Developers around the World
Connect() is a yearly, Microsoft-hosted developer event that is broadcast live from New York City to developers worldwide.
The Connect(); 2017...
2017-11-13
271 reads
Blog Posts
Login failed for 'NT AUTHORITY\ANONYMOUS LOGON' - the fix you probably haven't tried yet
If you're seeing this for the second time, my apologies. I wanted to update the title but had to delete...
2017-11-13
2,908 reads
Power BI Custom Visuals Class (Module 77 – Card Browser)
In this module you will learn how to use the Card Browser Custom Visual. The Card Browser allows you to...
2017-11-13
1,036 reads
SQL Homework Nov 2017: Create a view
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they...
2017-11-13 (first published: 2017-11-01)
1,510 reads
SQL Server Log Shipping on Linux
Log shipping is a high-availability configuration that perhaps most of us are familiar with. It’s one of the oldest techniques wherein...
2017-11-13
345 reads
The GDPR and You
Ever heard of the General Data Protection Regulation? If not, go and read the Wiki. I’ll wait.
I can already hear...
2017-11-13
305 reads
The Tech & Gear of PASS Summit 2017
Continuing my series of posts about my PASS Summit 2017 experience. This is about gadgets/gear I brought & software I used, the gadgets I saw around the convention center,...
2017-11-13
3 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the...
2017-11-12
544 reads
Top 5 Reasons Why I think SQL Server on Linux is Legit
Here are my top 5 reasons why I thing SQL Server on Linux is Legit!
SQL Server on Linux is Fast – Earlier this year SQL Server on Linux posted...
2017-11-12
5 reads
Top 5 Reasons Why I think SQL Server on Linux is Legit
Here are my top 5 reasons why I thing SQL Server on Linux is Legit!
SQL Server on Linux is Fast – Earlier...
2017-11-12
868 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