no difference from a performance point of view - backup and restore is still done on the same server, and copy of bak file still happens between the same servers.

however...

Most was said already - I have gone an extra step with one of our teams and I have DDL triggers that prevent developers from using 3/4 part names in...

To check elapsed timer the developers can implement a timer variable - stop timer, stop timer and then get elapsed time - example https://docs.microsoft.com/en-us/dotnet/api/system.timers.timer?view=netframework-4.8

But timer may not help here depending...

For your needs i would probably stay out of the gaming laptops and go for the more "normal" ones https://www.newegg.com/p/pl?N=100006740%204814%20600337010%20601331008%20601311244%20600488336%20601323887%20601303722%20600004945%20600004946

This one for example looks better than the one you mentioned...

one possible way is to use robocopy - you can set multithread copy (for performance) and you can also set parameters to copy only newer or modified files - you...

Also take in consideration that if the non prod servers have a "free" SQL License on that UAT server  e.g. developer edition or MSDN licensed editions  then whatever data is...

you can't prevent the trigger from executing but you can control what it does by looking at the event data and filtering if the command is a create snapshot one

within...

when using linq using https://www.linqpad.net/ is a must - with it you can see what SQL will be generated

within your c# code you can also see what is the sql...

it is the the user running the sql instance that needs access to the share (or a proxy if enabled and if you are using xp_cmdshell to do the load)

have a look at Dbatools - probably has what you need https://dbatools.io/commands/

to publish to a Local  Server you need to use Power Bi Report Server https://powerbi.microsoft.com/en-us/report-server/

Note that this is a licensed piece of software which you can use if you have...

perfectly normal. 2005 install knows nothing about the higher versions and gets confused. possibly doing a alpha compare of "9.0" vs "12.0" and 1 is less than 9.

but why in...

error is basically stating that you can not populate the destination column with itself

MyOutputBuffer.AddRow();

MyOutputBuffer.PersonID = MyOutputBuffer.PersonID;

should be

MyOutputBuffer.PersonID = my_source_value;

see the following link for some examples

https://docs.microsoft.com/en-us/sql/integration-services/extending-packages-scripting-data-flow-script-component-types/creating-a-source-with-the-script-component?view=sql-server-2017

normally that high number of heaps means

1 - whoever designed this has a Oracle background and followed the same approach

2 - the tables are staging type tables where having the...

one possibility is that an anti-virus is causing that issue - if you got McAfee running disable it