One of the examples could be a use of SQOOP process (configured in Python), when data is being massaged and copied from Hive (Big Data) to SQL Server for reporting...

Hello,

I wonder if there is a way to print the whole topic, consisting of multiple pages in 1 shot. This option used to be available in the prior version of...

I also installed Postgres on Ubuntu in Dev manually. Worked pretty well. However our Engineering team is using Postgres installed on Centos 7 via puppet.

Was backup completed? you need to ensure that backup is completed before moving to the Robocopy step.

Say, I have 10 subscribers for the same article. Will I get a performance hit on a publisher?

Anyone? Anything?

Thanks, Any other suggestion(s)?

use @databasename  is your answer, so in your case it will be something like( you will need to pass database name):
USE ' + @databasename + '
Insert into master.dbo.[Index_Frag]...

No, there are few ways to do that, but the most easiest way is to created only 1 table on a linked server ( which is accessible by both Prod...

Those restore commands you need generate and insert into the table at the time of the copy to the secondary. And then instead of running restore commands manually on the secondary server,...

At my previous job I created a process to logship over 300 prod databases to DR. I don't have scripts handy as it has been a while back. But here...

question is a bit tricky as we wont be able to perform a tran log backup to begin with if copy_only full backup is being used as a base( and obviously...

you can also incorporate creating folders via mkdir:
SET @Path = '\\xxxxxxx\yyyyyy\'
SET @ssql = ' mkdir ' + @Path + '\' +@DBName
EXEC xp_cmdshell @ssql, no_output