Restoring Filegroup backups on another server, and why it won’t work…
We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.
One of...
2014-02-20
679 reads
The Strange Story About the MERGE that Killed the Cluster
I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a...
2014-02-20
4,407 reads
101 Whiskies to Try Before You Die #whiskey
In his new book “101 Whiskies to Try Before you Die” whisky expert Ian Buxton poses the fun challenge of...
2014-02-20
719 reads
Attach Database “Operating System Error 5 (Access is denied)” MSSQL Server 2012.
When I try to attach mdf file I got following error below.
Solution:
There are multiple solutions to this
1 1. Move .mdf and .ldf to SQLServer install directory Data folder...
2014-02-20
65 reads
Review: 2013 Land Rover LR4 Overland Journal Edition
The guys at Overland Journal know how to adventure, and adventure well. Their magazines can be found both on coffee...
2014-02-20
907 reads
Restoring Filegroup backups on another server, and why it won't work...
We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.
One...
2014-02-20
4,981 reads
Finally added a (t) to my (b)
I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....
2014-02-20
512 reads
Lunch with someone new
I met up for lunch with a good friend and former coworker today, and among the topics of discussion was...
2014-02-19
856 reads
Free Mathematics Books – No really .. you want these!
Here is an alphabetical list of online mathematics books, textbooks, monographs, lecture notes, and other mathematics related documents freely available...
2014-02-19
615 reads
PASS Goals Published
Hopefully you got the email today from PASS containing these:
Volunteer GoalsProgram GoalsSQLSaturday GoalsReading them I’m first struck that we often...
2014-02-19
635 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