Workaround Primary Key Violations in SSIS
Before you get much further, please do not use this for every case where you have issues with duplicate rows....
2008-11-26
1,524 reads
Surface Demo
Second try. The video didn’t embed in the previous post. Nor this one. Here's the link
Microsoft Surface Demo
This is from...
2008-11-26
1,439 reads
Surface Possibilities
This is interesting. I’m not sold on Surface, though I did play with one last week in Seattle.
2008-11-26
1,396 reads
Spend Money to Make Money
One of those old sayings that has a grain or two of truth to it. Stocks, real estate, education even,...
2008-11-25
1,564 reads
Airlines Don't Care About Customers? Nor Does The Government!
I saw this post about a recent panel that tried to come up with guidelines for airlines as far as...
2008-11-25
1,398 reads
Catching Up
My goal of 400 posts a month has been in jeopardy with all the traveling I've been doing over the...
2008-11-25
1,486 reads
PC Magazine Going out of Print
Saw a post from Michael Miller that PC Magazine will end it's print version with the January issue. Have to...
2008-11-25
1,544 reads
The Advantage of Seattle - Where to host the PASS Community Summit
I heard during last week that the 2009 PASS Community Summit will be back in Seattle, on Nov 3-6 next...
2008-11-25
1,571 reads
Digging into Replication
It's fun to read good work, and my friend Kendal Van Dyke recently posted How CommitBatchSize And CommitBatchThreshold Affect Replication....
2008-11-24
1,419 reads
Raising the Bar
Turning up the heat. Take it up a notch. Stepping up to the plate. Less talk, more action.
However you choose...
2008-11-24
1,646 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...
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