This article has demonstrated a meaningful and efficient method to test and validate the necessary firewall ports for Availability Groups (AG) and WFC.
The post Firewall Ports You Need to...
2021-01-06 (first published: 2020-12-31)
4,539 reads
I had the honor of presenting a new session, Backup Basics with Powershell and dbatools, at the first Ohio North Database Training meeting this evening. Thank you to the...
2021-01-06
9 reads
I had the honor of presenting a new session, Backup Basics with Powershell and dbatools, at the first Ohio North Database Training meeting this evening. Thank you to the...
2021-01-06
7 reads
In one of my recent assignments, my client asked me for a solution, to reduce the disk space requirement, of the staging database of an ETL workload. It made...
2021-01-06 (first published: 2020-12-31)
476 reads
To view posts about previous T-SQL Tuesday entries, please use this tag. The late, great, Robert Davis invited us on Independence Day 2010 to write about Gettin’ Schooled: We...
2021-01-06
20 reads
XEvents is here to stay and is a powerful tool for ALL of your SQL implementations - whether they be Azure SQL or the traditional on-premises SQL Server.
The post...
2021-01-05
9 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-05
10 reads
Covid-driven disruption calls for a higher degree of consistency and clarity on the data assets handled by any organization, because in the months to come there will be a...
2021-01-05
13 reads
I’ve been working on a project where I use Azure Data Factory to retrieve data from the Azure Log Analytics API. The query language used by Log Analytics is...
2021-01-05 (first published: 2020-12-24)
399 reads
Ironically, I’m a few months behind on a recap for my presentation on building and using a sustainable, dynamic date query in M code – Saving the Day from...
2021-01-05
7 reads
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...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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