Using Microsoft Azure – Twitter Analysis
Time for a fun post, I have been working on a mini-project using technology from Microsoft Azure to hook into...
2018-09-27
416 reads
Getting error “unable to parse remote unpack status” when attempting to push to Azure Repo in Azure DevOps
This blog post is about a situation where I went to push my latest local changes to my git repository...
2018-09-27
822 reads
#Ignite2018 Session: Ensure application availability with cloud-based disaster recovery, Azure Site Recovery #SAP #BusinessContinuity
I’m a big fan of Azure Site Recovery for Disaster Recovery and was glad to attend the Ignite session today...
2018-09-26
70 reads
CCI Bulk Load Pitfalls 2 – Parametrization of Dynamic SQL
Intro
In the last blog I showed how important statistics are for CCI bulk load even on small tables. This time...
2018-09-26
157 reads
Azure Outage Post-Mortem Part 3
My previous blog posts, Azure Outage Post-Mortem – Part 1 and Azure Outage Post-Mortem Part 2,made some assumptions based upon limited information coming from...
2018-09-26
82 reads
Book Review – Learning Pentaho Data Integration 8 CE
Yes, you’re reading that right. A book not about the Microsoft BI stack. At a project, Pentaho Data Integration (PDI)...
2018-09-26
483 reads
Best Hidden Feature in SQL Server 2019
With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet. Most likely if you are following along you have heard of...
2018-09-26
85 reads
Best Hidden Feature in SQL Server 2019
With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet. Most likely...
2018-09-26
599 reads
Cloud ETL for the Modern Enterprise Workshop
We are introducing a new workshop focused on Cloud ETL. ETL, or Extract, Transfer and Load, is nothing new and...
2018-09-26
348 reads
Azure means hybrid now
On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to...
2018-09-26
370 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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