Daily Coping 22 Mar 2023
Today’s coping tip is to appreciate your hands and all the things they do for you. I make a living with my hands. I type constantly, which is a...
2023-03-22
6 reads
Blog Posts
Daily Coping 21 Mar 2023
Today’s coping tip is to listen to a piece of music without doing anything else. This is surprisingly hard. I turn something on, but then I look around, think...
2023-03-21
15 reads
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
28 reads
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
13 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
12 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
8 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
21 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)
690 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
13 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
39 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers