The Gartner Magic Quadrant for 2019, announced earlier this month, names Microsoft the leader in Analytics and Business Intelligence Platforms. Microsoft also coincidentally announced the public preview release of...
2019-02-23
30 reads
The Gartner Magic Quadrant for 2019, announced earlier this month, names Microsoft the leader in Analytics and Business Intelligence Platforms....
2019-03-12 (first published: 2019-02-23)
4,355 reads
This blog post explains how to get into SQL Server if you have lost your sa password or you have...
2019-03-11 (first published: 2019-02-23)
4,554 reads
A couple of weeks ago, I blogged about boot diagnostics and how they can help you troubleshoot issues when virtual...
2019-02-22
234 reads
Happy Friday! We made it. Here’s something I came across while testing optimize for ad hoc for this week’s blog...
2019-03-11 (first published: 2019-02-22)
2,151 reads
A while back Microsoft moved all their SQL images to their new registry mcr.microsoft.com which means that we can no...
2019-02-22
186 reads
As Chief Cloud Architect with Adatis Consulting, Simon Whiteley has been working with the Microsoft BI Stack for a decade,...
2019-02-22
159 reads
Let’s take a break from our SQL Server 2017 Reporting Services Basics Series and jump to Azure Data Factory (v2)....
2019-02-21
1,934 reads
The series is alive! It’s been a while since I last talked about memory grants. Don’t worry, I still care...
2019-02-21
413 reads
As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without...
2019-02-21
190 reads
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
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