Presentation Slides for Modern Data Warehousing
Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas. The abstract is below. Great...
2014-05-04
1,162 reads
PROVIDING LOGGING INFORMATION AT COMMAND LINE
For providing logging information at command line utility use the option /l
for example
dtexe /f "some path" /l "logging type; connection...
2014-05-03
454 reads
Data Quality Matching in SQL Server
Every IT person is more than introduced to the problems of integration – in the ideal perfect world we could join...
2014-05-02
203 reads
Building the SQLSaturday Orlando Marketing Plan–Part 6 (Seminars)
Seminars (aka “pre-cons”) have been part of the DNA of SQLSaturday going back to #1. For those that weren’t there...
2014-05-02
490 reads
Hekaton 2014 – The Saviour vs The Lost Cause
With the release of the SQL Server 2014, Microsoft has finally unleashed their long-time in work In-Memory solution (codenamed XTP...
2014-05-02
142 reads
Sabbatical Decisions
My employer, Red Gate Software, offers a sabbatical to their employees, and this year I’m taking mine. I’ll be gone from...
2014-05-02
1,051 reads
Reblog: April 25 to May 1
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-05-02
1,259 reads
Building the SQLSaturday Orlando Marketing Plan–Part 5
More notes, many from a chat with Kendal.
We wish we could see the open rate on email and an...
2014-05-02
327 reads
Speaker of the Month, May 2014
Whoa! Another month gone by already? I guess I better pick a speaker of the month then. I went to...
2014-05-02
1,200 reads
Power Query to HDFS – Remote Name Could Not Be Resolved
I wanted to share a quick resolution I had to a problem with connecting Power Query to data stored in...
2014-05-09 (first published: 2014-05-02)
2,087 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