Fun Time Friday: Black Friday, Mad Friday, Frantic Friday or Black Eye Friday
Black Friday (No,not Shopping!), Mad Friday, Frantic Friday or Black Eye Friday is a nickname for the last Friday before...
2018-12-21
183 reads
MongoDB – DBs and Configurations
Continue to our last discussion , today we will be discussing on MongoDB default databases and more… When you install mongoDB...
2018-12-21
221 reads
Encrypting a Database Never Finishes
There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a database. In SQL Server, we have the ability to...
2018-12-20
20 reads
Encrypting a Database Never Finishes
There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a...
2018-12-20
400 reads
Restarting a Sequence–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-20
1,063 reads
Personal Touch: An Argument Against Automation
At the far end of an out-of-the-way aging strip shopping center in southern Louisiana, there stands a small and modest sushi restaurant. The exterior could be described as tasteful...
2018-12-20
24 reads
Personal Touch: An Argument Against Automation
At the far end of an out-of-the-way aging strip shopping center in southern Louisiana, there stands a small and modest...
2018-12-20
219 reads
T-SQL Tuesday Participation Over the Years
I have personally participated in quite a large number of these TSQL Tuesday events - despite not being every single one. This is a roundup of my personal participation...
2018-12-19
12 reads
T-SQL Tuesday Participation Over the Years
Loads of TSQL Tuesdays
Years ago the TSQL Tuesday party was started by Adam Machanic (b|t). The premise of the monthly event...
2018-12-19
236 reads
Infrastructure matters, even in the Cloud
I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK...
2018-12-19
286 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