Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,029 reads
2013 with You & SQL Server
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2014-01-30
1,134 reads
It May Be Necessary Re-enable Service Broker After Baremetal Restore
After the restore of a database, or perhaps a bare-metal restore of a Windows server running SQL Server, unique IDs...
2014-01-30
1,154 reads
Database Project Versioning
SSDT 2010, 2012 with TFS integration brought about a couple of different options when you are looking to version your...
2014-01-30
2,112 reads
SSIS Training class by Andy Leonard
Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class...
2014-01-30
1,799 reads
New SSIS Training Class from Andy Leonard
Andy Leonard (b | t | l | f), a good friend of mine from Linchpin People, has announced a new training class...
2014-01-29
1,409 reads
Have You Studied SQL Server Enough?
Photo Credit – yum9me
SQL Server is a fairly big and complicated product. There are quite a few areas that you can...
2014-01-29
1,501 reads
SQL Server Quickie #10 – Forwarding Records
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-29
781 reads
Reminder: I’m Presenting Security, Compliance, and SQL Server Today at 3PM Eastern
I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
552 reads
SSIS and PowerPivot training in Baton Rouge
I’m happy to announce that I’ll be teaming up with my Linchpin People colleague Bill Pearson for a day of...
2014-01-29
930 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