Making Phone Calls from Azure Event Hub Messages
Recently I did a presentation at our local SQL Server User Group (SSUG) on Managing Streaming Data Pipelines Using Azure Data Services and as such wanted to build out...
2017-05-30
21 reads
Mr. Fox SQL
What Exactly is the “Data Platform” Nowadays?
[read this post on Mr. Fox SQL blog]
A couple of months ago I was presenting at SQL Saturday Melbourne (582) on Azure Cognitive...
2017-04-20 (first published: 2017-04-18)
2,291 reads
What Exactly is the “Data Platform” Nowadays?
[read this post on Mr. Fox SQL blog] A couple of months ago I was presenting at SQL Saturday Melbourne (582) on Azure Cognitive Services and got chatting with some of the...
2017-04-18
17 reads
A Collection of SQL Server Help Scripts
[read this post on Mr. Fox SQL blog]
Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked...
2017-03-13
1,531 reads
A Collection of SQL Server Help Scripts
[read this post on Mr. Fox SQL blog] Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked on or used SQL Server they will likely have...
2017-03-13
22 reads
Azure Cognitive Services Text Analytics – An API Calling Application
[read this post on Mr. Fox SQL blog]
Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in...
2017-02-27 (first published: 2017-02-22)
2,884 reads
Azure Cognitive Services – Text Analytics API Application
[read this post on Mr. Fox SQL blog] [UPDATED 7 JUN 2020 – ADDED NEW TEXT ANALYTICS v3.0 FEATURES!] Just last week we had the fantastic opportunity to present at Microsoft...
2017-02-22
18 reads
SQL Saturday 582 Melbourne (11 Feb 2017) and Ignite 2017 (14-17 Feb 2017)
For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast…
SQL Saturday582 (Sat...
2017-01-17
558 reads
SQL Saturday 582 Melbourne (11 Feb 2017) and Ignite 2017 (14-17 Feb 2017)
For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast… SQL Saturday 582 (Sat 11 Feb 2017). Melbourne. For those looking for...
2017-01-17
9 reads
Azure Cognitive Services API’s with SQL Server 2016 CLR
[read this post on Mr. Fox SQL blog]
Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that...
2016-09-20 (first published: 2016-09-12)
2,112 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