Azure Active Directory is Microsoft Azure’s identity and access management providing authentication and authorization mechanism for internal and external applications in Azure ecosystem. With AD(more...)
The post Snowflake Integration to...
2022-03-10
71 reads
I have been in Azure DevOps pipelines a lot recently, helping clients set up automated releases. Many of my clients are not in a place where automated build and...
2022-03-09 (first published: 2022-02-22)
392 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-09
20 reads
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-09
63 reads
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we ... Continue reading
2022-03-09 (first published: 2022-02-22)
367 reads
At my new day job, one of the things we want to do is migrate a portion of a really large Git repository (over 20GB) which I’ll call LargeRepo,...
2022-03-09
49 reads
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a ... Continue reading
2022-03-08
27 reads
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a ... Continue reading
2022-03-08
6 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-08
19 reads
G’day, This months T-SQL Tuesday (March 2022) invite is brought to you by Rie Merrit – @IrishSQL Rie has asked us to write about “Advice on running a user...
2022-03-08
19 reads
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
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...
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