SSRS 2005 Error: The Declare cursor SQL construct or statement is not supported
Few days back I downloaded a SSRS 2005 file from one of our internal report server and started modifying it....
2011-04-12
2,896 reads
It's not about whether you're a consultant or full-time staff...
There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...
2011-04-12
1,342 reads
PASS SQLRally–Thoughts from an Organizer
There have been lots of blog posts about PASS SQLRally (Bing Search), but there haven’t been a lot recently from the...
2011-04-12
845 reads
PASS Women in Technology
The Professional Association for SQL Server (PASS) Women in Technology group first caught my attention at the PASS Summit in 2009...
2011-04-12
1,005 reads
Confessions of a DBA – Part 2
How I caused a fifteen minutes of blocking.
This particular incident happened when I joined this company. I joined this company...
2011-04-12
1,351 reads
Powershell Day 12
Day 12 ADSI Using Powershell you can work on Active directory as well. Active directory is introduced in windows 2000....
2011-04-12
486 reads
T-SQL Tuesday - Using APPLY to find out which queries are running on which CPU...
When I saw that Matt Velic's is hosting T-SQL Tuesday, and he has invited the SQL commmunity to participate, I was very...
2011-04-12
2,924 reads
Corporate Staffers = Second Class Citizens?
Earlier today I read a blog post that compares consultants with corporate staff members. The author unashamedly compares consultants to...
2011-04-12
777 reads
Corporate Staffers = Second Class Citizens?
Earlier today I read a blog post that compares consultants with corporate staff members. The author unashamedly compares consultants to...
2011-04-12
1,320 reads
April Version of SQL Server 2008 Diagnostic Queries
I have added two new queries to this month’s version, to try to collect some more hardware information about the...
2011-04-11
501 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