Persisting SQL Server Data in Docker Containers – Part 3
In the first two posts in this series we discussed the need for data persistency in containers then we discussed where the data actually lives on our systems. Now...
2019-09-01
11 reads
Blog Posts
Persisting SQL Server Data in Docker Containers – Part 3
In the first two posts in this series we discussed the need for data persistency in containers then we discussed where the data actually lives on our systems. Now...
2019-09-01
194 reads
September on the Road
I am so excited for the next three weeks. This is a trip that has been in the planning for nearly 2 years. I have always loved travelling and...
2019-09-01
21 reads
The Journey to SQL Server 2019 – where does your own journey start?
[read this post on Mr. Fox SQL blog] A couple of weeks back I presented the keynote at SQL Server Saturday Sydney, which was an absolute blast. It was...
2019-08-31
16 reads
The Journey to SQL Server 2019 – where does your own journey start?
[read this post on Mr. Fox SQL blog] A couple of weeks back I presented the keynote at SQL Server Saturday Sydney, which was an absolute blast. It was...
2019-08-31
64 reads
Actual Kubernetes
This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). I completed the first 3 sections (Days...
2019-08-30 (first published: 2019-08-19)
392 reads
Adding SQL Change Automation to Jenkins for Database CI
In a previous post, I explained how to get Jenkins running in a container for your local CI work. In this one, I’ll expand on the process for database...
2019-08-30 (first published: 2019-08-21)
522 reads
Find and fix that troublesome Windows Power setting
For the most part, the default configurations for SQL Server are pretty good. Yeah, there are a few you should definitely change (like say, the ones involving parallelism), but...
2019-08-30
14 reads
Find and fix that troublesome Windows Power setting
For the most part, the default configurations for SQL Server are pretty good. Yeah, there are a few you should definitely change (like say, the ones involving parallelism), but...
2019-08-30
8 reads
SQL in the City Streamed Next Week
I’m off to the UK this weekend, for a few commitments next week. One of those is SQL in the City Streamed, which is taking place on Wednesday September...
2019-08-30
22 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