You can click the “insert/edit code” button and paste the code in the item that pops up. I do not see an insert/edit code ...

Do you have TLS enabled for any of this? I've usually seen that in relation to TLS and in that case you would need to make sure OS and SQL...

Hi

Can you please provide some suggestion how to prevent user (part of Windows Group) changing the Default Database? All the other user in the group got affect after...

If you search on "What's new in SQL Server <version>", you an usually find a good list of the changes, improvements from Microsoft Documentation. It's a long list -

https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017?view=sql-server-2017

Sue

When you detach a database, you change the permissions on the database files.

The service SID account needs the permissions full control on the files.

The service SID account for...

Why on earth would you detach databases when you just needed to create an account? I know why you got the error. I'll post back in a bit if no...

You'd also want to make sure to check all the other major components for the SQL Server instance. For example, you can end up with more disk activity if you...

I've never really noticed anything with it enabled, it encrypts data at rest and auditors like when it's enabled. I mentioned the only con I can think of. I've used...

Hi,

I am a SQL Server DBA in the Company.

One of our Clients is running SQL Server 2012 Enterprise Edition utilizing AlwaysOn Cluster.

I was asked for the Security reasons to...

Do you have the Resource Governor enabled? If so, try to disable it

Sue

Thanks for all of your efforts with the website and staying on top of the issues. I realize it's a huge undertaking and a PITA at this point.

If nothing...

I get the "Oops! That...

Check the following documentation for instructions on how to do this:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?view=sql-server-2017

Sue

You want to look at the entire I/O subsystem, not necessarily just the disks. Anything in the path from SQL Server to the disks. I've had that type of thing...

With the error being that the snapshot already exists, it seems like it may be trying the integrity check twice and they overlap.

Possibly you are specifying the database database...