A Day In The Life of a SQLBits Volunteer
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...
2016-05-10
665 reads
SQL Server : Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0
I have recently experienced an issue with a third-party backup application (Commvault) that was trying to backup the databases from...
2016-05-09
3,347 reads
SQL Server Command Timeout – Application Timeout – Attention
When you use ODBC or SqlClient to access data from SQL Server, by default the query will be cancelled if there is no response from the server within a...
2016-05-09
52 reads
Common uses of stored Procedure sp_MSforeachtable
We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.
sp_MSforeachtable can be used to loop through all...
2016-05-09
11,650 reads
Monday Morning SQL Break – May 9, 2016
It’s Monday morning (er afternoon) and it’s time for this week’s blog and twitter round-up for last week. If you...
2016-05-09
495 reads
Events I Wish PASS Organized
I was talking a bit with a friend at SQLSaturday Jacksonville and realized I needed to write down a thought...
2016-05-09
1,133 reads
Notes From SQLSaturday Jacksonville 2016
Everything ran smooth The site reminds me of Orlando – limited space for sponsors, but offset by the other advantages (free...
2016-05-09
531 reads
SQL Server 2016 at the BRSSUG Meeting on May 11
Looking forward to the BRSSUG/BRPBIUG meeting this Wednesday night May 11, I'll be giving a presentation all about SQL 2016!
This...
2016-05-09
378 reads
SQL Server – Row Level Security in SQL Server 2016 – Part 3
Hi friends, continuing from the previous post in this post we will learn how to add the blocking predicate to...
2016-05-09
1,018 reads
Update to Date and Time Dimensions
Wanted to just post my latest versions of my Date and Time Dimension scripts. It has been a couple years...
2016-05-09
401 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