This blog post is about the situation where after upgrading to the latest macOS version 10.15 – also known as Catalina – you may not be able to share...
2019-10-18
73 reads
If you are at involved with the #sqlfamily, you are bound to hear about the benefits of social media platforms such as Twitter. Twitter helps us to engage each...
2019-10-31 (first published: 2019-10-18)
365 reads
This is the eight interview we have done. This time our guest is the one and the only Bob Ward! Bob Ward is a Principal Architect for the Microsoft...
2019-10-18
41 reads
This is the eight interview we have done. This time our guest is the one and the only Bob Ward! Bob Ward is a Principal Architect for the Microsoft...
2019-10-30 (first published: 2019-10-18)
399 reads
I am living the dream, y’all: yesterday I was finishing up my workday and needed to record a video, but realized that our puppy had spent enough time in...
2019-10-17
29 reads
This year at the PASS Summit, Redgate is holding our SQL in the City Summit as one of the pre-con events at the conference. You can add this in...
2019-10-17
17 reads
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks! You can download the latest insiders edition from the link above,...
2019-10-17
25 reads
In the previous blog post I did a quick overview building a SQL VM (imaged) in Azure. It is now time to clarify some backup techniques because it can...
2019-10-17
58 reads
It has been a little while but I have updated SQLCover to include a number of fixes and small features, the majority of which are improvements to the html...
2019-10-16
15 reads
It has been a little while but I have updated SQLCover to include a number of fixes and small features, the majority of which are improvements to the html...
2019-10-30 (first published: 2019-10-16)
421 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