Azure Advisor
Azure offers a lot of value-added services included with the price of what you pay . One of the things really,...
2019-01-30
300 reads
Azure Kubernetes Service Error – LoadBalancer type service external IP stays pending
Last week I was working on my Azure Kubernetes Service cluster when I ran into a rather odd issue. I’d...
2019-01-30
366 reads
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. There is insufficient system memory in resource pool ‘internal’ to run this query.
Today my colleague had issue that SQL server...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-01-30
1,663 reads
Backing Up and Restoring Your On-Premise Databases To and From the Cloud
I’ve been meaning to start a series of posts on “Dipping your toes into the cloud” for a while now,...
2019-01-30
311 reads
Midlands PASS Meeting – February 5, 2019
Midlands PASS (Columbia, SC) will be hosting Shannon Lowder on February 5, 2019, from 5:30-8:00 PM. He will be speaking...
2019-01-29
150 reads
What a Software Evangelist Does – and Where the Job is Going (Dear SQL DBA Episode 67)
I’ve been working as an Evangelist at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software...
2019-01-29
33 reads
Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf). Most...
2019-01-29
435 reads
Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to...
2019-01-29
1,078 reads
Opening a Twitch Channel, Data Wisdom
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on...
2019-01-29
9 reads
Opening a Twitch Channel, Data Wisdom
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here....
2019-01-29
187 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
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