Speaking at SQLBits 2020
I’m proud to announce that I will be speaking at SQLBits! I had the absolute pleasure of speaking at SQLBits last year for the first time and saw first hand...
2020-02-08
4 reads
Blog Posts
Speaking at SQLIntersection Orlando 2020
I’m very pleased to announce that I will be speaking at SQL Intersection April 2020! This is my first time speaking at SQL Intersection and I’m very excited to...
2020-02-08
20 reads
Speaking at SQLIntersection Orlando 2020
I’m very pleased to announce that I will be speaking at SQL Intersection April 2020! This is my first time speaking at SQL Intersection and I’m very excited to...
2020-02-08
13 reads
Speaking at SQLIntersection Orlando 2020
I’m very pleased to announce that I will be speaking at SQL Intersection April 2020! This is my first time speaking at SQL Intersection and I’m very excited to...
2020-02-08
6 reads
How Do You Decide When Can Doesn't Mean Should?
An old proverb states, “Fire is a good servant but a bad master.” Put simply, it means that when controlled, fire is a life-sustaining element. We need it for...
2020-02-07
19 reads
New .NET Notebooks are here – PowerShell 7 notebooks are here.
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL kernel where with a little bit of...
2020-02-07
67 reads
SQL Homework – February 2020 – Write a blog post.
Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what ... Continue reading
2020-02-07 (first published: 2020-02-03)
307 reads
Temporarily enable TLS 1.0/1.1? – Be sure you check this keys
There are some actions that we know that will have to be repeated from time to time, but the surprise comes when it’s time to do so and the...
2020-02-07 (first published: 2020-02-04)
4,847 reads
Performance Tuning with Computed Columns
Computed Column can be utilized to optimize the query performance. It can be leveraged, to make the query sargeable, to make proper use of available indexes.
In this article,...
2020-02-06
260 reads
Profiler: Time To Go
I’ve decided that, in fact, it is time to start moving people off the ancient technology, Profiler. Before, I always said, stay where you’re comfortable. However, keeping people comfortable...
2020-02-06 (first published: 2020-02-03)
878 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