Stop Asking and Start Making Decisions Today
Ever have one of those days where no matter how hard you try you just can’t seem to make any...
2011-04-25
698 reads
John Sansom
Part 1: The Database Administrator's Primary Responsibility
SQL Server Essentials Part 1: A look at the key responsibility of a DBA and why it is so vital.
2011-04-22 (first published: 2009-09-14)
24,233 reads
7 Essential Habits of Successful DBAs
There are many different paths you can travel on the journey to success. There is no precise route that everyone...
2011-04-18
1,439 reads
SQLBits 8 – That’s a Wrap
This weekend saw the 8th SQLBits conference take place amidst glorious British sunshine by the sea in Brighton.
For those unable...
2011-04-10
894 reads
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-04-04
2,065 reads
Taking It To The Next Level
Have you set the bar high enough to ensure your success?
You’re reading Taking It To The Next Level, day 5 of 5...
2011-03-31
1,436 reads
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-03-30
2,129 reads
How To Really Listen
One of the most undervalued skills that an individual can possess is the ability to listen. Are you really hearing...
2011-03-29
1,644 reads
Think Like a Customer
This is the most important and essential first step for a DBA on the journey to providing outstanding customer service....
2011-03-28
860 reads
5 Days to Outstanding DBA Customer Service
Outstanding Customer Service in 5 days
Your success as a Data Professional is directly dependant to the quality of service you...
2011-03-27
670 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