SQL Saturday Albany NY 2019
I am pleased to announce that I will be presenting at SQL Saturday #855 in Albany, NY on July 20, 2019. Join me at 2 PM in room LC05...
2019-07-08
14 reads
FLX SQL
dbatools One Point OH YEAH!
Announced at DataGrillen 2019 today, the amazing dbatools PowerShell module has officially released version 1.0. This is a tremendous milestone for the best Open Source project built for data...
2019-06-20
15 reads
dbatools One Point OH YEAH!
Announced at DataGrillen 2019 today, the amazing dbatools PowerShell module has officially released version 1.0. This is a tremendous milestone for the best Open Source project built for data...
2019-06-20
24 reads
T-SQL Tuesday #113 -A Database for the Great Outdoors
This month’s T-SQL Tuesday comes from Todd Kleinhans (blog | twitter) who wants to know what we’re doing with databases outside of work.
I’m curious- outside of work and...
2019-04-09
22 reads
T-SQL Tuesday #112 - The Cookie Jar
This month’s T-SQL Tuesday comes from Shane O’Neill (blog | twitter). He starts us off with this:
Dipping into the Cookie Jar is about when the going gets tough and...
2019-03-12
19 reads
Speaking
A place to collect abstracts & links to presentations I’ve given. Please be sure to check out my Sessionize profile as well.
Backup Basics with PowerShell and dbatools Abstract As...
2019-03-09
10 reads
Speaking: Rochester SQL Server User Group March 2019
Probably a bit late getting this posted but I will be speaking at the March 5, 2019 meeting of the Rochester SQL Server User group (RSVP link). I don’t...
2019-03-04
5 reads
One Peril of Database Proliferation
By now many of us have upgraded from SQL Server 2008R2 and we’re on the “regular Cumulative Updates” train now. For the rest, it’ll (hopefully) happen soon. And since...
2019-02-26
20 reads
Appearance: SQL Data Partners Podcast #161
Carlos Chacon (twitter) was kind enough to have me back on the SQL Data Partners Podcast to talk about my experiences with managing 8000 databases on a single instance...
2019-02-21
20 reads
Tidier PowerShell Scripts with Default Parameter Values
I was recently working on a PowerShell script to set up some new databases for my users and found myself writing the same things over and over again.
1 2...
2019-02-04
30 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, 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