100 Blog Posts Milestone
Good morning dear reader, Long time no talk. It has been a jam-packed and chaotic first half of 2023 for my family and me. The first quarter of the...
2023-07-25
56 reads
Blog Posts
Test Restore Your SQL Server Databases
Pain Point: Something bad happened and you need to restore a SQL Server database. Pain Point you didn’t know you had: The backup files are all corrupt due a...
2023-07-25
308 reads
A Security Change with SQL Compare 15
Actually, this is a change for many products and software that connects to SQL Server. Updated drivers require us to now decide to trust the server certificate. I opened...
2023-07-24
133 reads
Early Bird Pricing for the Data Community Summit Ends Jul 26
The early bird pricing for the PASS Data Community Summit ends this week, on Jul 26. After that, there is a bump, so let you boss know this is...
2023-07-24
35 reads
Microsoft Fabric
What will be much easier with Microsoft Fabric?
Microsoft Fabric is built on a foundation of Software as a Service (SaaS), which takes simplicity and integration to a whole new...
2023-07-24 (first published: 2023-07-11)
401 reads
Wait a minute, CLUSTERED COLUMNSTORE indexes are not ordered?
Just to reiterate what's in the title of this post, what I mean is that the CLUSTERED COLUMNSTORE indexes are not ordered, while NONCLUSTERED COLUMNSTORE created indexes are on...
2023-07-24 (first published: 2023-07-05)
539 reads
..And The New Adventure Has Begun
I am so happy to announce that I have joined the team at Fortified Data. I have just completed my first week (well, four days) and I feel like...
2023-07-23
40 reads
SQLSat Baton Rouge 2023!
Looking forward to #jambalaya at #SQLSatBR on July 29! Register today: sqlsatbr.comI hope to see as many people as possible that weekend, I'll be there at the Friday night...
2023-07-22 (first published: 2023-07-21)
32 reads
A New Word: Ozurie
Ozurie – feeling torn between the life you want and the life you have. I think many people feel ozurie often. I certainly had a lot of this in...
2023-07-21
386 reads
Notes from SQLSaturday South Florida 2023
Quick notes on the event this year: Overall a good event and now I have a few months until SQLSaturday in Orlando in October.
2023-07-21 (first published: 2023-07-06)
164 reads
Blogs
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...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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