What do you do when you inherit a mess at work?
I have seen three common responses to database messes. My favorite is nuclear.
2016-12-06
270 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
Do you have DBA syndrome?
Sometimes DBAs become resistant to change. When they lose focus on their full purpose they may have DBA syndrome.
2016-10-05
152 reads
An object lesson about what is really important
A story I heard a long time ago reminds us to choose what is really important.
2016-08-11
120 reads
How do you know when it is time to leave a job?
Today we have a guest editorial from Ben Kubicek as Steve is traveling out of town. I discovered I had stayed at a job about two years too long. Why was that?
2016-07-22
213 reads
An example of how networking netted a new job
Today we have a guest editorial as Steve is away on vacation. You often hear about how important it is to network. This is a story of how my network helped me get a new job.
2016-07-01
95 reads
2016-06-28
1,355 reads
Don’t Miss Out on an Opportunity to Connect
There are people in our lives that we want to connect with, so why don't we?
2016-05-09
106 reads
2016-03-14
109 reads
2015-10-26
1,619 reads
Where should middle tier business logic be stored?
The age old question of where should business logic be stored
2015-10-16
306 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...
Alamat Kantor BCA KCU TANGERANG Telp:0817839777
WhatsApp:0817839777 Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten 15118
Alamat Kantor BCA KCU GARUT Telp:0817839777
WhatsApp:0817839777 Jl. Ciledug No.162, Kota Kulon, Kec. Garut Kota, Kabupaten Garut, Jawa Barat 44112
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