Using Extended Events in Azure
Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace,...
2017-02-10 (first published: 2017-02-06)
1,302 reads
All About SQL
SQL Server vNext
I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server...
2017-02-03
729 reads
Compare Execution Plans
Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the...
2017-02-02
437 reads
My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
816 reads
Interactive query experience for SQL databases
This is a new feature where you can issue TSQL commands via a TSQL editor straight from the Azure portal,...
2017-01-25
604 reads
Using Extended Events Telemetry Session
You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session...
2017-01-23
1,905 reads
MVPs
I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program...
2017-01-20
661 reads
SQL database built-in intelligence
I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in...
2017-01-18
497 reads
Looking at wait stats differently with SQL 2016
Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on sys.dm_os_wait_stats...
2017-01-16
627 reads
Checking Time Zones in SQL Server
I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...
2017-01-13
1,324 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