Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-21
208 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-28 (first published: 2016-03-21)
1,798 reads
SQL Data Generator –Specific Domains for a Column
I was mocking up some test data and wanted to limit my list of values to specific items. In this...
2016-03-25 (first published: 2016-03-21)
1,562 reads
Monday Morning SQL Break – March 21, 2016
Monday, Monday, Monday… let’s start with a wrap-up of last week’s blog and twitter activity. If you haven’t already, follow me...
2016-03-21
444 reads
Cross Database Query in Azure SQL Database
You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an...
2016-03-28 (first published: 2016-03-21)
3,142 reads
TOP 1 killed my performance; Rob Farley helped me resurrect it.
tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if...
2016-03-25 (first published: 2016-03-21)
4,633 reads
Database Growth Trends – Idera Diagnostic Manager
How fast are your databases growing? Should I panic about a 1 TB database that has 100 GB free on disk? Am I safe with a 100 GB database...
2016-03-21
47 reads
Database Growth Trends – Idera Diagnostic Manager
How fast are your databases growing? Should I panic about a 1 TB database that has 100 GB free on...
2016-03-21
675 reads
Columnstore Indexes – part 81 (“Adding Columnstore Index to InMemory Tables”)
Continuation from the previous 80 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Microsoft is doing an amazing job with...
2016-03-21
516 reads
Weekly Round-up 21st March 2016
Here are some of the more interesting links that I have found this week
SQL Server
SQL Server 2016 RC1 has...
2016-03-21
452 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