Hi All,

I am back again -- this time I think I know a bit more about what I want to do or how to do it. I was...

I've always avoided using script generation for rebuilding a DB with purely because historically (SQL Server 2005) it never really worked on complex databases.

But I am on SQL...

We have a 10TB DB that has been historically built with the wrong collation. Well, not necessarily the wrong collation at the time. Just wrong for what the front end...

However, get-aduser tells me that:
TrustedForDelegation      : False
TrustedToAuthForDelegation    : False

I think that means before the SPN's even begin to matter I need to at least...

yes same account to run all the sql servers in this domain

and the ssis connection is set to integrated security

Cheers Beatrix.

So, with that, does that look like my double hop problem is unrelated to the SPN's - I suppose more info is needed to answer that. Which...

Ahh yes, yes, good points! Cheers guys.

Hi Beatrix, what would be wrong with using the same gMSA for all SQL Server either per environment (i.e. test, dev, production) or generally across the whole network?

The definitions are written below the radio buttons. What bit in particular do you not get and I'll try to explain it simpler than the Microsoft definition (though, not sure...

Cheers, though that isn't really what I am after. Its those jobs who's schedules were missed (not failed, or aborted) just those that would have started if the server or...

Andreas, why is that? (not saying you are wrong, but am curious) one would have thought there must be a definitive formula, or way of comparing costs of licensing options?

Hi.

This won't answer your specific question about the binaries, but in terms of managing risk of feature-overuse, the following query might help:
SELECT * FROM sys.dm_db_persisted_sku_features...

Thanks Jeff for this excellent reply.
I am certainly interested in your LOB_COMPACTION article as that problem is most certainly going to rear its head soon. We already have...

Perfect, article. Cheers

Thought that was MySQL only?!

Out of interest, what happens to a snapshot thats taken on a DB thats apart of an AlwaysOn Group, and that group then fails...