How do you deal with disappointment?
Disappointment is hard, but you get to choose how you react to it.
2018-05-14
119 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
SQL Server Authenticated Users, why are we still using them?
AD Authentication in SQL Server has been around for a long time, so why do we still use SQL Authentication?
2018-03-30
425 reads
2018-02-01
92 reads
Is the old stuff worth learning?
Often we are encouraged to learn the latest things, but sometimes the old stuff is worth knowing too.
2017-12-26
89 reads
2017-12-18
67 reads
2017-12-11
87 reads
Holiday parties: Do you love them or hate them?
It is getting to be that time of year. Holiday parties are you for them or against
2017-11-14
79 reads
Introverted vs Extroverted
A lot of us are introverted, so is there anything that can be done about it?
2017-11-09
122 reads
2017-11-01
99 reads
How Far are You Willing To Go To Get Something?
There are important things in life and in our career, how far are you willing to go to get them?
2017-10-30
119 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