Top Five Backup and Recovery Plans for SQL Database
Introduction
Creating a good backup and recovery plan for SQL database is a very important task of a database administrator. A...
2018-02-02
2,441 reads
Blog Posts
Trello – Integrations
In December I wrote about working from home in which I talked about Trello. Trello is a virtual kanban board...
2018-02-02
446 reads
Trello – Integrations
In December I wrote about working from home in which I talked about Trello. Trello is a virtual kanban board...
2018-02-02
102 reads
VSLive 2018 Austin, TX
VSLive events are nice conferences to get a wide range of topics from .Net to mobile development to the data platform. It looks like they have added some Hands-on...
2018-02-02
16 reads
WIT: A Quick Thought
I recently had the opportunity to be a Dungeon Master (DM) at a gaming convention. It was my first time....
2018-02-02 (first published: 2018-01-22)
1,578 reads
Configuring Persistent Storage for SQL Server in Azure Container Services
I’ve been playing around with SQL Server running in Kubernetes in Azure Container Services (AKS) for a while now and...
2018-02-01 (first published: 2018-01-24)
1,488 reads
Considerations for dealing with big databases
Stress everywhere, user wants everything "Para ayer"Photo by Bernard Goldbach
If you are like me, and have SQL Server instances with...
2018-02-01
604 reads
Controlling what appears in the status bar and query tabs (Day 32)
When you run a query in SSMS, you are probably aware that the status bar contains many pieces of information...
2018-02-01
545 reads
Database Superhero Adventures, February 2018 Edition
vs.
The week of SQLSaturday Nashville would prove to be a most eventful week. Monday I would be on my work...
2018-02-01
133 reads
DBA best practices..from the DBA from Heaven
I met Tom Roush for the first time around 9 years ago – at a PASS Summit. If I recall right...
2018-02-01
699 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