Retiring of the MCM Certifications
The MCM is dead. Long live the MCM.
The small, exclusive club of SQL Server Microsoft Certified Masters is going to...
2013-08-31
4,247 reads
A Discussion of SQL Server-Related Topics
It’s the small things that count
Sometimes it’s the small things that count.
I just noticed two small enhancements to SQL Server 2014's BOL, and I can...
2013-08-14
1,534 reads
T-SQL Tuesday #43 – Plan Operators
This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master this past December (congrats!)....
2013-06-14 (first published: 2013-06-11)
2,168 reads
Getting the lowdown on 18456 errors
If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...
2013-04-30 (first published: 2013-04-18)
2,547 reads
The Bucket List – Item #1 is (finally) finished
We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the...
2013-04-16
745 reads
T-SQL Tuesday #41 – Presenting and Loving it!
It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation...
2013-04-09
598 reads
A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)
Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series...
2013-02-28
2,050 reads
A Month of PowerShell – Day 27 (Scripting SQL Objects)
Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-11 (first published: 2013-02-27)
3,479 reads
A Month of PowerShell – Day 26 (Changing Login Passwords)
Welcome to Day 26 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-26
1,305 reads
A Month of PowerShell – Day 25 (Integrity Checks)
Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-07 (first published: 2013-02-25)
2,311 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
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