Matillion: strategic to modern at Connect for Health Colorado
As part of its ‘All Cloud’ push that began to take shape in 2019, Connect for Health Colorado (C4) selected Matillion ETL to be its cloud ETL/ELT tool. At...
2021-09-12
17 reads
Blog Posts
Setting Trace Flags and Configuring SQL Server Containers
In this blog post, we will walk through a few examples of how to configure SQL Server in Docker Containers. First, we will configure a container at runtime by...
2021-09-12
170 reads
Setting Trace Flags and Configuring SQL Server in Kubernetes
In this blog post, we will walk through a few examples of configuring SQL Server in Kubernetes. First, we will create a Deployment for SQL Server, override the container’s...
2021-09-12
21 reads
My personal experience with a split-brain scenario in MSSQL Server
The split-brain scenario in a database environment is a situation whereby the communication link between two different sites is broken, as a result of this situation the production database...
2021-09-11
46 reads
AWS BYOC – Bring your own SQL Server cluster with AWS EC2 and SIOS
Originally posted on DataSteve: Introduction They are multiple options to implement HADR solution for SQL Server in AWS public cloud. The easiest way to do that is to use...
2021-09-10 (first published: 2021-08-25)
162 reads
Daily Coping 10 Sep 2021
I 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...
2021-09-10
27 reads
Goal Progress for August 2021
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. I’m late in putting this out, but here goes. Current...
2021-09-10
22 reads
The sysname datatype defaults to not NULL.
The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for ... Continue reading
2021-09-10 (first published: 2021-08-26)
196 reads
Daily Coping 9 Sep 2021
I 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...
2021-09-09
24 reads
Remote Desktop: Force the resolution to match the screen size.
One of the things I hate most about using remote desktop is when the resolution for the remote server is ... Continue reading
2021-09-09
59 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