A New Word: Fitching
fitching – v. intr. compulsively turning away from works of art you find frustratingly, nauseatingly good – wanting to shut off the film and leave the theater, or devour...
2024-07-12
22 reads
Blog Posts
Data Technology Learning Resources
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put together an interesting collection of data over on GitHub. It’s titled DBA Resources, but it...
2024-07-12 (first published: 2024-06-27)
216 reads
Take the SQL Saturday Topic Survey
What topics do you want to see presented at a future SQL Saturday (or other event)? Steve Rezhener has built a survey that you can take. Take the survey...
2024-07-12 (first published: 2024-06-25)
90 reads
How to Create a Beautiful and Functional Site for Your WordPress Meetup Group
Taking advantage of our free site offer for your WordPress community? Here are some new templates you can use.
2024-07-11
16 reads
Create a copy of an Azure SQL DB
Where I work, we will be migrating data from one set of databases into another. I will be making a copy of the destination databases to allow us to...
2024-07-10 (first published: 2024-06-25)
369 reads
Exploring Windows Function Execution Plans
There are quite a few different ways that you’re likely to see windows functions evidence themselves within your execution plan. Let’s take a look at one example. Windows Function...
2024-07-10 (first published: 2024-06-24)
265 reads
2024-07-09
11 reads
Deleting Old Local Git Branches–#SQLNewBlogger
I had a lot of local branches for a repo (actually a few repos). I know these are old and not used anymore, so how do I delete them?...
2024-07-08
31 reads
System Views in Microsoft Fabric – Query references an object that is not supported in distributed processing mode
I have a metadata-driven ELT framework that heavily relies on dynamic SQL to generate SQL statements that load data from views into a respective fact or dimension. Such a...
2024-07-08 (first published: 2024-06-08)
766 reads
Use Your Voice
If you want more of a career and less of a job, one thing you will have to do is learn to use your voice. I mean this on...
2024-07-08
20 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