URL Based Images using SSRS
For header images, I typically embed an image into the report. However, there may be times when you need to...
2010-12-13
834 reads
More Networking Thoughts
I’ve happened to have a few networking events happen recently that I thought I’d share, all part of trying to...
2010-12-13
651 reads
Learn SSIS in Under an Hour on the SQL Lunch
Don't miss the SQL Lunch tomorrow.
#44-Learning SSIS under 1 hour
Speaker: Jose Raul Chinchilla
Add To Outlook: Add To Calendar
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=FN36T2&role=attend
Date...
2010-12-13
919 reads
SSIS Denali Source and Destination Assistants
In several previous posts I have described some of the usability changes that will come with the next release of...
2010-12-13
1,477 reads
Life/Work Balance
Technology, especially information technology, is the greatest thing to ever happen to mankind, freeing us from toil and drudgery. Technology,...
2010-12-13
925 reads
PASS SQLRally Call For Speakers Update
Well, we have 3 days left in the PASS SQLRally Call for speakers and we are doing well. We have over...
2010-12-13
330 reads
SQL Server Storage Internals Part 1 - Basics
While learning query tuning topics, I got a chance to understand anatomy of data page and different types and levels...
2010-12-13
6,826 reads
Upgrading to SQL Server 2008 - a comprehensive checklist.
There are many considerations and much preparation to do, when a company decides that it is ready to upgrade their...
2010-12-13
13,808 reads
iPads for Christmas
There's a contest going on, today through Friday, and you can win a copy of SQL Monitor from my employer...
2010-12-13
809 reads
SQL Server 2005 SP4
Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and...
2010-12-13
1,439 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