2016-10-07
1,046 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
A Software Warranty
Steve Jones says that developers should take responsibility for the code they deploy, perhaps with a warranty of sorts inside their company.
2016-10-06 (first published: 2012-10-22)
161 reads
2016-10-06
1,040 reads
2016-10-05
1,191 reads
My SQL Prompt GitHub Repo
Last year I published an article on SQLServerCentral from Guarab Vohra on using SQL Prompt with a VCS. I really...
2016-10-04
644 reads
Off Again
It’s another week of travel for me, starting early this morning. This is another crazy trip, and yes, I did...
2016-10-04
402 reads
Questioning the Interviewer
Asking questions in an interview is important, but there can be issues. Steve Jones talks a little about how to approach this.
2016-10-04 (first published: 2012-10-15)
565 reads
2016-10-04
1,086 reads
Coming Attacks
What happens if we can't access the Internet? We should be prepared, at home and work. Steve Jones has a few comments.
2016-10-03
103 reads
Intelligence from Data
This week Steve Jones looks at the idea of using AI and machine learning with your data to develop amazing new insight.
2016-10-03
56 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...
ALAMAT KONTAK BCA KCU BANDUNG Telp:08218154393
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
ALAMAT KONTAK BCA KCP Batakan Telp,Cs:08218154393
WA:08218154393 Jalan Marsma R. Iswahyudi 05, Rukun Tetangga No.20, Sepinggan, Kecamatan Balikpapan Selatan, Kota...
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