Last week I wrote a blog post about Decoding Helm Secrets. The post goes through deploying a Helm Chart to Kubernetes and then running the following to decode the...
2020-08-31 (first published: 2020-08-18)
240 reads
If you are like me, you inherited variously configured SQL Servers when you took over as the DBA for your company. After almost two years, I have gotten all...
2020-08-31 (first published: 2020-08-18)
557 reads
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-08-31
21 reads
Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place. Lucky for me I discovered the other day that...
2020-08-28
21 reads
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-08-28
44 reads
I’ll be speaking at the PASS Summit in 2020, and I have some things to prepare for that. I get a conference admission for the event and access for...
2020-08-28
69 reads
Do you ever get the Christmas card that features a beautiful picture of a family on the front, and a letter catching you up on their year on the...
2020-08-28 (first published: 2020-08-18)
230 reads
I’ve spent my whole career working with databases which is over 20 years and counting. I work for a great company and I love what I do. The job...
2020-08-28 (first published: 2020-08-17)
203 reads
I was going through a few of the Redgate products with a customer recently and they wanted to perform some validation of the build and release process with SQL...
2020-08-27 (first published: 2020-08-19)
531 reads
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading
2020-08-27
188 reads
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
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