Changing the location of docker named volumes
A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...
2018-05-09 (first published: 2018-05-02)
1,801 reads
Blog Posts
Day 9 Variables
In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing...
2018-05-09
188 reads
First Wave of Sessions for PASSSummit Now Available
The first wave of sessions for the #PASSSummit have been released. You can see the list at: http://www.pass.org/summit/2018/Learn/ConferenceSessions.aspx
I am honored...
2018-05-09
927 reads
Relaxing on the Tab Management Terraces with #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-09
1,249 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine...
2018-05-09 (first published: 2018-05-01)
2,879 reads
T-SQL Tuesday #102: Giving Back
Last month we had the opportunity to discuss some of the most important tools for a data professional. I took...
2018-05-09
289 reads
T-SQL Tuesday #102: Giving Back
This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one's personal life equal in some...
2018-05-09
2 reads
#tsql2sday – Giving Back – Reprise
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us...
2018-05-08
234 reads
Contributing to Community
This post is a response to this month’s T-SQL Tuesday #102 prompt by Riley Major. T-SQL Tuesday is a way...
2018-05-08
650 reads
Contributing to Community
This post is a response to this month's T-SQL Tuesday #102 prompt by Riley Major. T-SQL Tuesday is a way for SQL Server users to share ideas about different...
2018-05-08
3 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