Shutting Down Coping Tips
It’s been nearly 3 years of Daily Coping Tips here at the Voice of the DBA. I started these when the pandemic hit and the world shut down. I’ve...
2023-03-01
38 reads
Blog Posts
Writing a Hello World Go Container Web Application
In this blog post, I will show you how to build a hello world container-based web application in the go programming language. The reason I want to do this...
2023-03-01 (first published: 2023-02-19)
208 reads
Daily Coping 28 Feb 2023
Today’s coping tip is to thank three people you feel grateful to and tell them why. This is something I tend to do privately, thanking people who’ve impacted my...
2023-02-28
15 reads
A Corporate Wellness Day
Today is the corporate Wellness Day at Redgate. It’s a day off for almost everyone in the company, unless they have something that can’t get moved. A few support...
2023-02-27
79 reads
Checking the Microsoft Container Registry for new SQL Server images
A while back I wrote a post on how to retrieve the SQL Server images in the Microsoft Container Registry (MCR). It’s pretty simple to check the MCR but...
2023-02-27 (first published: 2023-02-17)
417 reads
Daily Coping 27 Feb 2023
Today’s coping tip is to tell a loved one about the strengths you see in them. For one of my kids, I’m letting them know that I see: responsibility...
2023-02-27
22 reads
Out of Your SSMS World, Jupyter Notebooks in Azure Data Studio – Louisville Data Technology Group, Feb 2023
It was a lot of fun to speak at the Louisville Data Technology Group in February. Sheila and I presented on Jupyter notebooks in Azure Data Studio. The session...
2023-02-27 (first published: 2023-02-14)
486 reads
Preparing for TOGAF Certification
The Open Group Architecture Framework (TOGAF) is one of the most well-known architectural frameworks in our industry. TOGAF is a framework that helps organizations implement enterprise architecture as a...
2023-02-27
127 reads
SQL Server 2022: The Future of Data Management
SQL Server 2022 and its enhancement … Continue reading SQL Server 2022: The Future of Data Management →
2023-02-27
359 reads
Tales From The Field Weekly Wrap Up for the Week of 02-20-2023
Hello Dear Reader! We had a beautiful weekend here in Florida. Spring is in the air, mainly because the temperature is ranging between 85 to 90 degrees Fahrenheit. This...
2023-02-27
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...
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...
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