Reflections on PASS Virtual Summit 2020
PASS Summit 2020 has wrapped up (or is in the process of wrapping up), and as with years past, I’m getting this written while the experience is still fresh...
2020-11-17
3 reads
Blog Posts
T-SQL Tuesday #132 Pandemic Coping
This year, 2020, has been crazy. What started as a normal year for me, including a sabbatical, turned into a crazy, shutdown, lockdown, stuck at home pandemic around the...
2020-11-17 (first published: 2020-11-10)
225 reads
Daily Coping 16 Nov 2020
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...
2020-11-16
15 reads
Deploy SSRS Projects with Two New PowerShell Commands
I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig & Publish-RsProject. While the Write-RsFolderContent...
2020-11-16 (first published: 2020-11-11)
816 reads
Export SQL Server Configurations for DR purposes
Is your SQL environment prepared for a disaster? There are big and small disasters and depending on your perspective big and small can mean different things. Preparing your environment...
2020-11-16 (first published: 2020-11-10)
644 reads
SQLpassion Black Friday Deal 2020
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-11-16
3 reads
Notes on the 2020 PASS Virtual Summit – Part 6
Mostly Friday notes here. This morning I was the moderator for Continuous Integration with Local Agents and Azure DevOps by Steve Jones. The way the Summit worked this year...
2020-11-14
24 reads
Daily Coping 13 Nov 2020
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...
2020-11-13
24 reads
I get by with a little help from my friends : T-SQL Tuesday #132
Taiob Ali (blog|twitter) is our host for TSQL Tuesday this month and he’d like us to talk about how our ... Continue reading
2020-11-13 (first published: 2020-11-10)
266 reads
Notes on the 2020 PASS Virtual Summit – Part 4
Last night (Tuesday) was the main reception and then “networking bubbles”. The reception consisted of DJ Leanne playing assorted music (and seeming to have a good time doing so)...
2020-11-13
22 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