Daily Coping 9 June 2020
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-09
37 reads
T-SQL Tuesday #127 – Non SQL Tips and Tricks, Referencing Multiple PowerShell Array Elements
This month’s T-SQL Tuesday invitation is from Ken Fisher and he’s asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into...
2020-06-23 (first published: 2020-06-09)
358 reads
The Azure Portal search bar : T-SQL Tuesday #127
Happy T-SQL Tuesday! Number 127. Wow. Over 10 and a half years. Talk about incredible. I’m actually hosting this time ... Continue reading
2020-06-09
82 reads
T-SQL Tuesday #127–Non SQL Tricks
Today is T-SQL Tuesday, with this month being hosted by Ken Fisher. This is an interesting topic, looking at tips, but ones outside of SQL Server. Since many of...
2020-06-09
121 reads
Tips and Tricks Azure Databricks
It has been a while since I posted an entry for TSQL Tuesday, which, for today is hosted by Kenneth . The subject being a non SQL Server tip. For...
2020-06-09
227 reads
T-SQL Tuesday #127 - Non-SQL Tips & Tricks
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Kenneth Fisher (blog | twitter) asks us for non-SQL tips &...
2020-06-09
29 reads
TSQL Tuesday 127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
20 reads
TSQL Tuesday #127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
20 reads
Social: A Small Step to Address Poor Past Behavior
Tl;Dr – This is about changing your main branch in git to main. However, please read and think about what I am saying here. When I started working with...
2020-06-08
57 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
19 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