This technical blog is hardly the ideal, but I'll use this space here to summarize some of the guidance that my colleague Randolph West and I presented at a...
2023-11-13 (first published: 2023-10-27)
386 reads
As PASS Summit approaches this week, I’m re-reviewing my evaluations from SQL Saturday Boston and I’d like to give feedback about feedback.
Why Feedback? Both speakers and event organizers depend...
2023-11-12
14 reads
heartspur – n. an unexpected surge of emotion in response to a seemingly innocuous trigger – the distinctive squeal of a rusty fence, a key change in an old...
2023-11-10
22 reads
A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going...
2023-11-10
30 reads
There was an update to Flyway Desktop which lets you see the type of database your project is associated with, and this post shows how to get this in...
2023-11-10
105 reads
Games Night is back at the Summit, this time on Wednesday night in a large space for 200 people plus to enjoy some fun with friends and colleagues. This...
2023-11-10 (first published: 2023-11-02)
172 reads
Appreciate everyone who has reached out asking if I would be attending the PASS Data Summit out in Seattle this year. Yes, I will be, and I am looking...
2023-11-10
55 reads
All week, my phone has been reminding me (via photo memories) of the amazing experience I had at PASS Summit 2017. This can mean only one thing - PASS...
2023-11-10 (first published: 2023-11-03)
116 reads
Edwin Sarmiento has a great First Timer Guide for the PASS Data Community Summit, which is updated for 2023. He’s been compiling this since 2016, and it’s worth reading....
2023-11-09
80 reads
What are you most concerned about in your database platforms? Please pick from the list below, and expand on your choice in the comments if you like: Thanks...
2023-11-08 (first published: 2023-10-25)
231 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...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
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