Announcing a New Book on SQL from 3Cloud Authors
I am proud to announce the launch of a new book, centered around the importance of SQL, authored by six consultants from 3Cloud. Our new book is called “SQL...
2023-06-07
31 reads
Blog Posts
Automating Database Maintenance on Azure SQL
Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to crashes...
2023-06-07 (first published: 2023-05-08)
816 reads
Book Review: SQL Query Design Patterns and Best Practices
This book will provide you with a good foundation upon which a consistent convention for practicing your day-to-day operations can have a solid footing in your database discipline, with...
2023-06-07 (first published: 2023-05-20)
574 reads
Identify the (Top 20) most expensive queries across your SQL Server using Query Store
Script to identify the most expensive queries on your database server using the Query Store DMVs. This allows you to look at data from a specific time frame, as...
2023-06-07
331 reads
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always Encrypted and create an encrypted column. As with my last post we're looking at the...
2023-06-06
35 reads
Analyzing Azure Cosmos DB Data with Azure Synapse Link – YouTube Live Stream
At Tuesday 6th of June 2023, I’m giving an online version of my session “Analyzing Azure Cosmos DB Data with Azure Synapse Link” (which I presented at Techorama). It’s...
2023-06-05
22 reads
Backup Encryption Performance
Unlike TDE, there is some extra CPU overhead when you take an encrypted backup as the data has to be encrypted before being written to disk – whereas with...
2023-06-05 (first published: 2023-05-22)
275 reads
SSAS Tabular: “SortByColumn property set to invalid column ID”
Recently I was doing a cleanup of one model, and I used Best Practice Analyzer (BPA) in Tabular Editor as a helper. Later, I realized I forgot to set...
2023-06-05 (first published: 2023-05-22)
473 reads
A New Word: Jouska
jouska – a hypothetical conversation that you compulsively play out in your head – a crisp analysis, a devastating comeback, a cathartic heart-to-heart – which serves as a kind...
2023-06-02
961 reads
PGSQL Phriday #009: On Rollback
The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty simple, database change management. Now, I may have, once or twice, spoken about database change...
2023-06-02
33 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