Personally I approach these type of changes by first identifying which executions take the longest, then which queries within that take the longest looking through their ACTUAL explain plan and...

with a few exceptions Production data can easily be manipulated to remove/scramble any PII or similar data at which time none of it can be used if it is leaked...

Without a tool what are the options.

We have atleast 200+ instances and I would like a report which states whether the windows box is pingable, if the sqlinstance is...

do them on a per table basis if deemed needed -...

dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3

again you keep failing to address how to ask for help here - and again you fail to understand that on this case only you can see what is wrong...

dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3

• This reply was modified 1 years, 10 months ago by frederico_fonseca.

That article is for SQL 2008. The servers are 2017 and I'm pretty sure SMO code doesn't work anymore in 2017.

EDIT: Even looking at the PowerShell options, it doesn't...

easy with SMO

https://www.mssqltips.com/sqlservertip/3675/using-smo-with-powershell-to-obtain-sql-server-job-information/

you just need to create a list of servers to extract from and do a foreach loop on that list to call the job function.

use it all the time - and our DBA team has a central server with CMS setup so it is available to all DBA's (and some snr developers/architects) as well.

in...

for that you will need to have a audit log table and a trigger on the table you need to monitor- no other way to do it (other then perhaps...

• This reply was modified 1 years, 10 months ago by frederico_fonseca.

have a look at this https://www.sqlservercentral.com/forums/topic/sqlagentreaderrole-can-create-its-own-jobs-what-is-ms-thinking

SQLAgentReaderRole would be the role to use to allow them to view jobs - but as this gives also permissions to CREATE jobs a few...

not those settings (which should be changed in most occasions - just don't set it to automatic on newer version of SSIS)

look at https://learn.microsoft.com/en-us/sql/integration-services/data-flow/ole-db-destination?view=sql-server-ver16

setting can be applied on the execution of the script itself - changing global policy is bad - but changing to execute a internal script with the setting on is...

please do not create duplicate posts - you have already posted this (see https://www.sqlservercentral.com/forums/topic/updated-table-not-displaying-data) and you have gotten several replies - fact that they are not what you want (e.g....