Colorado SQL Events for May 2014
SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2014-04-29
1,541 reads
Most important feature of SQL 2014
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,685 reads
Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,520 reads
Building the SQLSaturday Orlando Marketing Plan–Part 2
Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342....
2014-04-29
1,297 reads
Building the SQLSaturday Orlando Marketing Plan–Part 2
Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342....
2014-04-29
1,367 reads
Back to Work
After surgery Fri am, I’ve been mostly taking it easy, but now it’s back to work. Got kids to school...
2014-04-29
1,435 reads
Speaking At the Pinellas SQL Group on August 18, 2014
I’ve committed to presenting but haven’t decided on the presentation yet. It will probably be a remote presentation because it’s...
2014-04-29
1,270 reads
Installing and Configuring Active Directory in Window Server 2012
Hello Friends,
Sometimes life is so uneasy that you didn’t get time for the work which you like the most. Now...
2014-04-29
1,892 reads
SQL Server Quickie #13 – Hash Join Operator
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-29
1,832 reads
What is a Non-Clustered Columnstore Index?
First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...
2014-04-29
5,632 reads
Blogs
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...
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
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