Database Deployment in DevOps One of the many obstacles to database development and DevOps is how to deploy databases consistently and how to automate the process. Database deployments have...
2018-02-12
65 reads
Kronothon2.0 – The only difference between Success and Failure is one’s attitude.
Register here to win cash prizes up to 5 Lakhs...
2018-02-12
471 reads
A little out of my area, but I need to move the tsqltuesday.com database to a new service. The company...
2018-02-12
874 reads
(last updated: 2018-06-05)
This post is, for the most part, a continuation of Server Audit Mystery 1: Filtering class_type gets Error...
2018-02-12 (first published: 2018-01-30)
3,297 reads
Version 4.1 of SQL# has just been released!
New functionality available only in Full version
Sys_LockResourceReturns the name of the specified Lock...
2018-02-12
1,347 reads
I’ve been working in the field of business intelligence for over ten years, as a consultant for over five years....
2018-02-12 (first published: 2018-01-30)
2,772 reads
The SQLUndercover Inspector is now available on GitHub, a quick run down of what it does can be found here:...
2018-02-11
1,041 reads
Hello everybody!
I have been working with one of my favorite clients lately on migrating their SQL databases to a DBaaS...
2018-02-10
160 reads
I love VS Code. I love being able to press ALT + SHIFT + F and format my code.
The Problem
Yesterday all I...
2018-02-10
490 reads
Last month in January, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by...
2018-02-09
135 reads
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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