Post Deploy Scripts In Composite Dacpac's not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
815 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy into a database as a whole. Even if you...
2016-03-03
8 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
46 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
39 reads
VMware CPU Co-Stop and SQL Server Performance
Not too many people know about the intricacies of virtualization CPU scheduling and its impact on the performance of the VMs,...
2016-03-09 (first published: 2016-03-03)
1,496 reads
How to Grant Permissions Only on the Replica in Database Mirroring and AlwaysOn AG
You work with Database Mirroring or AlwaysOn AG, and you want to make sure your end users work only on...
2016-03-03
312 reads
Find failed SQL Job in last 24 Hours using Powershell
This post is based on the request to get failed SQL jobs in last 24 hours and output should be...
2016-03-02
673 reads
Rebuild of the System databases on Stand-alone and Failover Clustered SQL Server
The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is...
2016-03-02
244 reads
Sessions submitted for major conferences 2016. Topics: Security – Performance – In-Memory
Vorträge für die großen Konferenzen 2016 eingereicht. Themen: Sicherheit - Performance - In-Memory
(DE)
Nach dem tollen Verlauf der deutschen SQLKonferenz im Februar,...
2016-03-02
540 reads
Rebuilding the system databases
The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is the same – https://msdn.microsoft.com/en-us/library/dd207003.aspx. When you install a SQL...
2016-03-02
28 reads
Blogs
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