We can agree to disagree - but let me ask you this: How can you determine which entry in your table was entered in New York - and how do...

I selected what was provided as the 'correct' answer - but I disagree that is the correct answer.  For a system dealing with multiple time zones - you actually want...

You asked how to use WinSCP in SSIS - the assumption would be that you are currently using WinSCP manually to synchronize the folders.  Is that correct?

My next...

This means removing the database from the AG, and shrinking the log by whatever means necessary,...

FWIW - I backup a 6TB+ database every night in less than 2 hours.  That process backs up to a local drive - then copies the file...

I would recommend using Robocopy - it can be called from a PS script and there are many possible parameters to fit almost any requirement.

The output from Robocopy also provides...

A couple more points:

1. SQL Server cannot truncate the log on the primary until the transaction has been hardened on the secondary.  If either the send queue or redo queue...

SQL Server cannot truncate the log until after the backup completes - because that is the last phase of the backup process.  Once the database has been backed up, SQL...

The recommendation is to not have more than 8 tempdb files - unless you are specifically seeing contention.  You can start here: https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce-allocation-contention

I see a further problem - the files obviously have timestamps associated with the file.  Processing them in 'any order' could be problematic if there could be actions/updates for the...

You don't really need SSMS to be able to get a copy of that package - it depends on how it was deployed.  For 2008 deployments you could deploy to...

To the specific question - yes, setting a commit size and batch size will reduce the impact on the transaction log and allow the log to be truncated.  Whether or...

Here is something that rubs me on a daily basis:

I hate sprinkling my code with RAISERROR just for the sake of printing status messages, because it's ugly and confusing...

Along the same lines, what techniques do people use to inject commas into, say, @@ROWCOUNT vs the FORMAT statement - FORMAT( @@ROWCOUNT ), '###,###,###,##0' ) AS RowCount

I still find...

You asked how to use WinSCP in SSIS - the assumption would be that you are currently using WinSCP manually to synchronize the folders.  Is that correct?

My next question would...