Installing & Configuring Microsoft SQL Server On Linux
This exercise demonstrates the installation and configuration of Microsoft SQL Server on Linux environment, this is a standalone deployment . Step 1 – Create “mssql”(more...)
2020-12-08
20 reads
Installing Postgres Database
This exercise demonstrates the installation and configuration of Postgres database on Linux environment using source tar file. Step 1 – Download Postgres tar file wget(more...)
2020-12-08
26 reads
Open Letter to the PASS Membership,
When I was appointed to serve as a Director at Large for the PASS Organization a year ago, it was with great passion, excitement and enthusiasm. I had some...
2020-12-08
44 reads
Installing MySQL On Centos 7 Linux
In CentOS 7 Linux MariaDB is by default installed, due to this you may face issue installing MySQL. If you want to install MySQL, first(more...)
2020-12-08
38 reads
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
14 reads
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
8 reads
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
9 reads
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-17 (first published: 2020-12-08)
205 reads
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
10 reads
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
10 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