CPU-Z 1.60 Released
Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...
2012-03-04
839 reads
Resource Governor Configuration
Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...
2012-03-04
4,659 reads
New upcoming events across Europe
I'm very happy today to announce 4 new upcoming SQL Server workshops across Europe
within the next months:
SQL Server Configuration...
2012-03-04
930 reads
SQL Server – How to troubleshoot query timeouts
Common reasons for query time-outs are :
1) The application starts using a query not optimal for the index
2) Hardware changes\...
2012-03-04
4,406 reads
SSRS or a Custom Web Form – Pros & Cons
In response to a post I made on an unrelated topic, a reader said "I’m not really a fan of...
2012-03-03
1,002 reads
A Script A Day Finished!
Well that's it, my "A Script A Day" series is finished. I hope you found the scripts I provided useful, I've used...
2012-03-03
585 reads
2012-03-03
23 reads
2012-03-03
13 reads
2012-03-03
12 reads
2012-03-03
32 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