Using IIF in Reporting Services
I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide...
2007-03-10
1,735 reads
Blog Posts
SQL Server Learning Opportunities!
There are two big SQL Server learning opportunities I want to remind you about. First, DevTeach/SQLTeach will be held in...
2007-03-09
1,805 reads
Midlands PASS Job Board
In order to assist those members of the Midlands PASS Chapter looking for new positions, I have put up a...
2007-02-26
1,357 reads
Hacked
Boy that was fun. Getting a bunch of emails that we had been hacked and tracking down someone updating all...
2007-02-22
1,529 reads
SP2
Mentioned by Tim Mitchell, but SP2 is out.
Seems more like enhancements to make things smoother and lots of changes in...
2007-02-20
1,466 reads
SQL Server SP2 released
Today, Microsoft released Service Pack 2 for SQL Server 2005. Though mostly a series of fixes for minor issues, there...
2007-02-19
1,435 reads
Microsoft SQL Server certification
A few weeks ago I was engaged in a useful discussion about the merits of getting certified on Microsoft SQL...
2007-02-18
1,934 reads
Daylight Saving Time and SQL Server
If you're in the United States, chances are you've already heard about Daylight Saving Time (DST) occurring 3 weeks early...
2007-02-13
2,680 reads
Midlands PASS Site Online
I have put the Midlands PASS site online temporarily at Truth Solutions. You can reach it here:
http://www.truthsolutions.com/MidlandsPASS/
The slides from Paul...
2007-02-12
1,622 reads
Guest Editorial Week
I've been writing the editorials for over two years now and it's become an almost daily part of my life....
2007-02-11
1,460 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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