PASS Summit Speaker Evals – THE ANALYSIS
Rule: No Sushi with Adam within 24 hours of session
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS...
2010-12-23
792 reads
PASS Summit 2010 Survey Results
As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit....
2010-12-23
801 reads
Filling in Data Potholes with Recursive CTEs
Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....
2010-12-23
1,155 reads
Spreading the DBA Gospel (from Old English, god spell "good news")
There are times when I wonder why I get so few comments on this blog, however there are assumptions I...
2010-12-23
765 reads
Updated SQLRally Flyer
We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...
2010-12-23
720 reads
Lunch Story #3–No Free Sandwiches
This time the plan was to go to Arby’s because it was close and my friend Rob had coupons for...
2010-12-23
564 reads
How To Choose A Topic For Speaking
“The human brain starts working the moment you are born and never stops until you stand up to speak in...
2010-12-23
1,193 reads
Strange issue while using IDENTITY values in INSTEAD OF triggers
Found an interesting issue last week....it goes like this:
If you are using INSTEAD OF triggers on views (in SQL 2005)...
2010-12-23
814 reads
Interlude: SSMS tips
Introduction
I know I said I was going to add more information about the CDC system in this post, but I...
2010-12-23
1,374 reads
Intel Sandy Bridge Processor Machines Coming Soon!
If you are in the market to buy or build a new laptop or desktop computer, you might want to...
2010-12-22
727 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
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