SQL Saturday #63 – Dallas: Wrap-up
SQL Saturday #63 – Dallas was a great event. The venue was great, although parking was a little unclear (I had...
2011-04-04
795 reads
A SQL Server Hardware Nugget A Day – Day 3
Lest anyone accuse me of ignoring AMD in this series, I will talk about the AMD Opteron 6100 series processors...
2011-04-03
466 reads
Tampa IT Camp 2011 Lessons Learned Part 2
In part 1 I provide an overview of concept of IT Camp, how the plan was developed by borrowing ideas...
2011-04-03
702 reads
SQL Saturday #63 PPT
The PowerPoint deck from my presentation is here if you want it
http://www.sqlservercentral.com/articles/Presentations/70959/
- Posted using BlogPress from my iPhone
Filed under: Blog...
2011-04-03
864 reads
Powershell Day 3
Day 3 Programming in Powershell Part 1 Now you got some good basic information about Powershell, and some basic commands...
2011-04-03
1,102 reads
View system object definitions
G’day,
You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you...
2011-04-03
637 reads
SQL Saturday #63 – Dallas: Resources
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
647 reads
A SQL Server Hardware Nugget A Day – Day 2
For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor...
2011-04-02
550 reads
SQLSaturday #63, Great Event!
So,
I actually had a early morning sessions and gave my Solid State Storage talk and had a great time. The audience was...
2011-04-02
639 reads
Powershell day 2
Day 2 Introduction to Windows Powershell. Windows Powershell is a very powerful shell script to interact with windows. Using windows...
2011-04-02
1,474 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