Feb 2011 S3OLV Meeting
I am getting this out extremely late. I seriously have good excuses for that. Due to my location and Charley...
2011-02-09
352 reads
SQL RNNR
Feb 2011 S3OLV Meeting
I am getting this out extremely late. I seriously have good excuses for that. Due to my location and Charley feeling ill, we will be doing the S3OLV UG...
2011-02-09
6 reads
T-SQL Tuesday #15 DBA Automaton
I have been incognito for the last couple of weeks and nearly missed TSQL Tuesday this month. If it weren’t...
2011-02-09
827 reads
T-SQL Tuesday #15 DBA Automaton
Often, we hear about DBA's automating everything under the sun. Why? It simplifies the job and creates time to work on other projects.
Related Posts:
Automating like an Enterprise DBA January...
2011-02-09
13 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands...
2011-02-08
543 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands of SQLSkills. Later that week an announcement was made...
2011-02-08
9 reads
Immersion in Internals
Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas. This is not...
2011-01-26
979 reads
Immersion in Internals
Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas. This is not run of the mill training, but it...
2011-01-26
11 reads
The Lost Hero – A review
With what looks to be five books planned in a new series by Rick Riordan, people have some good fantasy...
2011-01-25
548 reads
The Lost Hero – A review
With what looks to be five books planned in a new series by Rick Riordan, people have some good fantasy ahead of them. I just finished the first installment...
2011-01-25
10 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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