Why is the SQL Service account...

I think there shouldn't be time zones, let alone DST. The entire globe should be Noon, as an example.  Pick a time zone, and the whole world can follow it.

You...

$File = "C:\CostLoads\Book1.xlsx"
$Instance = "xxxxx"
$Database = "DBA_USAGE"

$fileName =  [System.IO.Path]::GetFileNameWithoutExtension($File)

foreach($sheet in Get-ExcelSheetInfo $File)
{

$data = Import-Excel -Path $File -WorksheetName $sheet.name | ConvertTo-DbaDataTable
$tablename = $fileName + '-' +...

Initialize from a backup, which is usually far faster than a snapshot.

On an semi-related note. How many publications do you have?  Have you considered creating multiple publications?

Such as:

1. Static tables,...

Seriously, it sounds like whatever option you choose will be a lot of work.

Maybe it's time to do it with three separate columns.  You can add the three columns to...

Using the code below, we did not raise an error.

If [dbo].[IsPrimaryInAG](agname) = 1 Begin

Execute job

End

I guess what are you trying to find out by raising an error?

/******...

It depends upon the requirements and need.  Clustering requires shared...

Not always. If you have a read only secondary, you will need to license the...

I do not have a recommendation.  But this may be a better question to pose on a site like Toms Hardware or something similar.

Instead of raising an error, simply test if the server is the active node.

Unless you create your own script to test for the existence of a full backup prior to the log backups, Maintenance Plans have n0thing that does this.

The question is why...

As you have not provided the logic for your 'business month end' calculation, I'm not sure how you are expecting anyone to calculate it.

EOMONTH() gives you end of...

You examples are not duplicate rows.  The fact that the Notes column is different in each row makes each row unique.

Your expected results removes all of the rows where the...

I have a problem where I intend the following on a Transactional Replication with a Push subscription;

1 - 10 rows were inserted into Table 1 on Publisher. I want...

I have a problem where I intend the following on a Transactional Replication with a Push subscription;

1 - 10 rows were inserted into Table 1 on Publisher. I want...