Deactivate SQLTreeo license
Version SQLTreeo SSMS Add-in version 0.8.4 or higher. Purpose Deactivate a SQLTreeo license when your workstation is unavailable. SQLTreeo is...
2017-10-19
142 reads
Blog Posts
Let Her Finish: Voices from the Data Platform
This year I had the pleasure of contributing a chapter to a book along with some very special and talented...
2017-10-19
623 reads
Seattle SQL Pro Workshop 2017
Free workshop on SQL Server leading up to Summit 2017 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2017-10-19
5 reads
SQL Data Generator–Getting a value based on another column
This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...
2017-10-19
1,446 reads
SQL Server Temporal Tables
Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level...
2017-10-19 (first published: 2017-10-11)
2,106 reads
SQLSaturday Orlando 2017 Notes – Part 1
Part 1 will be about things we did (or didn’t) do and some lessons learned. In Part 2 I will...
2017-10-19
435 reads
Where do you install tSQLt?
The question of where to install tSQLt is probably the most common question I get when I talk about unit testing T-SQL, so much so that I thought that...
2017-10-19
8 reads
Where do you install tSQLt?
The question of where to install tSQLt is probably the most common question I get when I talk about unit...
2017-10-19
87 reads
Where do you install tSQLt?
The question of where to install tSQLt is probably the most common question I get when I talk about unit...
2017-10-19
733 reads
Where do you install tSQLt?
The question of where to install tSQLt is probably the most common question I get when I talk about unit...
2017-10-19
64 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