My new course “Maintaining, Monitoring, and Troubleshooting Kubernetes” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course will...
2020-06-30
13 reads
My new course “Maintaining, Monitoring, and Troubleshooting Kubernetes” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to https://app.pluralsight.com/library/courses/maintaining-monitoring-troubleshooting-kubernetes/! This course will...
2020-06-30
43 reads
I need to write something more on this, but it struck me that this is something I wish previous employers had done, anonymously, and reported results back to others....
2020-07-10 (first published: 2020-06-29)
401 reads
One of the things I love the most about Platform as a Service offerings is the fact that it makes it so I don’t have to do silly things...
2020-07-09 (first published: 2020-06-29)
327 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-29
27 reads
It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for ... Continue reading
2020-06-29
58 reads
I’m excited to begin moving over courses from SQL Workbooks and making the material available here. The first course up for grabs is The Dirty Secrets of NOLOCK. A...
2020-07-09 (first published: 2020-06-29)
1,250 reads
Press ExpandString in Powershell This function can do much more than you think. Pester – using -should -throw Useful example when you want to filter output by ExceptionType or ErrorId....
2020-06-28
25 reads
For the past few months most of the world has been in quarantine and you may think that this is the new normal, especially now that “re-opening” has been...
2020-06-28
148 reads
I believe that language matters, and that it is worth our effort to move away from language associated with slavery and racism whenever possible. Azure DevOps doesn’t technically allow...
2020-06-26
574 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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