Viewing 15 posts - 1 through 15 (of 394 total)
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...
December 31, 2020 at 7:10 am
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...
May 13, 2020 at 6:47 am
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.
July 21, 2019 at 7:03 am
Was backup completed? you need to ensure that backup is completed before moving to the Robocopy step.
February 4, 2019 at 11:21 pm
Say, I have 10 subscribers for the same article. Will I get a performance hit on a publisher?
December 11, 2018 at 9:22 pm
December 9, 2018 at 9:13 pm
Thanks, Any other suggestion(s)?
July 26, 2018 at 2:19 pm
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]...
March 23, 2018 at 11:39 pm
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...
February 8, 2018 at 12:56 pm
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,...
February 7, 2018 at 2:44 am
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...
February 4, 2018 at 2:22 am
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...
December 10, 2017 at 6:09 am
August 27, 2017 at 2:15 am
August 25, 2017 at 12:16 am
you can also incorporate creating folders via mkdir:SET @Path = '\\xxxxxxx\yyyyyy\' SET @ssql = ' mkdir ' + @Path + '\' +@DBNameEXEC xp_cmdshell @ssql, no_output
August 24, 2017 at 11:07 pm