Low Power SQL Server Test Lab on Windows Server 8 Hyper-V / ESXi5
Windows Server 8 Beta is released, if you are looking to build a low cost, Low power PC which can...
2012-03-03
997 reads
Goodbye Microsoft, Hello World
Goodbye Microsoft, Hello World
Goodbye Microsoft, Hello World
The cowboy’s job is done here, and it’s time for him to move on...
2012-03-03
2,027 reads
Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to do a comparison between two versions to make sure...
2012-03-02
436 reads
Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to...
2012-03-02
3,251 reads
Running a script on multiple servers
One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...
2012-03-02
2,718 reads
Want to write for Microsoft?
Edit: The group I’m speaking to is the Content Team, not the Books Online (BOL) team!
Edit: Updated with FAQs and...
2012-03-02
725 reads
Re-blog – February 24 – March 1
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-02
470 reads
SQL Server 2012 (“Denali”): Database Recovery Advisor
Database Recovery Advisor is a new feature in SQL Server 2012 that introduces significant user experience enhancements to the ways DBAs...
2012-03-02
1,045 reads
A Script A Day - Day 29 - The Importance of Being Idle
Today’s script is also one I used in my migration on Wednesday. It again uses string manipulation to generate a...
2012-03-02
529 reads
A Script A Day - Day 28 - String Manipulation
Today’s script is one that I used earlier this week. On Thursday I migrated a server from SQL Server 200...
2012-03-02
536 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