Viewing Running XEvent Metadata
In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata...
2015-09-08 (first published: 2015-09-03)
1,328 reads
SQL Server 2014 Buffer Pool Extension part 3: system monitoring
In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of...
2015-09-03
1,300 reads
Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)
Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to write a rather...
2015-09-02
631 reads
An Evening of Networking at the 2015 PASS Summit on October 26, 2015 (Monday)
Going to be in Seattle on Monday night (Oct 26th) and want to see old friends and make some new...
2015-09-02
609 reads
We can do professional SQL Server deployments using SSDT
Really excited by my first post on medium, haven't really used it before but found it to be a really...
2015-09-02
576 reads
We can do professional SQL Server deployments using SSDT
Really excited by my first post on medium, haven’t really used it before but found it to be a really...
2015-09-02
21 reads
We can do professional SQL Server deployments using SSDT
Really excited by my first post on medium, haven’t really used it before but found it to be a really...
2015-09-02
13 reads
Checking for Excessive Permissions in SQL Server - Syndication – WaterOx Consulting
Who can do what? One of the key things that a DBA...
The post Checking for Excessive Permissions in SQL Server...
2015-09-02
515 reads
We can do professional SQL Server deployments using SSDT
Really excited by my first post on medium, haven't really used it before but found it to be a really nice tool:
https://medium.com/@edelliott.the.agilesql.club/let-s-start-doing-profes…
2015-09-02
16 reads
Upcoming Presentation – Space Coast SQL/.Net User Group
If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to...
2015-09-02
1,113 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