Auto Tweets from SQLSaturday
I was chatting with PASS community pollinator Karla Landrum recently and she asked me my thoughts on the auto tweets...
2012-08-25
710 reads
Various Links-August 25, 2012
Great story about a client who didn’t under the different between Skype and Sharepoint – while doing a Sharepoint initiative! It’s...
2012-08-25
739 reads
Digging deeper into SQL Server
I’m nowhere near where I needed to be. I am not digging enough. I’m not learning enough. Learning opportunities are...
2012-08-25
1,319 reads
T-SQL: Performance of SQL Agent Duration Calculations
In my article published yesterday on using Powershell for SQL Durations (Working with SQL Agent Durations), I proposed using a...
2012-08-24
1,636 reads
Mentoring
I’m putting my money where my mouth is, with respect to my last blog post. I am officially a mentor...
2012-08-24
654 reads
Government and Transparency
I ran across this report that talks about the effectiveness of transparency requirements put in place around the Recovery Act...
2012-08-24
658 reads
Book Review: Troubleshooting SQL Server A Guide for the Accidental DBA
Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended...
2012-08-24
2,167 reads
Intel Haswell-EP Processor Rumors
Intel releases a new processor microarchitecture every two years, which is called a Tock release. One year later, they take...
2012-08-23
1,787 reads
Man Vs Machine
Man Vs Machine
Man Vs Machine
Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In...
2012-08-23
1,084 reads
Script to find orphaned/unreachable job steps within your SQL jobs
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,630 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