Notes from the March 2016 oPASS Meeting
Quick notes:
Chinese food instead of pizza (thanks Shawn!)The wine bar is doing some remodeling to make better use of the...
2016-03-28
598 reads
Why I Love #SQLSaturday
PASS SQLSaturdays are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of...
2016-03-28
479 reads
Query Store and Optimize For Ad Hoc
I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...
2016-04-11 (first published: 2016-03-28)
1,944 reads
Utility function: dbo.JobName(@job_id)
As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...
2016-04-08 (first published: 2016-03-28)
1,490 reads
SQL Nexus in Copenhagen
The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the...
2016-03-28
596 reads
Why you shouldn’t use SELECT *
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
508 reads
Using PowerShell to set Extended Events Sessions to AutoStart
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,703 reads
The Future of the User Groups (SQLPort)
With SQLPort approaching it’s 6th birthday (21st of April), I have to admit that the works on the user group...
2016-03-27
483 reads
SQL Bite-Size Podcasts are live!
Well, after many late nights I have finally produced a set of podcasts – Bite size style – therefore called SQL Bite...
2016-03-27
283 reads
Most common interview questions
1. Tell me about yourself.
Answer - Give summary of your past education and work, skills, and achievements and include your strong...
2016-03-27
168 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