2019-07-22
24 reads
Top Modern Data Warehouse questions
Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that...
2019-07-22
977 reads
Importance of Testing
I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...
2019-07-22
27 reads
Current database vs database locks
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading
2019-07-22
307 reads
Last Week Reading (2019-07-21)
Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first...
2019-07-22
25 reads
The Data platform has evolved – so too must the DBA.
This blog post is around the changing landscape of both SQL Server and the people who are our trusted guardians of it – DBAs. If you have been involved...
2019-07-22
295 reads
Moving Databases into Azure SQL Elastic Pools
Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below. As you can see I have a standard elastic pool...
2019-07-22
38 reads
What does the Machine Learning process look like?
This is the second article in the Machine Learning area. I have explained a bit more about the steps the Machine Learning process is built of. You will be...
2019-07-21
307 reads
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract, Transform and Load) Cosmos DB container changes to a SQL Server database. Note that this...
2019-07-21
160 reads
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract, Transform and Load) Cosmos DB container changes to a SQL Server database. Note that this...
2019-07-21
2,875 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