Just about all professional DBAs revoke access to database diagram SPs, it's a best practice.

I have used dbForge and it's useful but you wouldn't broadcast this to all and sundry

Have you read the documentation Microsoft provide for Azure SQL DB redundancy, that would be a good starting place

agree, gMSAs are way forward.

I found it is best to create the SPN manually, and assign to it the permissions it needs.  Doing things this way also requires that you use the same...

It...

message 1 is a warming so you can ignore it.

message 2 is informing you an SPN couldnt be created, what account do you run the sql server service under, guessing...

No you’re just changing the owner of the folder, is your sql instance running under system account  and not user acct or msa?

once you’ve taken ownership you can add acls...

Hi Experts,

One of my Large database having about 4TB in size is taking almost 3 days to complete the backup . To reduce the backup I stripped the same...

No, its pretty much all at the external level to sql server

ok, using AlwaysEncrypted.

Firstly do you understand exactly how this feature works and the degrees of separation that can be used, see my blog post at this link

Is your colleague...

• This reply was modified 6 months, 3 weeks ago by Perry Whittle.

Take this as a base to identify orphaned windows and instance logins, then wrap around to create statements required

select dp.name, sp.name 
from sys.database_principals dp
LEFT OUTER JOIN sys.server_principals...

also, check the log produced by the installer, full details are in there for failures

take ownership and change the owner from system to the sql admins group if you have one or server admins.

So random question about Windows Certificates --

I administer and develop a SQL Server DB App -- Back End is on an Azure Server/Front End is MS Access, about 35...

don’t use sysusers and sp_change_users_login, they’re deprecated and will be removed, also don’t use a cursor.

use the ALTER USER command to fix orphaned database users