All about PASS Summit 2019
Here are the things you must/should probably know about PASS Summit 2019, as told by me. Included: Advice for first timers Prioritized schedule at a glance Sessions we recommend...
2019-09-23
46 reads
Database Fundamentals #22: Using the Join Operator, CROSS JOIN
While the CROSS JOIN is not used much, and, depending on the size of your data it can be dangerous, there are some uses for it. For example, you...
2019-10-03 (first published: 2019-09-23)
1,043 reads
Automate Your SQL Notebooks with Two New Options
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-09-23
4 reads
Automate Your SQL Notebooks with Two New Options
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-09-23
72 reads
Automate Your SQL Notebooks with Two New Options
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-10-02 (first published: 2019-09-23)
815 reads
Debugging techniques (focusing on T-SQL)
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: ... Continue reading
2019-10-07 (first published: 2019-09-23)
847 reads
SQL Change Automation v4 Puts Migrations in SSMS
I’ve been waiting for this a long time. Over the years, as Redgate has improved and changed the SQL Change Automation product in Visual Studio, I’ve been wanting to...
2019-09-23
72 reads
Using the SSIS Term Extraction for Data Exploration
Data exploration is an essential piece of any new ETL (extraction-transformation-load) process. Knowing the structure, type, and even the semantics of data sources can help the ETL developer or...
2019-10-01 (first published: 2019-09-23)
414 reads
Origem Flash Headphone Sale
I reviewed a set of wireless headphones this summer, and I continue to use them when traveling. They work well for me and have good battery life. The company...
2019-09-23
25 reads
Troubleshooting NUMA Node Imbalance Problems
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-09-23
206 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