Following on from my Learner’s Guide to SQL Server Performance Triage, I’m tackling Query Tuning. In this guide, I’m experimenting with an outline style rather than expanding each paragraph....
2020-05-18 (first published: 2020-05-01)
997 reads
An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 ... Continue reading
2020-05-18
412 reads
I am thrilled to announce that I have been accepted to deliver a preconference boot camp called ‘Amplify Your Virtual SQL Server Performance‘ at this year’s PASS Summit conference,...
2020-05-18
20 reads
In the last post, we have discussed the DTU purchase model. Azure also provides another purchase mode which is called vCore. vCore purchase model available with all three deployment...
2020-05-17
8 reads
I’ve been working with some complex builds lately, multi-stage ones, and I’ve been annoyed by the Azure DevOps agent. If you’re like me, you might see this in Agent...
2020-05-15 (first published: 2020-04-29)
323 reads
Clumio’s Rapid Recovery is amazing, and you should know more about it. You might not have heard of Clumio before. Clumio is an upstart SaaS-based backup solution for both...
2020-05-15 (first published: 2020-04-30)
373 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-15
20 reads
This month we will likely have two releases of the Power BI Desktop. The April release was delayed into May so it could be announced
2020-05-15
78 reads
I had the privilege of working with Tessa Hurr (PM on the Power BI team) on a presentation for the 2020 Microsoft Business Applications Summit (MBAS) about five features...
2020-05-14
20 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-14
12 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...
Ship A1 Auto Transport is a reliable provider of services who delivers safe and...
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