Backup & Restore Script with a Move
Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life...
2018-03-01 (first published: 2018-02-16)
2,347 reads
Blog Posts
Database Superhero Adventures, March 2018 Edition
I had two SQL Saturdays this month SQLSaturday Cleveland (which was very cold) and SQLSaturday Tampa (which had very nice...
2018-03-01
217 reads
Information Measurement with SQL Server, Part 3: Inverse Probability and Bayes Factors
By Steve Bolton
…………In the last segment of this series of amateur self-tutorials, we discussed how to code various ways of...
2018-03-01
962 reads
Offline installation of SQL Server 2017 on Linux
SQL Server is now compatible with different Linux distributions, and there is a lot of excitement about it.
How ever one of the main questions when ever you say SQL...
2018-03-01
48 reads
PASS Summit 2018 – Call for Speakers
It is that time again. PASS has opened the Call for Speakers. I have submitted for the past 10 years, and have been selected the past 7 years. This...
2018-03-01
17 reads
Speaking at the 2018 Techno Security and Digital Forensics Conference
One of my favorite conferences is held in Myrtle Beach, SC, in June. It’s a security and digital forensics conference which...
2018-03-01
316 reads
TDE and backup compression – still not working?
Until SQL 2016 if you used TDE (Transparent Data Encryption) you couldn’t use backup compression.
In 2016 Microsoft changed this, but...
2018-03-01 (first published: 2018-02-16)
2,403 reads
What do recruitment agents do for contractors?
WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships
Are you...
2018-03-01
380 reads
A day in the life of a Sr DBA/Dev
If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points...
2018-02-28
414 reads
A gotcha when switching partitions
When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of...
2018-02-28
3,155 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