Securing Database Contents with Transparent Data Encryption (TDE)
Introduction
Microsoft SQL Server has many security features available within the database, but until release of SQL Server 2008 there has...
2012-07-08
7,784 reads
Blog Posts
SQL Server 2012 Diagnostic Information Queries (July 2012)
Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to...
2012-07-08
1,069 reads
5 Reasons Why I Need To Go To SQLskills Immersion Training
I was thinking about the contest that SQL Sentry is running for a week of SQLskills Immersion Training, and the...
2012-07-07
960 reads
Backup Master Database
The story came from a question someone asked me.
Does Master database support full recovery mode?
As I remembered, by default,...
2012-07-07
6,113 reads
Basic SQL Interview Questions
We decided to add blog post that covers only basic SQL Interview questions and answers. The blog currently provides only...
2012-07-07
1,074 reads
Data Manipulation Language
In this blog post we describe what is Data Manipulation Language (DML) and include this article in our exam guide...
2012-07-07
319 reads
Lost in Translation – Deprecated System Tables – sysconstraints
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-07
1,583 reads
Lost in Translation – Deprecated System Tables – syscurconfigs
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-07
1,184 reads
MDX ClosingPeriod and PeriodsToDate
I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write...
2012-07-07
1,287 reads
Speaker Selection for SQLSaturday Orlando-Group #4
We’ve selected 10 speakers so far, today we bring it to a fabulous bakers dozen with three more – all based...
2012-07-07
737 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
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