PowerShell, the New SQL Hammer
This is my PowerShell presentation that I have given to both Chicago SQL Server User Groups. The name of the...
2011-04-17
984 reads
Powershell Day 17
Day 17 Advance Mini Shell Mini shell is a good and can be used as a replacement of management studio,...
2011-04-17
423 reads
SSMS Tips & Tricks – Registered Server Groups
Here are a couple more SSMS tricks I’ve stumbled upon recently. Both involve the functionality of registered servers. If you...
2011-04-17
1,628 reads
A SQL Server Hardware Nugget A Day – Day 16
For Day 16 of this series, I want to talk a little bit about the new hardware license limits that...
2011-04-17
767 reads
Powershell Day 16
Day 16 Introduction to Mini Shell Mini Shell or SqlPS is the default shell utility provided by Microsoft to support...
2011-04-16
402 reads
SQL Azure
If you’ve talked to anyone from Microsoft recently you had to have heard the phrase “all in.” It’s been made...
2011-04-15
646 reads
Do you work with data? You’ve always got options.
She's ready for the future. Are you?
In preparing for the SQLPeople event, I thought about the role, motivation, and techniques...
2011-04-15
953 reads
The Pro-Active DBA List Updated
A couple of years back, in the heart of the economic tsunami, I proposed a list of pro-active steps to...
2011-04-15
1,386 reads
A SQL Server Hardware Nugget A Day – Day 15
For Day 15 of this series, I am going to talk about Power Management and its effect on processor performance....
2011-04-15
471 reads
Late April Free Training from PASS VCs
PowerShell provisioning of Hyper-V Servers
Designing Cubes for Performance
Database Standards SOP
_____________________________________________________________
PowerShell provisioning of Hyper-V Servers
April 20, 2011, 12 PM EDT (GMT...
2011-04-15
722 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