Debugging query timeouts by sampling blocking – part 2
In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...
2012-03-20 (first published: 2012-03-15)
2,898 reads
Debugging query timeouts with X-Events – part 1
I like hunting. Not the kind where you are walking around the forrest and trying to find a target. No,...
2012-03-10
2,110 reads
How to use Change Data Capture (CDC)
With SQL Server 2008 Microsoft added the CDC feature to SQL Server enterprise edition. I haven’t come to play around...
2012-03-05
8,052 reads
MERGE with OUTPUT clause
A few days back I was presented with a theoretical challenge, and now I thought I would share my solution...
2012-02-29 (first published: 2012-02-21)
9,068 reads
ANUG: Masters at Work
In November last year, our very own Henrik Sjang Davidsen did a session at the ANUG event called Masters at...
2012-02-14
1,015 reads
PIPE CLIP – (| CLIP)
The main focus of this blog is to write about SQL Server related stuff – but now and then in the...
2012-02-07
795 reads
Meet the Geniiius Family
Over the next few weeks / months there will be plenty of opportunities to meet the Geniiius family, since we started...
2012-01-31
1,576 reads
Generate test data using DBGen
Over the last couple of months I have on several occasions found myself in need of test data for demos,...
2012-01-24
14,375 reads
SQL Server 2012 FileTable – Part 2
In this weeks blog post we will have a look at how easy it is to combine FileTables and FullText...
2012-01-18 (first published: 2012-01-12)
2,927 reads
TOP WITH TIES
I have been working with SQL Server for quite a few years now, and it still happens quite often that...
2012-01-17
6,234 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