Friday Followup For April 18, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-04-18
446 reads
MDS: A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2014-04-18
1,605 reads
Bringing Power BI Q&A to your Organization Recording and Q&A
I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15...
2014-04-17
975 reads
What is the Microsoft Analytics Platform System (APS)?
Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW). It is not really a new...
2014-04-17
1,331 reads
Why does my Failover Cluster Instance Keep Failing Back and Forth?
A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...
2014-04-25 (first published: 2014-04-17)
8,252 reads
oPASS Tonight! (April 17, 2014)
I’m presenting tonight at oPASS, two presentations worth! If you’re in Orlando I hope you’ll attend, details at http://orlando.sqlpass.org/.
2014-04-17
535 reads
SSMS Auto Recovery
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write...
2014-04-17
843 reads
Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM...
2014-04-24 (first published: 2014-04-16)
1,965 reads
2014-04-16
667 reads
FileTable–Adding a file to a folder
At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy...
2014-04-23 (first published: 2014-04-16)
3,643 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, 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