Becoming Kristyna Ferris <3
Hey folks, fun personal post today. A few weeks ago, I got married! My amazing new husband is Kyle Ferris, and I will be changing my name to Kristyna...
2023-12-07
43 reads
Hey folks, fun personal post today. A few weeks ago, I got married! My amazing new husband is Kyle Ferris, and I will be changing my name to Kristyna...
2023-12-07
43 reads
Today, we’re unpacking a real-world tech drama that unfolded in Singapore, offering a stark reminder about the vital role of Disaster Recovery (DR) planning and the often overlooked, yet...
2023-12-06 (first published: 2023-11-21)
430 reads
I’ve been building lakehouses using Databricks Unity catalog for a couple of clients. Overall, I like the technology, but there are a few things to get used to. This...
2023-12-06 (first published: 2023-11-22)
280 reads
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure I’d spend the time. Someone then posted a link to the TryHackMe advent calendar. I...
2023-12-06
23 reads
I saw an article on this and realized I had no idea how to do this, so I decided to practice a bit. I don’t work with PoSh arrays...
2023-12-05 (first published: 2023-12-04)
176 reads
2023-12-04 (first published: 2023-11-20)
924 reads
Initially, I thought I would have to use sqlcmd because I’m on a Mac and don’t have SSMS. It turns out Azure Data Studio has a nifty way to...
2023-12-04 (first published: 2023-11-20)
599 reads
In this blog post I wrote a tip about fixing the PostgreSQL backup failure issue. The error was directing about the permission issue.
The post PostgreSQL Backup Failure appeared first...
2023-12-04
1,300 reads
nighthawk – n. a recurring thought that only seems to strike you late at night – an overdue task, a nagging guilt, a looming future – which you sometimes...
2023-12-01
86 reads
Note: I found this sitting in my Medium draft. This was a cross-post from my old productivity blog that got lost in oblivion. Productivity is never an accident. It...
2023-12-01 (first published: 2023-11-17)
261 reads
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By way of background, a while back I did video called “My New Favourite...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
WA:08218154393 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
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