Speaking at the Future Data Driven Summit 2023
I’m going to give a lightning talk at the online (free) Future Data Driven Summit. The subject is How I saved 80% on my Azure Data Factory Costs. The...
2023-09-08 (first published: 2023-09-07)
11 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Book Review – Scalable Data Analytics with Azure Data Explorer
I recently finished the book Scalable Data Analytics with Azure Data Explorer (Modern ways to query, analyze, and perform real-time data analysis on large volumes of data), written by...
2023-09-01 (first published: 2023-08-16)
101 reads
Analyzing Azure Cosmos DB Data with Azure Synapse Link – YouTube Live Stream
At Tuesday 6th of June 2023, I’m giving an online version of my session “Analyzing Azure Cosmos DB Data with Azure Synapse Link” (which I presented at Techorama). It’s...
2023-06-05
22 reads
Techorama Slides – Analyze Cosmos DB Data with Synapse Link
I’ve uploaded the slides for my session at Techorama to Github.
The post Techorama Slides – Analyze Cosmos DB Data with Synapse Link first appeared on Under the kover of...
2023-05-15
23 reads
New Stars of Data – SQL Bad Practices caught in the Wild
At the 12th of May 2023, a new edition of New Stars of Data takes place. If you’re not familiar with the concept, it’s a free virtual event focusing...
2023-05-12 (first published: 2023-05-11)
55 reads
Change the Default Git Branch for a dbt Cloud Project
In dbt, you can link your project to a github account, which is obviously the right thing to do. By default, the project uses the main branch. But what...
2023-05-05 (first published: 2023-04-24)
54 reads
Get your Query History in Redshift
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for...
2023-04-28 (first published: 2023-04-20)
136 reads
Star Schema Merchandising Available
Those of you who follow me on social media (twitter | LinkedIn | mastadon) or who read my blog here, might be familiar with my catchphrase “STAR SCHEMA ALL...
2023-04-06
110 reads
Book Review – SQL Query Design Patterns and Best Practices
Disclaimer: The publisher – Packt – sent me a free copy of the book for the intended purpose of a review. At the time of writing, the book is...
2023-03-15 (first published: 2023-03-05)
520 reads
Reading AFAS REST API Data with Azure Logic Apps
Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process...
2023-03-13 (first published: 2023-02-26)
252 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...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
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