Enjoying SQL Bits
It’s been a good week at SQL Bits. This is my favorite conference, and the organizers go out of their way to make it a fun and sustainable event....
2023-03-20
20 reads
Blog Posts
Intelligent Query Processing (IQP)
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
KQL Series – enough writing – some talking
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
11 reads
KQL Series – Kusto Engine V3 – let’s make stuff go faster
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
37 reads
KQL Series – some DevOps things: Provisioning using Azure CLI
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
21 reads
KQL Series – some DevOps things: Provisioning using bicep
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
23 reads
KQL Series – some DevOps things: Provisioning using terraform
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
25 reads
KQL Series – some DevOps things: Provisioning using ARM templates (dedicated to Scott)
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
28 reads
Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023
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
The Microsoft Ability Summit in Review
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)
114 reads
Blogs
I recommend Smart Brevity (book) for communications
By Brian Kelley
Following the advice in Smart Brevity improves communication.
SQL Server 2025 Developer Edition – One size fits all
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers