One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this week it was just my oldest, going on 15....
2019-01-21
16 reads
One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this...
2019-01-21
216 reads
Call for Speakers – SQLSaturday Jacksonville 2019
SQLSaturday Jacksonville 2019 is scheduled for May 4, 2019. The call for speakers closes on March 5.
2019-01-21
190 reads
Call for Speakers – SQLSaturday Tampa 2019
SQLSaturday Tampa just went live and the call for speakers is open through February 23, 2019. I’ll be attending, hope to see you there!
2019-01-21
16 reads
Call for Speakers – SQLSaturday Tampa 2019
SQLSaturday Tampa just went live and the call for speakers is open through February 23, 2019. I’ll be attending, hope...
2019-01-21
187 reads
MSSQLTips.com Rookie of the year 2018
You need a lot of hard work for success!
2018 was a good year for me in a lot of areas of my life both personal and professional (the birth...
2019-01-21
19 reads
CLR Strict Security in SQL 2017
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
The...
2019-01-21
31 reads
CLR Strict Security in SQL 2017
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
The...
2019-01-21
42 reads
CLR Strict Security in SQL 2017
Locking down CLR
I recently ran into SQL 2017’s new CLR Strict Security. I was working with a client where we...
2019-02-06 (first published: 2019-01-21)
6,694 reads
Get Your Learn On
There is one truth that I can say about technology with an absolute certainty: It’s going to change. Get your...
2019-01-21
162 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