Life Without a Watch
A few years ago I got an amazing watch as a ten year gift from Redgate: a Garmin Forerunner 645. Since then, I’ve used this regularly to track my...
2020-06-15
45 reads
Blog Posts
When Your Azure Data Catalog App Won’t Connect
This year I created a new presentation for introducing Azure Data Catalog. I love this product and think it has so much potential and everyone should be using it! ...
2020-06-15 (first published: 2020-05-26)
216 reads
Daily Coping 12 Jun 2020
I’ve 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...
2020-06-12
33 reads
Replicate permissions to new Login/User with dbatools
Continuing to share tips and tricks using dbatools like the Refresh databases that belongs to availability group using dbatools posted a few days ago, today I will share a...
2020-06-12 (first published: 2020-05-28)
2,962 reads
Social: Stepping Back and Embracing a Difference of Thought
I do think that we want to have diversity, for a number of reasons, but this means in many cases, embracing differences. My editorial today is on Gatekeepers, which...
2020-06-12
22 reads
What I learned from “The boy who cried wolf”
I was thinking about the story The boy who cried wolf earlier today and realized that it has some lessons ... Continue reading
2020-06-12 (first published: 2020-05-28)
483 reads
Daily Coping 11 June 2020
I’ve 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...
2020-06-11
26 reads
More Azure Blob Storage enhancements
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob storage. Now there are more new features for blog storage that I will talk about....
2020-06-11 (first published: 2020-05-25)
277 reads
My Thoughts on PASS Virtual Summit – An Editorial
On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server...
2020-06-11
4 reads
SQL Server principals – Logins & How does Login Authentication work in SQL Server?
[MSSQLFUN & Decode ITeS becomes a family of 1600 individuals across the globe. Please join us on Facebook & YouTube.] SQL Server Level Principals SQL Server level principals are the only...
2020-06-11
39 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...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
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