My session on Adaptive Query Processing has been finding significant interest in Data Platform events 🙂 Delivered 2 webinars for Data Platform Geeks community, one of them at American...
2018-03-18
36 reads
My session on Adaptive Query Processing has been finding significant interest in Data Platform events 🙂 Delivered 2 webinars for Data...
2018-03-18
764 reads
Someone recently told me that they don’t need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don’t...
2018-03-16 (first published: 2018-03-06)
2,850 reads
In this post and video you will learn how to identify the owner and then change the owner of a...
2018-03-16 (first published: 2018-03-06)
22,003 reads
In this module you will learn how to use the Count Down Timer. The Count Down Timer is a very...
2018-03-16
399 reads
In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time....
2018-03-16
814 reads
This blog post is a copy of a post I wrote for SQL Masters Consulting as part of T-SQL Tuesday....
2018-03-15
264 reads
As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data...
2018-03-15
298 reads
Not long ago, I wrote a rather long article about a new-ish feature within SQL Server Management Studio (SSMS) that...
2018-03-15 (first published: 2018-03-05)
1,866 reads
Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...
2018-03-15 (first published: 2018-03-05)
2,409 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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