Finding guidance
We all need guidance as we make our way through our careers and our lives. Some people are blessed with the right folks who can offer that by way...
2023-03-24 (first published: 2023-03-17)
141 reads
Blog Posts
Resources for Architecting Zero Downtime Deployments
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las Vegas 2023. It went fairly well, even though I ran some incorrect code somewhere. Apologies...
2023-03-24 (first published: 2023-03-23)
48 reads
Daily Coping 23 Mar 2023
Today’s coping tip is to focus your attention on the good things you take for granted. My life is great. I used to say perfect, but a few struggles...
2023-03-23
8 reads
FIRST Robotics Competition 2023 - World Championships!
Last week I wrote about our FRC team, asking for support in in the form of a cheering section. Today, I’m asking for more assistance for these amazing students.
Things...
2023-03-23 (first published: 2023-03-21)
86 reads
Resources for Adding Graph Structures to Your Database at VS Live
Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on graph databases. I hope you enjoyed it, and if you have questions, please feel free...
2023-03-23
16 reads
Call to Action for Female Speakers to Submit to EightKB
EightKB is a wonderfully ran conference by my friends Mark Wilkinson (T | B), Anthony Nocentino (T | B), Andrew Pruski (T | B), and
The post Call to Action...
2023-03-22 (first published: 2023-03-14)
120 reads
Children at Technical Conferences Part II
Nearly 10 years ago I wrote a blog post about having my son tag along at various conferences I was speaking at. So much has changed in the past...
2023-03-22 (first published: 2023-03-13)
217 reads
Daily Coping 22 Mar 2023
Today’s coping tip is to appreciate your hands and all the things they do for you. I make a living with my hands. I type constantly, which is a...
2023-03-22
6 reads
Daily Coping 21 Mar 2023
Today’s coping tip is to listen to a piece of music without doing anything else. This is surprisingly hard. I turn something on, but then I look around, think...
2023-03-21
13 reads
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors had slipped through my checks and the various reviews. I had a lot of reviewer...
2023-03-21
28 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
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
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