Decoding Helm Secrets
Helm is a great tool for deploying applications to Kubernetes. We can bundle up all our yaml files for deployments, services etc. and deploy them to a cluster with...
2020-08-19 (first published: 2020-08-10)
477 reads
Blog Posts
Finally, PASS is a proper association now
For the longest time PASS was known as the Professional Association for SQL Server, and made all of its money from a single event each year, the PASS Summit. If...
2020-08-19
41 reads
My First Hand-built AWS CodePipeline
I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already...
2020-08-19 (first published: 2020-08-10)
323 reads
Take off with the new Flight Simulator
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
123 reads
Take off with the new Flight Simulator
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
21 reads
Creating a SQL Clone Agent and a First Image
In a previous post, I set up the SQL Clone server. This is really a metadata store and web front end, but it does no real work. The Agent...
2020-08-18 (first published: 2020-08-06)
229 reads
Daily Coping 18 Aug 2020
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...
2020-08-18
11 reads
Thinking About the 2021 PASS Summit
I know that we don’t yet know how the 2020 Summit will turn out, but I’ll make some guesses: A lot of people like it for the lower cost,...
2020-08-18 (first published: 2020-08-05)
741 reads
Availability Group issues fixed with Alerts
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
The post Availability Group issues fixed...
2020-08-17 (first published: 2020-08-06)
920 reads
Azure Data Engineer Certification Preparation
This week i got my new Azure Certification badge (Azure Data Engineer) and today i am writing this article to share all of the resources i collected it during...
2020-08-17
56 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