Making music with Powershell
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
960 reads
Blog Posts
My Second Pester Test
I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I...
2017-12-20 (first published: 2017-12-07)
2,108 reads
Our SQL Server 2017 Administration Inside Out fun author survey
I was honored to be on the author team of the new SQL Server 2017 Administration Inside Out book by...
2017-12-20
798 reads
UNDERCOVER TOOLBOX: sp_AGReconfigure – Manage Always on Sync & Failover settings from a single stored procedure.
From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes...
2017-12-20 (first published: 2017-12-08)
1,477 reads
Westbound and down, roll ’em up and truckin’
A little less than 2 years ago, my wife and I loaded up our cats and dog and moved from...
2017-12-20
417 reads
A Basic Bot using Azure Bot Services
I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....
2017-12-19
576 reads
Do You Really Need Real-Time?
It wasn’t so long ago that the first day of the month was the most common trigger event for updating...
2017-12-19
396 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like this:
And output them so that the Cars and Toys...
2017-12-19
112 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like...
2017-12-19
7,600 reads
How to Update @@SERVERNAME to Actual Machine Name?
The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...
2017-12-19 (first published: 2017-12-07)
4,521 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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
Safe and Reliable Transport of Farm Machinery: Solutions of the Modern Agricultu
Ship A1 Auto Transport is a reliable provider of services who delivers safe and...
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...
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