Influence Skills: Live from @LearningTree London Day 4
We've made it to the final day, day 4 of Learning Tree course 294 Influence Skills: Getting Results without Direct Authority.
Today...
2016-07-08
520 reads
Microsoft SQL Server 2016 Certifications Announced
Hi friends, Microsoft has announced the release of three new SQL 2016 certifications, based on the different working database professional’s...
2016-07-08
809 reads
SQL Server Basic - Memory
For those of you who just started to manage SQL server might wonder why SQL server use so much memory....
2016-07-08
867 reads
SQL Server and Continuous Integration
This is the 1st in a series of posts on SQL Server and Continuous Integration. Some of the tools I’ll be...
2016-07-07
762 reads
Using sp_executesql Parameters –#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-07
881 reads
Virtualization does not equal a private cloud
I see a lot of confusion when it comes to creating a private cloud. Many seem to think that by...
2016-07-07
1,364 reads
Zilch to Speaker: 2016 Summit Abstract Reviews
Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along...
2016-07-07
451 reads
Influence Skills: Live From London Day 3
The main news this morning: Wales' heroic efforts at the Euros came to end last night with a 2-0 defeat...
2016-07-07
395 reads
Tempdb monitoring - Free space alert
SQL Server uses tempdb for many features, including row versioning, service broker and query execution amongst others. During the execution...
2016-07-07
3,862 reads
T-SQL Tuesday #080
T-SQL Tuesday time is here again! And I’m honored to be hosting this months block party. Why you ask? T-SQL...
2016-07-07
926 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