Human and Machine Learning
Machine learning and AI are becoming more and more prevalent, which Steve Jones thinks is good.
2017-02-27
118 reads
Editorials
The Secure Medical Data Challenge
This week Steve looks at the challenges of security for medical data.
2017-02-27
88 reads
The Cloud is Just a Tool
Today Steve Jones argues the cloud is just another tool for us to use. Not required, not ignored, but considered.
2017-02-23
122 reads
Why Object Databases will always be Tomorrow's Technology
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
2017-02-21 (first published: 2009-06-17)
755 reads
Approaching Politics in IT
The news cycle seems to be dominated by discussion of politics. Regardless of where you fall on the political spectrum, the talk of politics is inescapable and is probably going to lead to you being displeased with your fellow man. Luckily, we work in IT, so we can avoid politics. BWA-HA-HA-HA-HA! Politics goes way beyond […]
2017-02-20
130 reads
2017-02-20
117 reads
2017-02-16
116 reads
What Would You Do if Your Company Was Targeted?
Today we have a guest editorial that asks what you might do if you knew a hacker was coming after your organization.
2017-02-15
121 reads
Quality Provides Traction/Velocity
Quality is a driver for productivity. Or so say I. What do you think.
2017-02-14
95 reads
Problems With Database Problems
The GitLab crisis has Steve Jones thinking about two things: competence and care.
2017-02-13
121 reads
Blogs
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...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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