Taking #PowerPivot to the Next Level
Power Pivot is an amazing, flexible and powerful business intelligence tool (among other things) and there is no doubt about...
2015-08-26
1,057 reads
The Log Chain
I ran across a question recently from someone that received a similar message to the one showed in this image:
In...
2015-08-25
1,281 reads
Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)
As I noted in my previous post, I am not a fan of scripting. In that post we set up...
2015-09-04 (first published: 2015-08-25)
1,313 reads
SQLSaturday & The Speaker Wait List
When a new SQLSaturday event is launched an email is sent to all the speakers who have opted in to...
2015-08-25
640 reads
Assigned reading: FREEPROCCACHE
I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one...
2015-08-25
658 reads
Automatic Roll Forward Transaction Log Backups
Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore...
2015-09-03 (first published: 2015-08-25)
2,577 reads
Query cost and Query Execution time - Difference
This post is my 100th post 🙂 Was inactive in blogging for few years in between. Now back in full flow....
2015-08-25
1,493 reads
Outlier Detection with SQL Server, part 7: Cook’s Distance
By Steve Bolton[
…………I originally intended to save Cook’s and Mahalanobis Distances to close out this series not only because the...
2015-09-03 (first published: 2015-08-24)
2,079 reads
Compressing Outcomes
Find yourself struggling to determine the outcome of attempted compression settings in your database? This should help!
Related Posts:
Failed to Create the Audit File December 31, 2017
Disk Space and...
2015-08-24
11 reads
Compressing Outcomes
You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a...
2015-08-24
720 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