Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify this year to keep it active. So shortly after...
2016-03-21
18 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-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,634 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
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