DataTune 2024 was a huge success! Thank you so much to the organizers who spent countless months planning and making this an incredible conference! It was so great to...
2024-03-18 (first published: 2024-03-11)
124 reads
I focus most of my blog posts on the data platform and how companies can make better business decisions using structured data (think SQL tables), but I’m seeing more...
2024-03-18 (first published: 2024-03-11)
767 reads
malotype– n. a certain person who embodies all the things you like the least about yourself – a seeming caricature of your worst tendencies – which leave you feeling...
2024-03-15
24 reads
I had a customer ask about undoing changes made by developers, similar to what SQL Source Control does. I had to do a little research to show how to...
2024-03-15 (first published: 2024-03-08)
208 reads
I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...
2024-03-15 (first published: 2024-03-08)
312 reads
Today is the first Redgate Summit of 2024 in Atlanta. I flew to town yesterday, There is a packed schedule, which is mostly repeated at our other events coming...
2024-03-13
18 reads
(2024-Mar-08) Software installation typically involves several steps. After accepting the license agreement, you may have an express option to streamline the installation process by accepting all defaults, including the installation...
2024-03-13 (first published: 2024-03-08)
579 reads
Using data effectively, leaders can make better decisions, drive innovation, and inspire trust. What is leadership through data? Leadership that utilizes data is the ability to use data as...
2024-03-13 (first published: 2024-03-07)
203 reads
Had an absolutely amazing time at SQLBits this year! It was lovely to see all my data friends again and had the opportunity to introduce my husband to everyone...
2024-03-12
29 reads
I have been a proponent of subsetting databases in dev/test for a long time. It took awhile, but as part of the Test Data Manager that Redgate launched at...
2024-03-11 (first published: 2024-02-28)
329 reads
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
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