Recompile Monitoring using XEvents
Recompiles can be a hidden bottleneck on your server, and it may not be too obvious. I should know, it...
2016-03-17 (first published: 2016-03-07)
1,669 reads
Get the Total Item Size for an Exchange database
Hey there!
This one is for those Exchange admins who think it is a sin to use hands for something that...
2016-03-06
794 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports:SQLServer default instance port...
2016-03-05
150 reads
Columnstore Indexes – part 78 (“Temporary Objects”)
Continuation from the previous 77 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to spend some time...
2016-03-05
507 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...
2016-03-05
11 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...
2016-03-05
17 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports:
SQL Server default instance...
2016-03-05
89 reads
PowerShell–Don’t Use Write-Host
I’ve written a few scripts and programs lately, mostly just for fun. In those scripts, I’ve used Write-Host to return...
2016-03-04
1,638 reads
Excel Tip #30: Excel Services Visual Limitations – Displaying Images
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2016-03-14 (first published: 2016-03-04)
1,723 reads
Speaker of the Month: March 2016
I’m finally getting back out to community events so I should be able to avoid giving this gigantic honor to professional...
2016-03-04
410 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
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