MDS 2016 CTP 2.3: tiles greyed out in Manager
I’m toying around with MDS 2016 CTP 2.3 in preparation of my SQLServerDays session about what is new for BI...
2015-09-15
827 reads
Load Testing Your Storage Subsystem with Diskspd
One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On a new system this is critical because I want...
2015-09-15
22 reads
Load Testing Your Storage Subsystem with Diskspd
One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On...
2015-09-15
2,848 reads
Hekaton Part 7 - Hash Collisions & Hash Buckets
As explained in the earlier post, a hash index places pointers to the rows in hash buckets, depending upon the value returned...
2015-09-15
703 reads
ScriptDom versioning issues
I installed the 2016 SSMS client recently and in one way or another any of my apps that I have...
2015-09-15
778 reads
ScriptDom versioning issues
I installed the 2016 SSMS client recently and in one way or another any of my apps that I have...
2015-09-15
45 reads
ScriptDom versioning issues
I installed the 2016 SSMS client recently and in one way or another any of my apps that I have...
2015-09-15
39 reads
ScriptDom versioning issues
I installed the 2016 SSMS client recently and in one way or another any of my apps that I have written that use the DacFx ScriptDom have all broken...
2015-09-15
5 reads
Creating Time Calculations in Power BI
One of the current issues in Power BI is the inability to specify a Date table. The Date table is...
2015-09-15
932 reads
Remember the N
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-09-14
676 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