Thanks. 
So that means they can use together.
I understand TDE encrypts data at rest, the mdf, ldf and  backup file.  It does not encrypt data in dataabase.

The...

I found if you restore a copy to overwrite the same database, it makes sense to have that checked as default.

As NJ_DBA, in my case I usually restore...

Thanks for the article, that is a good reminder.

Not sure why microsoft make the checkbox checked as default? why the source database has to be in nonrecovery mode?

I changed to use ADO.net connection instead of OLEDB connection.

There is no error when previewing the data. 

However there are pros and cons using ADO connection comparing...

Thank you, this is very useful script!
Hope Microsoft can make the column Name available more easily in SSIS development tools.

Thanks!

Yes, anything else I need to do?

I know for developer edition I have to enable tcp/ip protocal for the client network connection, while enterprise edition you don't need...

Thanks,
Yes, after they rename the Server, it has been rebooted.

Then they didnot change the SQL name until second day I found and changed the SQL server name.

I did a little more explore sees I need to use copy-rsSubscription.

The problem is they all create new subscriptionid when moving to a new server.

I want...

Thanks,  I looked at the first link you posted  http://wragg.io/managing-sql-server-reporting-services-subscriptions-with-powershell/

And I tried to use Import-RsSubscriptionXml with Set-RsSubscription and found Set-RsSubscription no longer has the parameter for path.
You...

I took a look at this link, it seems they copy the subscription to a different path on the same server.

What I need is to copy from one...

I found the solution here.

https://www.mssqltips.com/sqlservertip/1274/change-not-for-replication-value-for-sql-server-identity-columns/

Thanks

I should add in my original post that I have an identity column like this:
[ID] [int] IDENTITY

July 31, 2018 at 10:36 pm

#1999828

Actually after I disabled 11, 13, 15, 16, 18, I still got the alerts of SQL errors.

Not sure what is it, cannot find anything in SQL server log....

Hi Higgim,

I tried the powershell script to copy backup files to Azure,  but I got an error, not sure how to fix it:
....
Checking for container [...] in...