Speaking at SQLSaturday Chicago
I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my...
2016-01-29
855 reads
Call for Speakers for Orlando Code Camp 2016 Ends February 6, 2016
Quick reminder that the call for speakers for Orlando Code Camp is open through Feb 6 (next week!).
2016-01-29
1,092 reads
SSC Editorial: Turn Out the Lights
This ran a couple weeks ago (Turn Out The Lights) to see if I could spark a discussion about how/when/why...
2016-01-29
1,054 reads
Easy way to test log shipping or availability groups setup
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
814 reads
PASS Board 2016: Update #1
Hello everyone. Just because I’ve moved on to the executive committee doesn’t mean I’m walking away from these reports. I...
2016-01-29
902 reads
First foray into presenting
It’s been a while since I’ve posted as the run up to Xmas last year and this January have been...
2016-01-29
793 reads
Easy way to test log shipping or availability groups setup
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
601 reads
SQL Server Management Studio Setup and Configuration
This is my first #entrylevel blog post. The challenge identified by the tags #entrylevel and #Iwanttoshare was started by Tim...
2016-01-28
1,582 reads
SQL Server Principals – Back to Basics
A fundamental component of SQL Server is the security layer. A principle player in security in SQL Server comes via principals.
Related Posts:
Easy Permissions Audit January 21, 2019
SQL...
2016-01-28
430 reads
SQL Server Principals – Back to Basics
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-02-03 (first published: 2016-01-28)
3,324 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