All about Searching - Full-Text Indexes
SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...
2016-04-14 (first published: 2016-04-08)
1,951 reads
MDF File Password Confusion
I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post...
2016-04-07
613 reads
MongoDB -Get Size, RowCount, CollectionSize
There are two different ways of getting the desired result
The first method is iterating through each collection using for loop...
2016-04-07
329 reads
SSC Editorial: Would You Move for a Job?
I won’t say never, but it’s unlikely I’d move for a job – my roots are here in Orlando and I...
2016-04-07
450 reads
Announcement: Backup(n.) vs Back Up(v.)
Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it...
2016-04-07
525 reads
FIND OBJECTS BEING REFERRED BY SSRS REPORT
Hi Everyone
In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...
2016-04-07
1,559 reads
All about Searching - Full-Text Indexes
SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...
2016-04-07
1,881 reads
Cloud Backup - Directly to Azure
Backup is one of the major task for DBAs, it has many different options and ways for each companies to...
2016-04-07
1,643 reads
Quick Encryption with Always Encrypted
What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted?...
2016-04-06
836 reads
MongoDB – Local and Remote Connections in Mongo Shell
To Install and Getting started with MongoDB refer the below links
Getting Started with MongoDBInstall MongoDB 3.2 on WindowsInstallation Guide
How to...
2016-04-06
527 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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