Be Nice
Years ago when I was just out of the Marine Corps and found myself as the only IT guy in an...
2014-02-19
446 reads
Windows 2012 for the SQL DBA: .NET 3.5 Fails to Install
Hello Dear Reader! I know it has been a while since last we spoke. Sorry for the long absence. I've...
2014-02-19
848 reads
Taxonomy of Data Scientists
The 10 pioneering data scientists listed here were identified as top data scientists in our previous article entitled data science...
2014-02-19
472 reads
If You Plan to Publish A SQL Script–Some Suggestions
Nothing better than finding a script that does something you need done and often done better than what you’d put...
2014-02-19
732 reads
Getting a query plan
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware...
2014-02-19
1,504 reads
6000 Companies Hiring #DataScientists
“Search engines (Google, Microsoft), social networks (Twitter, Facebook, LinkedIn), financial institutions, Amazon, Apple, eBay, the health care industry, engineering companies...
2014-02-19
456 reads
Data Scientist versus Data Architect
I recently had the following discussions with a number of data architects, in different communities, in particular (but not limited...
2014-02-19
1,591 reads
Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues
I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby the “sa” account kept being locked out. In scenarios...
2014-02-19
2,773 reads
Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues
I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby...
2014-02-19
3,504 reads
T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made. At close, we saw 17...
2014-02-19
9 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