I also maintain a pair of dates as well as a current flag. On the current records the end date is null however. On my agent tables, which...

Often things aren't the ideal, but a bunch of ad hoc cubes won't likely have the data safeguards that go with a properly designed ETL system. I appreciate that...

The main reason to avoid cubes everywhere is that if fact tables and dimensions don't have common definitions agreed to across the enterprise, then the warehouse will never reach the...

This is partly helpful, as I've read this, but I would like to understand why. What's the risk if this isn't followed? Thanks,

So just to be clear, you mean a single service is joined with a single domain account, but that combination is used across all servers. Right?

Probaby shouldn't admit I looked at a last logged in date rather than the posted date. Thanks for the response. I...

If it's been like this for a while, you should be able to find orphaned data to help make your case. It still probably won't convince them, at which...

Hopefully this post isn't too old to continue the discussion. I've read that it's best practice that every SQL Server service account on every server have its own domain...

I don't take things personally. These were suggestions, but your the person on the ground.

It's possible to see this as being valid. I deal with deleted...

Well there's no point in taking time trying to convince you. As I said to another poster, one day you...

There may be times FKs are hard to implement, and there may be some that don't have FKs at all. FKs enforce relationships. Where there is no relationshipo...

I've seen otherwise good people unconvinced by even this.

That's too bad. But as nothing anyone will say will change your mind, all I'll add is that one day you, or someone else, maybe me,...

Maybe even a lot of piling on...