Step by Step SSIS - Conditional Split Transformation TIP #117
In the series of Zero to Hero in SSIS this is our next post. In this post we will see...
2015-09-21
3,286 reads
Clustered Index and related Interview Questions
Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I...
2015-09-20
383 reads
Clustered Index and related Interview Questions
Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I...
2015-09-20
2,038 reads
Free SQL Azure eBook
As this blog post is being published David will be delivering his “Putting his Head in the Cloud – Working with...
2015-09-19
559 reads
SQL Saturday San Diego tomorrow! (September 18)
This weekend we’re going to hit SQL Saturday San Diego for the first time ever! We are the excited. Come and...
2015-09-18
812 reads
Map Data Types in Extended Events
Maps are like a way of overloading the data type to expose more meaningful values that relate to the payload data in question. The standard data types can also...
2015-09-18
17 reads
Map Data Types in Extended Events
In the last segment, I wrote about the data types for the payload of an event in Extended Events. In that...
2015-09-18
523 reads
5 Enhancements to SQL Runbooks in the Azure Preview Portal
5 Enhancements to SQL Runbooks in the Azure Preview Portal
SEPTEMBER 18, 2015
IntroductionRunbooks are your SQL Server Agent for Azure SQL Database. Lately, Microsoft have been making quite a few...
2015-09-18
30 reads
5 Enhancements to SQL Runbooks in the Azure Preview Portal
5 Enhancements to SQL Runbooks in the Azure Preview PortalSEPTEMBER 18, 2015
Introduction
Runbooks are your SQL Server Agent for Azure SQL...
2015-09-18
1,037 reads
2015-09-18
12 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