Top Query Search in SQL Monitor
SQL Monitor v12.0 has added a new Query Text Search feature to allow users to search the text of the most expensive queries that executed on a SQL Server instance over a period. Here's what it does, and how it works.
Trusting STRING_SPLIT() order in Azure SQL Database
Learn about the changes to the STRING_SPLIT function in Azure SQL Database that allows you to specify ordinal position of the output.
Building a Production Database
Lessons learned from building a database caught Steve's eye, and he has a few comments.
On-Demand: 2021 Accelerate State of DevOps webinar
Redgate is a proud sponsor of this year’s Accelerate State of DevOps Report, by the DevOps Research and Assessment (DORA) team at Google Cloud. Watch our lastest webinar to find out how the future of DevOps will effect you.
SQL Server RETURN and OUTPUT Clause in Stored Procedures
In this article we look how to use RETURN and OUTPUT in a SQL Server stored procedure to get a return value after execution.
Creating Markdown Formatted Text for Results from T-SQL
Markdown documents are becoming increasingly more popular and relevant with the emergence of notebooks. Markdown is a markup language for creating formatted text. It is widely used in tools for collaboration, tools for creating documentation and notebooks. Formatting is easy to understand, readable, simple to adopt, and agnostic. I can use a markdown document on […]
Leading-Edge NoSQL Drivers for NoSQL Analytics and Integration
NoSQL databases, such as MongoDB, are an increasingly important component of enterprise data strategy, handling high-volume, scalable, and agile data management. As organizations adopt emerging NoSQL solutions, there is high demand to integrate these data sources with existing infrastructure and familiar tools. Standards-based data access facilitates your expansion into MongoDB by leveraging existing skills using […]
Monitoring Your Hybrid Environment with Redgate
Join this Microsoft hosted webinar to hear from Microsoft MVP and Redgate Advocate, Grant Fritchey to learn more about monitoring hybrid database environments, as part of their Azure Series.
What is Power Query?
In this tip we'll introduce you to Power Query, the self-service data preparation tool from the Power BI family
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