Azure Cosmos DB API Architecture
Again, still we have a lot of information we can spread our knowledge on it for Cosmos DB today I will talk about Cosmos DB API options and How...
2020-07-27
10 reads
Blog Posts
Building an Azure Architecture Diagram
One of the challenges I have at times is illustrating how I’d set up a particular system. Not the technical details, the visual ones. I can use boxes and...
2020-07-27
68 reads
Daily Coping 27 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-27
37 reads
Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)
I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.
In this episode I share...
2020-07-27 (first published: 2020-07-16)
945 reads
SQL Server and Docker Compose
I used to think that Docker Compose was used solely to spin up multiple containers, in fact I blogged about doing just that here. That opinion changed when I...
2020-07-27 (first published: 2020-07-17)
1,558 reads
SQL Server Stretch DB to Azure
Since SQL Server 2016 we could leverage Microsoft Azure to dynamically move “cold” portions of data away from on-premises storage for longer retention time periods. Whilst in theory being...
2020-07-27
44 reads
Recapping SQL Saturday Albany 2020 (virtual)
This weekend was SQL Saturday Albany 2020. This was my third time attending the Albany event, my second time presenting, and my first virtual SQL Saturday. As always, Ed...
2020-07-26
4 reads
Getting Started with Stream Analytics
Resources
Resources
If you want a schema reference for the json Application Insights produces // [Azure Application Insights Data Model // Microsoft Docs
](http://bit.ly/2S3kFlD)
If you want to visualize last 90 days of...
2020-07-25
28 reads
Daily Coping 24 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-24
11 reads
Giving Back to Speakers
It might be hard to think back to 2007, but at that time, there were only a few SQL Server events taking place in the world. SQL Bits held...
2020-07-24
54 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 KCP Banjarbaru Telp,Cs:08218154393
WA:08218154393 Jl. A. Yani No.KM 33 5, Guntung Payung, Kec. Landasan Ulin, Kota Banjar...
ALAMAT KONTAK BCA KCU SAMARINDA Telp,Cs:08218154393
WA:08218154393 Jl. Jend. Sudirman No.30, Ps. Pagi, Kec. Samarinda Kota, Kota Samarinda, 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