I’m a Data Platform MVP for the third year in a row
I’m extremely honored to be named Microsoft Data Platform MVP for the third year in a row! I thank the...
2016-07-01
302 reads
Securing MongoDB – User Administration
The db.createUser(user, writeConcern) method used to create users.We need to provide the username, password and roles
The definition of createUser as follows
{user:"<name>",pwd:"password>",customData:{<User...
2016-07-01
414 reads
Hello World on .NET Core
The developments over the last few months in the data community had brought us to an interesting place. We’re going to have SQL on Linux and now we also...
2016-07-01
15 reads
Hello World on .NET Core
The developments over the last few months in the data community had brought us to an interesting place. We’re going...
2016-07-01
695 reads
Azure SQL Database scripts
I thought that this would be useful for others – couple of scripts that I have been using in Azure for...
2016-07-01
211 reads
BimlScript – Get to Know Your Control Nuggets
This is post #2 of my BimlScript – Get to Know Your Code Nuggets series. To learn about text nuggets, see my...
2016-07-01
477 reads
Python Distributions
Python Distributions Python is free and open source software. A programmer could download the executables for Python directly from the...
2016-07-01
609 reads
The SQL Server 2016 In-Memory Evolution – from row-store to columnstore to in-memory operational analytics
(DE)
Der SQL Server 2016 ist da, und damit nun auch die „Version 2“ der In-Memory OLTP Engine, wenn man...
2016-06-30
1,031 reads
My Feedback on my PASS Abstracts Feedback
Brent Ozar recently published the feedback he got on his abstract submissions for PASS Summit 2016 and, as he often...
2016-06-30
902 reads
PowerShell CMDLets added for SQL2016 Always Encrypted
The post on the SQLServer blog at TechNet by the SQL Server Tools Team today made me jump out of...
2016-06-30
1,010 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