Why make it harder than it needs to be?

Create the new server in the new DC - install SQL Server to the same patch level as your primary - add...

There are several ways to approach this...you can filter any rows that do not contain a dash, but if you have rows with additional dashes then you get incorrect results. ...

I don't know how we can help you any further - I have provided several links on how to setup the command line for dtexec.  The examples are very clear...

It is good that you are able to get the processing down to 15 seconds...but I am concerned at the cost that will have on maintenance of this solution.  The...

I think you missed the new AutoAdjustBufferSize setting - this setting should auto adjust the buffer size as needed instead of you having to figure it all out.

Looking at what...

This is really a DB2 question - from a quick search I found this int(to_char(current date - 2 days, 'YYYYMMDD')) which you should be able to adapt in your where...

Before applying a CU or SP in *any* environment - make sure you have good backups of all databases.  If you ever do run into an issue with a patch...

It still isn't clear what you are trying to accomplish - your explanation is saying you want to copy powershell to another server...why?  Powershell should already be installed on the...

This would be much better as a daily/weekly report - that you can then take action on if there are new sysadmin accounts.  There are other accounts besides sa that...

The first step would be to list the logins that are a member of the syadmin role - to get that you query sys.server_principals and sys.server_role_members:

 Select...

It is not clear what your expected results are - can you show what you expect given the example data you provided?

What are the batch/commit settings on the destination?  If those are default - set them to a reasonable amount and see if that improves the performance any.  In some cases...the...

You are aware that you can create an agent job that runs in the powershell sub system?  Using that - you can easily setup a job to run on a...

Either works - I guess...but then again I have SSISDB and that has changed a whole lot of the requirements for config files/tables.  In fact - moving to a project...

Not sure why you are 'copying' powershell to another server - Powershell is a command line utility that should be installed on the servers and updated to the version you...