SQL Server 2005 SP3 Cumulative Update 13 Released
Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday,...
2010-12-22
863 reads
SQL Server Scripts Manager From Redgate Software
Redgate Software has released a useful free tool called SQL Server Scripts Manager. I was happy to be included as...
2010-12-22
1,926 reads
Book Plug: Say Goodbye
I read a lot, and often marvel at the effort that goes into writing them, and I think I get...
2010-12-22
622 reads
SSIS to SQL Server Data Type Translations
I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS...
2010-12-22
99,934 reads
Can You Dig It? – StmtCond Element
She can dig it!
D Sharon PruittA couple posts ago in the plan cache series I discussed the children for the...
2010-12-22
923 reads
The Real Purpose for Kindle
It finally dawned on me why people would bother getting a separate book-reading device like Kindle - and why it might...
2010-12-22
1,256 reads
SQL Server Storage Internals Part 4 - How to read a Heap page
I like to share 4 updates before moving on to this section:
1. I 've updated my profile to know more about...
2010-12-21
7,781 reads
Pragmatic Works: The Transition
So if you know me via Twitter or my blog you
probably know that as of about a month or two...
2010-12-21
996 reads
Can You Dig It? – StmtUseDb Element
She can dig it!
D Sharon PruittThe last post in the plan cache series discussed the children for the Statements element. ...
2010-12-21
697 reads
Get Prepared for the January Hiring Season
Get Prepared for the January Hiring Season
As the year winds down, in what was undoubtedly a tough economic year for...
2010-12-21
767 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...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
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