TDE: Database Backups and High Availability
Database backups continue to work without change when you have TDE enabled. The only difference is that the backups contain encrypted data that cannot be read without the certificate...
2023-05-15
45 reads
Blog Posts
Techorama Slides – Analyze Cosmos DB Data with Synapse Link
I’ve uploaded the slides for my session at Techorama to Github.
The post Techorama Slides – Analyze Cosmos DB Data with Synapse Link first appeared on Under the kover of...
2023-05-15
23 reads
The first two chapters of my book are available!
As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...
2023-05-15 (first published: 2023-05-03)
592 reads
A New Word: Vemödalen
vemoödalen – the fear that originality is no longer possible I used to worry about this, and often I thought that I’d run out of original things to do....
2023-05-12
102 reads
Experiments with GitHub CoPilot
There has been a lot of attention given to ChatGPT and AI over the last month or two. I’ve tried a few things with the public interface at Open.ai....
2023-05-12 (first published: 2023-05-03)
622 reads
New Stars of Data – SQL Bad Practices caught in the Wild
At the 12th of May 2023, a new edition of New Stars of Data takes place. If you’re not familiar with the concept, it’s a free virtual event focusing...
2023-05-12 (first published: 2023-05-11)
55 reads
Power BI Cruise Recap – Deep Data Dives
Thank you so much to those of you who were able to attend this three-hour, C# packed session! The Power BI Cruise was an incredible conference, and I cannot...
2023-05-12 (first published: 2023-05-02)
309 reads
The Importance of SQL Server Performance Tuning in the Cloud
Make sure your cloud SQL Server databases are optimized and achieve significant cost savings.
2023-05-12
108 reads
Implementing Temporal Tables Where You Have Existing Data
An in-depth look at how you convert an existing table with data to a system versioned table that will maintain a history of changes.
2023-05-11
133 reads
Monitoring Deadlocks in Azure SQL Managed Instance
Hello Dear Reader! My lastest blog on our Azure FastTrack blog for Microsoft is live, Monitoring Deadlocks in Azure SQL Managed Instance. Here's a little from the blog:To paraphrase Annie,...
2023-05-10 (first published: 2023-05-02)
443 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...
ALAMAT KONTAK BCA KCU PONTIANAK Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT KONTAK BCA KCU BALIKPAPAN Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
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