I think probably what will help you the most is something like this:

https://aka.ms/sql-permissions-poster

It is a rather large poster, but it gives you all SQL related permissions, what they mean and...

Granting connect is safe and required if you want a user to be able to connect to the SQL instance.

Granting read is again, something I try not to give away...

The only issue I see is if developers don't need to see the definition of an object or the name of a database due to proprietary knowledge in or about...

It depends.  The favorite DBA answer.

From BOL - https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server

Basically, if you have a lot of updates on the table, you will have a lot of tempdb growth.  If the table...

My next step then would be to check the error that popped up.

The error message is:

Unable to start the Transact-SQL debugger, could not connect to the Database Engine instance '<instance...

With debugging SQL Server code, I do not use the debugger.  I've never found it to be that useful with respect to TSQL.  Maybe my code is not interesting enough...

My opinion - it sounds like strategy one is the way to go.  This lets you log all changes and you can select the changes you need to see.  What...

My next thought is that you removed something that is normally installed on a system (such as a C# redistributable package).

Might not hurt to do a repair install of the...

Personally, this sounds like a good fit for an in-place upgrade then.  You get to skip over the overhead needed for a migration install and you sound like you have...

The log tells you what to do next:

Next step for SQLEngine: Use the following information to resolve the error, uninstall the feature, and then run the installation process again.

Next step...

One big reason to do a migration method is that you have a quick and easy rollback method.

One big reason to do an in-place upgrade is no duplication of data.

There...

Just a quick thing from my eyeballing on it - it doesn't appear to me that the query you provided gives the results you indicated.

@result doesn't contain the "AS" keyword,...

Have you checked long running queries and/or transactions?  Could be someone took out a transaction and never committed it.  That'll make the log grow.

What about the PHP errors?  You are seeing a jump to 1500 errors in that window when the CPU is spiking.

The NGINX error of 502 is "bad gateway".  So it...

is the column DBSource.dbo.Contacts.ContactID unique?  If it is NOT unique on the source, you could have problems putting it into the destination where it expects it to be unique.

Heh, Scott...

• This reply was modified 4 years, 8 months ago by Mr. Brian Gale.