Validating Cluster Instance Owner with Powershell
A few weeks ago, for TSQL Tuesday, I wrote about how I used Powershell to manage failing over clusters. At work,...
2015-07-17
1,019 reads
Murder and XE Train in Louisville
Bringing years of experience together in two all day workshop sessions.
Related Posts:
Seattle SQL Pro Workshop 2017 October 19, 2017
Finding Installed Event Sessions December 31, 2018
Sharepoint Diagnostics and...
2015-07-17
7 reads
Murder and XE Train in Louisville
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2015-07-17
860 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a...
2015-07-17
7 reads
SQL Server: utilize partitioning to purge large tables
Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables...
2015-07-17
3,601 reads
Speaking next Wednesday July 22nd, at Vermont SQL PASS group, thanks to Roman Rehak? for the invite!
Speaking next Wednesday, Vermont SQL PASS group, thanks to Roman Rehak? for the invite! http://www.meetup.com/VTCode/events/223946011/
I'll be doing an update to...
2015-07-17
746 reads
Introduction To Query Store In SQL Server 2016 – Part 2
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,115 reads
How do different types of functions compare performance wise?
A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement...
2015-07-16
1,092 reads
SSC Editorial: Is the Golden Age of Information Technology Almost Over?
Posted last week, Is the Golden Age of Information Technology Almost Over? generated some interesting comments. It’s tough to write about potential...
2015-07-16
548 reads
Next oPASS Meeting is July 23, 2015 with David Crook
The next OPASS meeting is July 23, 2015, featuring David Crook from Microsoft doing a presentation on predicting home value...
2015-07-16
550 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