SQL Server 2012 Diagnostic Information Queries (April 2012)
It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...
2012-04-26
2,709 reads
Blog Posts
SSWUG Expo..I'm up!
I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...
2012-04-26
337 reads
The Mentoring Experiment – Cycle 2
It’s been a long time, almost a year since Andy Warren and I kicked off The Mentoring Experiment. We had...
2012-04-26
934 reads
UF Dissolves Computer Science Program, Increases Funding for “Future Jobs”
In a bold and decisive move earlier today, the University of Florida has decided to dissolve their computer science education...
2012-04-26 (first published: 2012-04-24)
3,818 reads
2012 (2011) Data Breach Report
I had a chance over the weekend to finish reading the Verizon 2012 Data Breach Investigations Report. It’s a compilation...
2012-04-25
1,112 reads
Creating a Symmetric Key in SQL Server
Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and...
2012-04-25
12,585 reads
Enterprise Data Warehouse Architecture Options
Enterprise Data Warehouse Architecture Options
Of course, your architecture depends on your business requirements along with technical, historical, and political factors....
2012-04-25
4,288 reads
Setup database mirroring and log shipping together
SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...
2012-04-25 (first published: 2012-04-21)
12,444 reads
SQL Azure Federation
What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.It is also known as...
2012-04-25
838 reads
SQL Azure Federation
What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.
It is also known as Sharding.
There can be multiple federations in a database.
It is...
2012-04-25
405 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
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