PASS Summit 2020 – My experience
This was the first year in 16 years for me that there has been a fall season without the PASS Summit to go to. Every year, during the fall,...
2020-11-25 (first published: 2020-11-15)
256 reads
Blog Posts
The Learning Curve for DevOps
If you’re attempting to implement automation in and around your deployments, you’re going to find there is quite a steep learning curve for DevOps and DevOps-style implementations. Since adopting...
2020-11-25 (first published: 2020-11-16)
274 reads
T-SQL Tuesday Retrospective #005: Reporting
A few weeks ago, I began answering every single T-SQL Tuesday from the beginning. This week it’s the fifth entry, and on April 5th, 2010, Aaron Nelson invited us...
2020-11-25
27 reads
Daily Coping 24 Nov 2020
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...
2020-11-24
24 reads
Database DevOps Deployment to Azure–Webinar
You can register now, but on Dec 3, I have a webinar with Microsoft on database devops and Azure. This is a joint effort with Redgate, so I’ll be...
2020-11-24
75 reads
My Experience on Geeks on Screen with Coffee
Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube and is a different sort of broadcast to be on in good way. Mark Pryce-Maher...
2020-11-24
7 reads
My Experience on Geeks on Screen with Coffee
Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube and is a different sort of broadcast to be on in good way. Mark Pryce-Maher...
2020-11-24
7 reads
My Experience on Geeks on Screen with Coffee
Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube and is a different sort of broadcast to be on in good way. Mark Pryce-Maher...
2020-11-24
13 reads
My Experience on Geeks on Screen with Coffee
Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube and is a different sort of broadcast to be on in good way. Mark Pryce-Maher...
2020-11-24
6 reads
My Experience on Geeks on Screen with Coffee
Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube and is a different sort of broadcast to be on in good way. Mark Pryce-Maher...
2020-11-24
7 reads
Blogs
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
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...
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