Database Mirroring Deprecated in SQL 2012
From the newly released SQL 2012 Books Online documentation:
This note shows that as of SQL Server 2012, which will be...
2012-03-09
3,010 reads
SQL Server - Kerberos and KRB_AP_ERR_MODIFIED
On a routine scan of Event Viewer System, Logs I found this message on 4 different servers hosting SQL Server...
2012-03-09
3,258 reads
SSAS Tabular Model – Query Modes
One of the most compelling features of the new SSAS Tabular Model is the ability to set the model’s Query...
2012-03-09
2,986 reads
March 2012 – Monthly SQL Server Checklist
Are your SQL Servers healthy? If the things went south today today, would you be able to say you can...
2012-03-08
1,774 reads
Let’s Talk
I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it,...
2012-03-08
880 reads
March Madness – SQL Server style
Bodypaint not required
It seems that March is another great month for getting your geek on without having to leave the...
2012-03-08
646 reads
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites to which they belong? I would dare say that...
2012-03-08
8 reads
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites...
2012-03-08
797 reads
SQL Server – netstat monitoring and tuning performance
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it...
2012-03-08
1,328 reads
Moving MASTER Database
In my previous post we see how to move MSDB database, today we will see how to move or relocate...
2012-03-08
1,086 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