Speaking at PowerShell Summit 2019
Speaking at PowerShell Summit 2019! I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2019 the conference runs from April 29th 2018 through...
2019-04-29
34 reads
Four Data Integration Design Questions to Ask
We get requests to move data between custom systems regularly, even within systems. I was advising a client on something fairly simple—a collection of tables out of one vendor...
2019-04-29
22 reads
Is Your Availability Group ‘REALLY’ Ready To Failover?
You know what it’s like, you need to fail your AG over but is it safe to fail over? Perhaps you’ve clicked on ‘failover’ for the AG and there’s...
2019-05-09 (first published: 2019-04-29)
867 reads
SQL Server Management Studio 18.0 is available now.
SSMS 18.0 is available for download now.Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL...
2019-04-29
30 reads
SQL Server Management Studio 18.0 is available now.
SSMS 18.0 is available for download now.Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL...
2019-04-29
1,147 reads
What do you get with a Free account in #Azure?
The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this: What ... Continue reading
2019-05-08 (first published: 2019-04-29)
1,247 reads
What is Automation?
Today I got a bit closer to a meaningful definition of automation, as it applies to the software development process. I’ve been turning this concept over in my head...
2019-04-29
26 reads
More Software Quality with DevOps and CD
Tomorrow is the SQL in the City Summit in London. Right now I’m in a Heathrow airport hotel, finalizing some prep for the event. I have to run a...
2019-04-29
19 reads
Azure Data Factory: Extracting array first element
(2019-Apr-28) Full credit goes to Microsoft for the latest efforts updating Azure products with new features and documenting corresponding changes for the end users. Azure Data Factory (ADF) is a great...
2019-05-08 (first published: 2019-04-29)
9,101 reads
Weekly reading #13
#13, #13, #13 – that must be a good week! This firs week of May we call a “long weekend” as we have at least 2 days off! This...
2019-04-29
56 reads
Blogs
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