Dell Webinar: 10 Ways To Abuse T-SQL
I’m a bit late getting this posted, so to the two of you waiting to see it, I apologize. Back...
2014-03-12 (first published: 2014-03-02)
1,946 reads
Browser Based Web Notifications
3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are...
2014-03-01
52 reads
Cloning a SQL Server Database
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
54 reads
PASS, Evangelism, Goals, Dreams
The role of PASS in the community has evolved a lot over the past few years. Back in 2006/2007 PASS...
2014-02-28
1,303 reads
Powershell in a Month Day 18–Variables
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-02-28
1,456 reads
Upcoming Webinar - Introduction to Power BI
Come join me for this webinar on 3/13/2014 at 11:00 AM EST
Introduction to Power BI
The future of Business Intelligence has...
2014-02-28
1,355 reads
Webinar Q&A: New BI Features in SharePoint 2013
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in...
2014-02-28
1,785 reads
Reblog: February 21 to February 27
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-02-28
1,460 reads
Friday Followup For February 28, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-28
1,137 reads
Why wait statistics are important and how you can start collecting them now!
Why wait statistics are important and how you can start collecting them now!
Wait statistics have always been a very important...
2014-02-28
1,396 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