SQL Server Morning Health Checks
Every now and again as a Microsoft PFE, you get a chance to make a big difference for a customer....
2018-01-08 (first published: 2018-01-02)
2,677 reads
Blog Posts
SQLCMD Mode (Day 8)
Have you ever had a script where you needed to run parts of it on different instances of SQL Server...
2018-01-08
446 reads
SSMS Solutions (Day 1)
Since SSMS is built upon Visual Studio, many of the features available to Visual Studio are also available to SSMS....
2018-01-08 (first published: 2018-01-01)
3,249 reads
What is Graph Processing in SQL Server 2017?
There is a growing need for Graph Databases in the market. This is a type of database, which is capable...
2018-01-08
579 reads
Why I am leaving a role/company I loved
This non-technical post is about why I am leaving a technical company after working there for 17 + years.
If you are...
2018-01-07
530 reads
WITH DATA_PURITY (from recent experience, the key to knowing if patching to 14.0.3015.40 was okay)
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
508 reads
Common Tempdb Trace Flags – Back to Basics
In this article I introduce you to some basics in regards to default behaviors and settings in tempdb along with some best practices. It is advisable to investigate from...
2018-01-06
31 reads
Common Tempdb Trace Flags – Back to Basics
Once in a while I come across something that sounds fun or interesting and decide to dive a little deeper...
2018-01-06
564 reads
Vertical Scroll Bar Map Mode (Day 6)
Have you ever had a long script that you are trying to scroll through? Do you wish that you could...
2018-01-06
582 reads
Changing Default Logs Directory – Back to Basics
In this article I will explore altering the default logs directory location. Some may say this is no big deal and you can just use the default location used...
2018-01-05
46 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