Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors had slipped through my checks and the various reviews. I had a lot of reviewer...
2023-03-21
26 reads
Blog Posts
20 Minute Sessions: A Couple of Thoughts
At the most recent SQL Bits, I gave two 20 minute sessions. I also gave one last year. There is a little bit of controversy around these (nothing real,...
2023-03-20
11 reads
Daily Coping 20 Mar 2023
Today’s coping tip is to get outside and notice how the weather feels. This was a good tip to see before my trip last week to the UK. I...
2023-03-20
10 reads
Data Tester Diary: Jak jsem úspěšně složila ISQTB certifikaci
V Joyful Craftsmen máme skvělý bonus (tzv. SGP), v rámci, kterého se můžeme vzdělávat v určitém tématu a tím se posouvat dopředu. Já jsem si jako Data Tester pro svoje...
2023-03-20
5 reads
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
18 reads
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)
639 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
10 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
34 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
18 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
21 reads
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers