What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
32 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
53 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
47 reads
Mailbox Statistics report with Email addresses
Script to collect and export the mailbox properties from Get-Mailbox and Get-MailboxStatistics cmdlets to a CSV file
This script can be extended based...
2016-01-07
686 reads
Advent of Code Day 1, Puzzle A
I have been working my way through the Advent of Code series across the last few weeks. This is a...
2016-01-07
679 reads
SQL Saturday Chicago Precon – SQL Server Infrastructure – March 4
I’m pleased to announce that I’m launching a new all-day precon training session at the next SQL Saturday in Chicago...
2016-01-07
387 reads
MongoDB -Access different databases and Collections
You can use db.getSiblingDB() method to access another database without switching the database.
To List Collections of PP database and query...
2016-01-14 (first published: 2016-01-07)
1,937 reads
Download the Power BI Architecture Diagram
Update: I’ve updated the Power BI architecture diagram! Click here to view version 2!
As a Data Platform Solution Architect for...
2016-01-06
4,615 reads
XenApp/XenDesktop 7.6 FP3 VDA Deployment Issue
During the upgrade to XenApp 7.6 FP3 VDA encountered the following message.
I was wondered on seeing this popup to restart...
2016-01-06
568 reads
T-SQL Tuesday #74 Invitation: Be the Change
Happy New Year and welcome to another T-SQL Tuesday (number 74 to be exact). This time of the year, everyone...
2016-01-08 (first published: 2016-01-06)
2,150 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, 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