Presenting for Omaha SQL Server Users Group Dec 4
I’m proud to announce that I’ll be presenting an updated session entitled “Level Up Your Cloud Infrastructure Skills” for the Omaha SQL Server Users Group on December 4th at...
2019-12-02
23 reads
Technobabble by Klee from @kleegeek
Omaha Azure User Group Presentation Nov 18
I’m happy to announce that I’ll be presenting an in-person session for Omaha’s Azure Users Group on Monday, November 18 at 3:00pm, entitled “SQL Server in the Microsoft Cloud“....
2019-11-09
27 reads
Renewed as Microsoft MVP 2019-2020
I are thrilled to announce that I has been renewed for the sixth time as a Microsoft Data Platform MVP for 2019 to 2020. The MVP award remains incredibly...
2019-07-09
13 reads
Speaking at PASS Summit 2019
I am proud to announce that I am presenting at this year’s PASS Summit conference, to be held in Seattle WA from November 5th to 8th at the Washington...
2019-06-25
12 reads
SQL Server Large Memory Pages
SQL Server Enterprise Edition can leverage large memory pages to reduce the amount of memory pointers required for larger SQL Server deployments. Reducing the number of pointers makes the...
2019-05-20 (first published: 2019-05-06)
514 reads
Discount Code for SQL Saturday Atlanta 2019 Precon
We have a discount code for last-minute attendees looking to go to our exciting preconference training session at this year’s SQL Saturday Atlanta on May 17th, 2019, called “Level...
2019-05-01
24 reads
SQL Saturday Atlanta Precon May 17
I am very proud to announce that I have been selected to present an exciting preconference training session at this year’s SQL Saturday Atlanta on May 17th, 2019, called...
2019-04-17
25 reads
VMware vExpert for 2019
I’m honored and humbled to be awarded the VMware vExpert award for the seventh year in a row! Thank you...
2019-03-08
311 reads
The Top 4 Data Technology Trends Every DBA Should Know About in 2019
Join Sentry One, Kevin Kline, and me in an exciting (and laugh-filled) panel session this Wednesday, January 9th, at 2pm...
2019-01-07
46 reads
SQL Bits Precon 2019
I am extremely happy to announce that I’ll be presenting a preconference training session with Bob Pusateri at this year’s...
2019-01-07
267 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