Hiring in IT and Relevance of Domain Experience
When choosing to hire someone, do you want experience or freshness? A few thoughts from someone that had to go through this recently.
2024-08-12
1,426 reads
Nitin Bhojwani
2022-08-26 (first published: 2017-08-08)
219 reads
2021-12-10 (first published: 2017-03-30)
258 reads
An Amazing Interview
There are many amazing candidates in IT, but how many can give an amazing interview. I feel I can't, can you?
2021-03-04
309 reads
2020-12-23
287 reads
Versatile or Jack of all trades
Do you consider multi-skills useful; or just one with mastery in it?
2019-01-21
149 reads
Does the Tone matter?
Does the tone of communication matters to you that much that it affects your work in some way?
2018-05-15
114 reads
Guilty of Over-Customising
Am I guilty of over-customising software? Read this and let us know what you think.
2017-06-12
110 reads
Have you ever given up on your brainchild
Have you ever given up on your brainchild? If yes, how did you deal with it?
2017-04-24
116 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...
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