I think that when you log on with your SQL account you have a security context of that account. When you then do the linked server bit there is a...

Developer Edition give all the facilities of Enterprise Edition.

Also, Developer Edition is not restricted to individual use. The restriction is on type of use. A whole team can use a...

My only advice is to build a test cluster to a similar spec and try out the various failure scenarios. Repeat the tests a few times to see if the...

Back in the old days before Microsoft fixed all security issues in Windows (: there was a thing called Unconstrained Delegation.  This was the default setting and resulted in an...

I may be wrong but it seems like the backup strategy was set up for the convenience of the people running it and not for the needs of the business.

The...

There is a lot that is not said in your question. I will focus mainly on high-level items in this reply.

My first experience of using a DB on a virtual...

• This reply was modified 3 years, 9 months ago by EdVassie.

You should be able to do this via the SKU upgrade option. It may even be possible to do it by changing the license key for a Standard Edition key.

You...

There has been a fair bit of high level stuff about how to use X, but no low level stuff about why it is there and why it is needed.

The...

If you have things called 'Development and Production' environments and 'Change Control' then SSIS environments can be useful.

A place I used to work had dedicated staff doing the Production implementations....

You said you have done a Copy Only backup. This may not be what you actually need.

Unless you really know what you are doing and the restrictions related to a...

Your AG listener needs to have a unique IP address. It should not try to share the address with a node or any other object.

Your client applications connect to the...

Part of your job is to tell management what is possible and what is not.

You may have a technical solution that merges job history, but it requires you to manipulate...

Fredrico's question is important. Why are you making this change. If it is needed why are you doing it as part of the DB migration.

You are doing a data format...

To link your applications to the servers use DNS aliases. I have used a two-tier setup of Application aliases and Failover aliases. See my post from July 11 for more...

First thing, you need to be very clear about the business problem and what you are trying to solve. Eventually you will have to ask for money to get this...