Don't Use Delimiters In Your Object Names!
It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file...
2016-04-04
2,287 reads
MongoDB – Calculating Document Size
We can get the size of a document is by using the shell’s Object.bsonsize() function.We pass the object_id of the document...
2016-04-04
539 reads
#SQLNewBlogger–Adding Local Accounts
What do you do if you need a process running under Local Service to connect to your SQL Server? Most...
2016-04-04
652 reads
Monday Morning SQL Break – April 4, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-04-04
465 reads
Complex/Conditional ORDER BYs
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
485 reads
Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-07 (first published: 2016-04-04)
7,639 reads
SSC Editorial: Is Powershell Intimidating?
Is Powershell intimidating? It’s an interesting question, though perhaps unfair – TSQL can be intimidating when you first start out too....
2016-04-04
528 reads
Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-04
221 reads
How to Load XML Data Files using the SSIS Script Component.
One of the common source data files that every ETL Developer/Architect will have to grapple with every now and then...
2016-04-03
17,857 reads
Speaking at SQL Saturday #487 in Ottawa on April 16, 2016
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-03
475 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