Using a Service Account in Microsoft Fabric
Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA and password expiration.
2024-10-25
Articles
Troubleshoot Chained SQL Server CTE
This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.
2024-10-23
2024-10-21
2,002 reads
Data Lake Implementation – Data Lake Zones and Containers Planning
The Azure Data Lake is a massively scalable and secure data storage for high-performance analytics workloads. We can create three storage accounts within a single resource group.
2024-10-21
Outer Join – What am I missing (SQL Spackle)
This article shows how to find missing rows in a table using a outer join.
2024-10-18 (first published: 2013-11-12)
24,276 reads
Uncover SQL Server Missing Indexes
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
2024-10-18
AWS Services Using SQL for Big Data Analysis
AWS offers a robust suite of tools designed to manage big data effectively. This article explores focusses on how SQL is leveraged within Amazon Redshift and Amazon Athena. We will delve into the technical features, practical applications, and step-by-step examples for using these services, highlighting how they can transform raw data into actionable insights for your business.
2024-10-16
367 reads
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
This next article looks at how a Logic App in Azure can start and stop various database services and save money.
2024-10-16
2,089 reads
Enhancing SQL Server Searches with Elasticsearch and Python
Learn how to get started with Elasticsearch with data in your SQL Server database.
2024-10-14
2,452 reads
Azure Managed Instance Download and Restore SQL Server Backup
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.
2024-10-14
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...
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