Don’t Underestimate the Importance of Good Co-workers
It is important to have people that do good work and are good to work with.
2017-10-17
96 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
2017-09-05
318 reads
What do you do when you make a mistake?
We all make mistakes, what you do next is what is important.
2017-07-13
75 reads
How do you go about team building?
Team building isn't easy, but important for people to work together well.
2017-07-11
69 reads
What do you do when you have a repetitive task to do?
When faced with repetitive tasks how do you go about doing them in a focused timely manner?
2017-05-11
158 reads
2017-04-28
840 reads
How do you come up with creative ideas?
It takes a creative mind to come up with new ideas. So how do you do it?
2017-04-21
114 reads
How do you define employee satisfaction?
This article explores aspects of a job that help one feel satisfied at work.
2017-04-10
100 reads
How do you go about making a big decision?
This article explores the author's way of making big decisions.
2017-04-04
74 reads
2017-01-05
88 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