To Do: Win Great SQL Training and a Cruise
Wondering what to do when you get a break from work email today?
Make your opening move in a fun contest.
What’s...
2011-03-31
1,916 reads
Hanging with an Inspiration
A long, long time ago, in a state far away, I started writing about technology. At the time, in the...
2011-03-31
1,407 reads
Presenting with a Mac
My name is Brian Kelley and I used to be a PC bigot. That was back in 1989. I was...
2011-03-31
1,576 reads
Change SQL Startup Parameters with PowerShell
Backups Abound
The Annoyance
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-03-31
14,478 reads
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-03-30
2,129 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have...
2011-03-30
17 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-03-30
3,898 reads
Dude, where’s my memory?
A session I have wanted to see. Marciej Pilecki has done this before with high ratings and I have missed...
2011-03-30
1,666 reads
Brad McGehee talking about tempdb issues
Brad presented a session that tries to help you identify and fix tempdb problems. Performance monitor is your friend. the...
2011-03-30
1,858 reads
Brian Kelley on Security at SQL Server Connections
Random notes from Brian Kelley’s security talk. Brian spent a number of years working a a security guy for a...
2011-03-30
1,903 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