2015-09-18
7 reads
2015-09-18
19 reads
Universal SQL Installations Framework (Script review and Demo)
on 19th sep 10.00 am pst, i will be speaking on “universal sql installations framework” @ sqlsaturday, san diego!!, if you...
2015-09-18
685 reads
Recommendations, Endorsements, and More on the 2015 PASS Election
We have four good candidates this year, of which two are incumbents. I was asked by Argenis and Tim to...
2015-09-17
632 reads
Getting data into Azure Blob Storage
If you have on-prem data and want to copy it to Azure Blob Storage in the cloud, what are all...
2015-09-17
1,135 reads
PASS Election Questions Answered 2
Today I am going to continue with my PASS Election Questions and Answers series. Here is where you can find...
2015-09-17
618 reads
Data Types in Extended Events
Today I get to talk about data types within Extended Events. This also means, I hope to be able to bring a little more clarity to the topic.
Related Posts:
Implicit...
2015-09-17
13 reads
Data Types in Extended Events
Today I get to talk about data types within Extended Events. This also means, I hope to be able to...
2015-09-17
637 reads
Reblog: The Magic Alt Button
SQLKover update: I love this trick! I use it daily, no kidding (except in weekends). Want to see it in live...
2015-09-17
650 reads
Voting in the PASS Election 2015
Another year, another set of elections. It’s that time where those who care about their industry and the future of...
2015-09-17
652 reads
Blogs
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, which is...
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