Thanks Johan, Thanks Grant. Can you please share the link containing Jeff Moden's guidance regarding not to do the index maintenance in the Azure MI?

Can you please provide the equivalent...

Many thanks, Brian.

thanks, Phil. This is a great approach.

The certificate was backed up using the old master key password. The question is, if I change the master key password, do I need to take the certificAte backup again?

Thanks, Steve!

So after I regenerate the master key, do I also need to take the backup of the "service master key" and the "backup master key" steps? or the old...

Many thanks. This is very useful..

USE [DB_NAME];

GO

ALTER DATABASE ENCRYPTION KEY

REGENERATE WITH ALGORITHM = AES_256;

GO

Thanks, Wei. But using the Wizard we can extract the Publication, but it does not provide an option to extract the subscriptions. Any possible method to script out the subscriptions?

Thanks, Steve

However, the requirement was to send the alert with the database name for which the tlog job is running for a long time. Can you see if there is...

Thank you so much for all your responses.

But how to find in which database the FTI is setup. Instead of changing the db context every time and running the query?...

Thank you, Steve. Working like a charm.

By the way, can we tune this to be used like a self join?

no, just SQL AG (HADR). no FCI

• This reply was modified 4 years, 8 months ago by  SQL_Hunt.

Hi Steve,

Do you think there may be any issue in future if we would like to patch the instance? Also do we have any clear steps about how to disassociate...

thanks, Phil. Can I use random () to rewrite the same query?

Hi Jasona,

Did you encounter any issues in the event of any rollback of the patch back to SP1?

Hi Steve

After a hard checking, I explored and enabled the "file name extensions" feature from windows and that allowed me to change the extension from Mdf->Ndf. Earlier I never had...