A new presentation on Auditing your databases
I’m giving a presentation at the PASS Data Community Summit 2021 being put on by Redgate! It’s going to be ... Continue reading
2021-08-19
34 reads
Blog Posts
Daily Coping 19 Aug 2021
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...
2021-08-19
14 reads
Daily Coping 18 Aug 2021
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...
2021-08-18
26 reads
Finding Failed Job Steps
Kendra’s query was a good starting point, and I used most of it in the first CTE shown below. This query basically looks at msdb.dbo.sysjobhistory and msdb.dbo.sysjobactivity, joining them...
2021-08-18
395 reads
Scaling down in the cloud
I may be completely off base here, but I’ve noticed a correlation between folks who use Amazon Web Services and their understanding that once you scale up a service...
2021-08-18
99 reads
SQL Homework – August 2021 – Security Standards
A few years back (wow time flies) I had you Work with Security. It’s been a while so if you ... Continue reading
2021-08-18 (first published: 2021-08-03)
319 reads
Updating SQL Server container memory limits on the fly
When running multiple SQL Server containers on a Docker host we should always be setting CPU and Memory limits for each container (see the flags for memory and cpus...
2021-08-18 (first published: 2021-08-06)
333 reads
For #JohnsDad
Last week, on Wednesday August 11, 2021 at approximately 3:45PM Eastern, my Father left this world. Much too early. Covid took my Father from me, my family, and his...
2021-08-17
17 reads
Pure Storage Links
SQL Server Pure Storage SQL Server Platform Guides Pure Storage SQL Server Best Practices Pure Storage SQL Server Scripts on GitHub Pure Storage ActiveCluster with SQL Server Azure...
2021-08-17
47 reads
Become a Beginner at Data Science with the WIT
I’m a beginner in data science. I know a lot of general things about the field, but I’m really a beginner in most ways. This Friday, 20 Aug 2021,...
2021-08-16
36 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...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
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...
ALAMAT KONTAK BCA KCU BANDUNG Telp:08218154393
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
ALAMAT KONTAK BCA KCP Batakan Telp,Cs:08218154393
WA:08218154393 Jalan Marsma R. Iswahyudi 05, Rukun Tetangga No.20, Sepinggan, Kecamatan Balikpapan Selatan, Kota...
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