Goodbye SQL Server, Hello FileMaker…
The last weeks were very time consuming for me, because I had to make a very tough decision: staying independent...
2014-04-01
909 reads
New Undocumented Feature in SQL Server 2014
Today is the eagerly anticipated launch of SQL Server 2014, I have downloaded and installed a copy of the RTM...
2014-04-01
1,100 reads
Last Day in the UK
The driver behind the move
After over two and a half years at my current employers I am afraid to say...
2014-04-01
621 reads
AlwaysOn Availability Groups Setting
Many of us are planning to move to SQL Server 2012 in the coming year, and one of the feature...
2014-04-01
346 reads
Oracle, MySQL, and MongoDB Come to SQLServerCentral
We’re in for a name change. As of May 1, we’ll be welcoming the Oracle and MySQL communities to SQLServerCentral....
2014-04-01
985 reads
Cumulative Update #16 for SQL Server 2008 SP3
Here’s a link for the download for the CU #16 for SQL2008 SP3 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx. The post also includes all the previous...
2014-03-31
1,280 reads
The Primary Filegroup Cannot be Backed Up as a File Backup
File Group backups are great when working with very large databases (VLDB’s) that have been partitioned. Typically when I come...
2014-03-31
2,751 reads
Send SMS from SQL Server
We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...
2014-03-31
1,969 reads
Last Weeks Top “Reading” Links #77
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-03-31
1,954 reads
Follow Up on The Unusable User–Question Of The Day
I posted about one of my questions of the day called The Unusable User last week and wanted to return...
2014-03-31
1,205 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