original backup was created with compression - the one you did on your workstation didn't use the compress option

don't know what you tried but for sure you didn't look where you should.

1 - Add new variable - @package - type string

2  - Add new Execute Package task

2.1 -...

sometimes you need to manually add them to the toolbox - see https://www.sqlservercentral.com/forums/topic/using-attunity-connectors-to-connect-to-oracle

And in some versions there was a need to tweek a registry entry.

also make sure you have...

if you have Enterprise with SA you can install Power BI Report Server on the same licensed server instead of the standard SSRS installation - PB RS is a superset...

this will be interesting reading https://docs.microsoft.com/en-us/sql/integration-services/data-flow/data-flow-performance-features?redirectedfrom=MSDN&view=sql-server-ver15

what you can do is to implement it using powershell.

See this http://byobi.com/2015/10/powershell-scripts-for-collecting-ssas-related-perfmon-and-xevent-trace-data/ for example from Aaron Bertrand

and then this one to load them onto a sql server table for analysis...

depending on the size of those db's and also no how many have  "MAX" datatypes the following would be an option

restore the current db onto a new name.

add a new...

• This reply was modified 5 years, 11 months ago by frederico_fonseca.

look at https://dba.stackexchange.com/questions/171395/troubleshooting-powershell-errors-from-sql-agent-job

Possible solution is to change that step to be a cmd file instead of direct posh

you to know there is a thing called google don't you?

from the thing above the following are 2 results

https://www.sqlskills.com/blogs/joe/hunting-down-the-origins-of-fetch-api_cursor-and-sp_cursorfetch/

https://blog.sqlauthority.com/2015/01/10/sql-server-what-is-the-query-used-in-sp_cursorfetch-and-fetch-api_cursor/

Many times the best way to ensure that Devs do what is required is to pick up some of the bad SQL's and rewrite them so that they behave well...

if not for the weight (and price) Alienware Area15 would be top choice.

In my case I have a lenovo Yoga 920-13IKB (i7 4 core, 16 GB ram, 1TB SSD)...

duplicate post https://www.sqlservercentral.com/forums/topic/change-password-for-service-account-for-sql-agent-in-active-active-cluster

answer given there

no need to pass anything as a parameter.

In each database just setup a synonym pointing to the corresponding log db and on your code you just use the synonym in...

not a problematic file at all - fixed positions for all columns so its easy to process.

Do NOT use the import wizard - you need to manually process the file...

• This reply was modified 5 years, 12 months ago by frederico_fonseca.

again you talk bollocks - OP is not worried about, neither does he/she cares, about how SQL decides to store the data - what matters, and it is a significant...