SQL Server 2016, Database Mail and .Net 3.5 Framework
There were so many cheers when Microsoft announced that the .Net 3.5 Framework was no longer a pre-requisite for installing...
2016-06-30
3,175 reads
Basic XML Node Query–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-30
1,090 reads
Single package deployment does not replace package deployment
In my article, Single package deployment in SQL Server Integration Services 2016, I covered the exciting single package deployment feature...
2016-06-30
515 reads
Webinar on 25 New PowerShell cmdlets for SQL Server and more!
Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a...
2016-06-30
11 reads
Webinar on 25 New PowerShell cmdlets for SQL Server and more!
Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a...
2016-06-30
568 reads
Power BI Pulse Chart vs. Dancing bars in Excel
[2016-Jun-30] Recently Microsoft Power BI has been enhanced with a new Pulse Chart custom visualization (Visual Awesomeness Unlocked: Pulse Chart) which...
2016-06-30
2,566 reads
Managing migrations with RedGate SQL Source Control 5
This is a good day for me. I’ve finally tried the improved migrations feature in the latest version of RedGate SQL Source Control ...
2016-07-07 (first published: 2016-06-30)
2,805 reads
BimlScript – Get to Know Your Code Nuggets
In BimlScript, we embed nuggets of C# or VB code into our Biml (XML) in order to replace variables and...
2016-06-30
949 reads
AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016
SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements based on some of my test cases(A detailed blog...
2016-06-30
12 reads
AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016
SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements...
2016-07-08 (first published: 2016-06-30)
7,210 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