Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...
2012-11-12
12 reads
SQLSequel
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...
2012-11-12
9 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might...
2012-11-12
1,333 reads
Financial Transparency is Good for Community
I was recently in a conversation with several people that had previously organized one or more community events. The topic evolved into a discussion of Sponsors, and eventually, fund...
2011-11-07
9 reads
Financial Transparency is Good for Community
I was recently in a conversation with several people that had previously organized one or more community events. The topic evolved into a discussion of Sponsors, and eventually, fund...
2011-11-07
3 reads
Financial Transparency is Good for Community
I was recently in a conversation with several people that had previously organized one or more community events. The topic...
2011-11-07
885 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
8 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
6 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone’s clamoring to cut taxes -but no...
2011-09-26
888 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often, these tables have only a single row of data...
2010-11-16
6 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