When a SQL UPDATE Statement DELETES Rows
Watch this week's video on YouTube
At first I wasn't going to write this post. I thought it would be too simple.
Then I watched two experienced SQL developers go through...
2019-11-26
21 reads
When a SQL UPDATE Statement DELETES Rows
Watch this week's video on YouTube
At first I wasn't going to write this post. I thought it would be too simple.
Then I watched two experienced SQL developers go through...
2019-11-26
28 reads
When a SQL UPDATE Statement DELETES Rows
Watch this week’s episode on YouTube. At first I wasn’t going to write this post. I thought it would be too simple. Then I watched two experienced SQL developers...
2019-12-09 (first published: 2019-11-26)
2,120 reads
Business Mum of the Year Finalist 2019
Here at gethynellis.com we are proud to announce that our Operations Director Sabrina Ellis is a finalist for the Business Mum of the Year award, taking place on Wednesday...
2019-11-26
29 reads
Business Mum of the Year Finalist 2019
Here at gethynellis.com we are proud to announce that our Operations Director Sabrina Ellis is a finalist for the Business Mum of the Year award, taking place on Wednesday...
2019-11-26
55 reads
How to Fix SQL Database Logical Consistency Based I/O Error
There can be several reasons that cause Database Logical Consistency based I/O error:
Unexpected system shutdown/crash or forced shutdown
SQL administrator tries to query or modify SQL data
In both the circumstances,...
2019-11-26
35,122 reads
Containers: Upgrading SQL Server from 2017 to 2019 RTM
Throughout the pre-release of SQL Server 2019, I was demoing an effectively instant, and magical, container upgrade from 2017 to 2019. However, when I finally downloaded the release bits...
2019-12-05 (first published: 2019-11-25)
333 reads
#PowershellBasics: Working with arrays
I mentioned arrays in a previous post so I figured I should talk about what they are and how to ... Continue reading
2019-12-06 (first published: 2019-11-25)
467 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-11-25
17 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-11-25
18 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers