Yeah, I have warned about the cost, we have around 120 servers, have been given a deal by MS, but its looking like a mixed bag of PaaS, MI and...

• This reply was modified 5 years, 6 months ago by  Rick-153145.

Where I am at the moment has a project to move all the old 2008 servers into Azure, think they are being a bit ambitious though, especially with the amount...

I totally agree with your viewpoint Steve. There is a lot to keep up with and outside of pushing yourself, no one is going to do it for you. The...

I am slowly getting used to the new design. I think my biggest issue with it is the font you are using, just makes it much harder to read and...

By settings, we mean what does sp_configure return. Post that here along with what memory you have in the server itself.

Sorry, just looked at first post, cost threshold...

I guess it depends where you are and the privacy laws, whether there is recognisable customer data etc. If you are in certain states or within the EU, quote the...

In AD, have you given rights from the cluster container to the nodes? If not, then you will not be able to find either node and therefore creating an availability...

Please expand on your questions, you may get more answers, if these are questions on a test, google is your friend. 🙂

I always store them as YYYYMMDD HH:MM:SS.MS (Or without time if Date), I should use UTC and have at a couple of places, but I think it is business dependent,...

Thanks Grant, that's helpful, but not in the way I hoped. 😉 I just can't get my head around what is occurring as log backups are frequent enough, but the...

At the moment it is, this is what I want to stop.

I don't think there is any best practice for this except better design. Why are you now changing a char(3) to a char(4)? Could you have anticipated this from the...

I have used them for the same reason as Jeff. I actually found the developers were the ones who didn't much like them strangely, couldn't work out why and didn't...

Thanks Chris, I have tried that with a domain admin account , still the same error, hence the confusion as with those rights it should just work regardless.

Its...

No, two separate accounts. Would it matter in this situation as it should be using the Agent account to run anything outside of SQL shouldn't it?