Consultants: Corp-to-Corp vs 1099
I blogged previously that when you are a consultant or contractor, you can sometimes be faced with the decision when...
2012-04-11
5,568 reads
How To Live Blog an Event
As the euphoria of SQLBits X sadly begins to fade, I wanted to take a moment to share with you...
2012-04-11
1,066 reads
Limiting user access to your database
There are situations where you need to grant SELECT permission to a particular user and limit that access to a...
2012-04-11
2,525 reads
SQL Server – default trace FAQ
Has someone deleted a table?
Are you trying to track auto grow events? Problem scenarios such as Database autogrow and slow...
2012-04-11
1,062 reads
Top 3 Reasons Why Evernote is worth $1 billion to me
Everyone heard about Facebook’s recent purchase of Instagram for $1 billion dollars. No one can imagine how they came with such...
2012-04-11
894 reads
A Tale of Four Laptops
With the release of the 22nm Ivy Bridge microarchitecture less than three weeks away, at the end of April 2012,...
2012-04-13 (first published: 2012-04-10)
3,217 reads
T-SQL Tuesday #029 – SQL 2012 and Treating TempDB like it’s really Temporary.
A while back, my young son thought it would be fun to use a CD as a virtual surfboard on...
2012-04-10
1,582 reads
X on XMLA: iii. Basic DDL Functions in XMLA (Create, Alter, Delete)
XMLA can be used to manage the structure of your multidimensional databases. While many developers use Visual Studio (BIDS), to...
2012-04-10
723 reads
T-SQL Tuesday #029 – Useful Feature of SQL Server 2012
This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he...
2012-04-10
1,623 reads
Simple Tips To Speed Up Your SSIS Data Flow
There are a few design choices that can make your SSIS packages run super fast when loading data from table...
2012-04-10
5,627 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