CONVERT and HEX
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-02-17
8,189 reads
Azure SQL Database security
Life we be so much easier if we could just trust everyone, but since we can’t we need solid security...
2016-02-17
985 reads
TSQL Tuesday #75 – PowerBI
This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It...
2016-02-17
453 reads
Documenting SQL Server Access – Who Can Do What? - Syndication – WaterOx Consulting
When is the last time you audited who has SQL Server access? No really? When did you last do this?...
2016-02-22 (first published: 2016-02-17)
1,697 reads
Take caution when altering a column using TSQL
When developing in SQL Server you are eventually going to have to modify a column or two (at least). And...
2016-02-23 (first published: 2016-02-17)
3,974 reads
Creating KPIs in SQL Reporting Services
In this blog I will explain how to create a Key Performance Indicatory (KPI) in SQL Reporting Services 2016. Let’s...
2016-02-22 (first published: 2016-02-17)
6,860 reads
T-SQL Tuesday #75: Jump into Power BI
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it...
2016-02-17
28 reads
T-SQL Tuesday #75: Jump into Power BI
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it...
2016-02-17
49 reads
T-SQL Tuesday #75: Jump into Power BI
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world....
2016-02-17
2,005 reads
Pronouns in technical writing.
When doing technical writing, or for that matter most forms of writing , we need to be able to refer to...
2016-02-17
685 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