In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by...
2023-03-20 (first published: 2023-03-09)
654 reads
I recently did a talk to the Data Platform Down Under User group and it covers a whole heap of stuff that I’ve written about in this series. Check...
2023-03-20
13 reads
In late March 2021 Azure Data Explorer Engine v3 was release and it is the latest version of the engine that powers Azure Data Explorer. It is designed to...
2023-03-20
38 reads
I can’t really write about provisioning anything in Azure without mentioning Azure CLI.My last two posts were about using terraform and bicep Here we will be using the Azure...
2023-03-20
22 reads
So in my last post I wrote about how to provision Azure Data Explorer using terraform . In this post I will use bicep to provision Azure Data Explorer....
2023-03-20
26 reads
If you’ve read my blogs before or seen me speak you’ll know that I love the DevOps. Provisioning Azure Data Explorer can be a complex task, involving multiple steps...
2023-03-20
27 reads
I was talking to an ex-client earlier this week and he saw the drafts of my blog posts around DevOps infra-as-code spinning up Azure Data Explorer and he said...
2023-03-20
30 reads
Hello Dear Reader! What an incredible week we had. I started off traveling on Monday of last week. At the airport I ran into my friend David Pless (...
2023-03-20
12 reads
As many of you are aware, I have been dealing with a progressive version of ALS which is affecting my hands and arms and thus my ability to type....
2023-03-20 (first published: 2023-03-09)
115 reads
Thanks to everyone that came to my talk at SQL Bits. Powerpoint here for download. If you have questions, reach out.
2023-03-19 (first published: 2023-03-18)
15 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Think there's a reason why this is still in preview, but have someone manage...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers