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
13 reads
Blog Posts
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
10 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
22 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)
724 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
23 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
41 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
35 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
32 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
31 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
35 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
ALAMAT KONTAK BCA KCU PONTIANAK Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT KONTAK BCA KCU BALIKPAPAN Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers