Renewed as Microsoft MVP for 2020-2021
I have been fortunate enough to be renewed as a Microsoft Data Platform MVP for the calendar year July 2020 to June 2021. I’m honored, humbled, and thrilled that...
2020-07-17
47 reads
Technobabble by Klee from @kleegeek
VM firmware matters for Windows Secure Boot
The Register is reporting that future versions of Windows Server OS is going to require the TPM 2.0 chip and Secure boot enabled by default. Secure boot is quite...
2020-07-02 (first published: 2020-06-23)
220 reads
Podcast recording with Dallas DBAs
I’m thrilled to have recently recorded a podcast with Kevin3NF of Dallas DBAs called Data Bits. I had an absolute blast with it, and we laughed for over an...
2020-06-18
19 reads
Packet Pushers Podcast released
I am thrilled to have recently recorded a podcast with our friends over at PacketPushers. The podcast, “How an IT Specialist Chooses Adjacent Competencies“, talks about how adjacencies in...
2020-05-26
19 reads
What are you tuning for?
People want to make things faster. It’s in our nature as IT professionals. What are you tuning for? I’ve been asking that a lot later. I have to sit...
2020-06-04 (first published: 2020-05-22)
341 reads
PASS Summit 2020 Precon Announcement
I am thrilled to announce that I have been accepted to deliver a preconference boot camp called ‘Amplify Your Virtual SQL Server Performance‘ at this year’s PASS Summit conference,...
2020-05-18
29 reads
Clumio’s Rapid Recovery is amazing for SQL Server
Clumio’s Rapid Recovery is amazing, and you should know more about it. You might not have heard of Clumio before. Clumio is an upstart SaaS-based backup solution for both...
2020-05-15 (first published: 2020-04-30)
387 reads
Upcoming Webinar – SQL Server Business Continuity – May 21
I’m proud to announce a new webinar that I’ll be presenting at 1pm Eastern on Thursday, May 21st, in conjunction with MSSQLTips and SIOS called “SQL Server Business Continuity...
2020-05-12 (first published: 2020-04-29)
131 reads
Presenting at Global Azure Virtual Day 2020 Omaha
I’m thrilled to be presenting along side of some industry greats at the upcoming Global Azure Virtual Day on April 25th as part of the Omaha users group. The...
2020-04-16
18 reads
SQL Server and CPU Hyper-Threading in Virtual Environments
I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains. Hyperthreaded CPU cores, or logical cores, should not be...
2020-04-21 (first published: 2020-04-10)
1,632 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