Updating SSMS to 17.9.1
I went to download the SSMS v17.9.1 package the other day and saw this:
I remember some issues with a C++...
2018-12-03
1,002 reads
Database Fundamentals #20: Using the JOIN Operator, Inner Join
It is entirely possible to try to JOIN two tables on almost any field, as long as the two data...
2018-12-21 (first published: 2018-12-03)
2,524 reads
Where do data breaches come from?
I recently did a bit of research on the source of data breaches. In this post, I’ll talk a bit about my current favorite source for breach information, and...
2018-12-03
32 reads
SQL Homework – December 2018 – Configure SSMS
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...
2018-12-03
207 reads
SHUTDOWN SQL Server
I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly...
2018-12-03
20 reads
SHUTDOWN SQL Server
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server....
2018-12-20 (first published: 2018-12-03)
3,601 reads
Deadlocks in a SQL Server Database
Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...
2018-12-18 (first published: 2018-12-03)
3,245 reads
Epic Life Quest – looking back
This will be my last post for the year. In this am going to look back on goals I set...
2018-12-03
736 reads
Three tips to help your database team avoid burn out this holiday season
As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of the busiest and most stressful times of the year...
2018-12-03
29 reads
Three tips to help your database team avoid burn out this holiday season
As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of...
2018-12-03
371 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