Notes From SQLSaturday South Florida
Notes from the trip:
Four hour drive between traffic and rain, about an hour longer than I would have liked. The...
2014-06-16
451 reads
I Gotta See the Code–Question of the Day
I Gotta See the Code is a security question about viewing the code to a stored procedure. Two points if...
2014-06-16
572 reads
Reflections On Fathers Day
Fathers Day coincided with the family vacation this year and maybe more than some years I had the time to...
2014-06-16
530 reads
Last Weeks Top “Reading” Links #88
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-06-16
1,580 reads
What I Love About SQL Server
Well, there are many things I love about SQL Server. Otherwise, I wouldn’t spend my whole career around it, would...
2014-06-16
554 reads
I don’t want to grant permission to all the tables in the database at once.
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...
2014-06-16
1,169 reads
ColumnStore Indexe with SQL Server 2012 & 2014
ColumnStore Indexes (Run By Microsoft’s VertiPaq technology) as described by BOL (http://msdn.microsoft.com/en-IN/library/gg492088(v=sql.110).aspx) :
“An xVelocity memory optimized ColumnStore index, groups and...
2014-06-16
2,396 reads
Come see me in Baton Rouge Aug 2nd!
I've been accepted for SQL Saturday Baton Rouge!
Yes, I am a little excited. I've wanted to become a speaker for...
2014-06-16
524 reads
Script, store and transfer data using XML, XQuery and clipboard
When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...
2014-06-17 (first published: 2014-06-15)
3,623 reads
Book Review: Why You Should Read Expert Cube Development With SSAS 2012 Cover to Cover
Expert Cube Development with SSAS 2012 Multidimensional Models was published earlier this year by Packt Publishing. It’s the second edition...
2014-06-15
842 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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