Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
258 reads
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
258 reads
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
6 reads
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-05-12
4 reads
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-10
9 reads
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of ... Continue reading
2022-05-05
11 reads
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start ... Continue reading
2022-05-04 (first published: 2022-05-03)
56 reads
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start ... Continue reading
2022-05-03
3 reads
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-04-15 (first published: 2022-03-31)
334 reads
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
25 reads
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
3 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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