DELETE data on SQL Server HEAP table – Did you know…
Before I complete my question let me provide context. I've received an alert saying that a specific database could not...
2017-10-04 (first published: 2017-09-26)
2,703 reads
Blog Posts
Enabling Database Containment for an Instance – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-04
605 reads
Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .
Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...
2017-10-04
319 reads
How the gym made me a better database bloke…..
A blog post about how many reverse bicep curls or Romanian DeadLiftsI can do…? As Rob Farley (t | b | w)...
2017-10-04
495 reads
Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster Recovery (DR), load balance your applications or any other...
2017-10-04
33 reads
Limiting resources available to containers
One question that I get asked regularly is, “can you limit the host resources to individual containers?”
This is a great...
2017-10-04
465 reads
Policy Based Management and Powershell
Introduction
Policy Based Management (PBM) can be used to inform DBAs when an incorrect setting is being used on a SQL...
2017-10-04 (first published: 2017-09-26)
2,025 reads
SQL Sequence vs Identity Column
Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you...
2017-10-04
5,263 reads
The Alpha and the Omega. The BEGIN and the END.
The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do...
2017-10-04
954 reads
What Do You Get if You Unpack an Ispac?
I’ve spent what feels like a lifetime working on automating SSIS deployments, more specifically SSIS packages that have been created...
2017-10-04
2,882 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