Quick summary of what I'd do here.

Since I'm changing the timezone of server, all existing data will display incorrectly, while all new data is correct. Therefore, I need...

+1 one for the synonym. You could use a view as well for client access, but this is more of what a synonym is for.

the more complex your environment is, the less likely you'll have one screen to view it. However, you could have one screen that lets you know where things need investigation,...

SQL Audit will do this if you need this to be accurate and secure. Someone can turn it off, but that will be logged as well. However, as mentioned EE.

In hindsight, I should not have posted publicly and I apologize for that. I had ignored a few in a row, but was rather annoyed myself at the comment that...

I deleted the post from edwardwill as it was unprofessional and contained profanity. not sure why the filter here didn't catch things, but I removed it from here and from...

In your profile are check boxes. If you're the Rod I think you are, these are turned off.

Haven't seen that, though I'm not sure I've done this with 2014. I have with 2012 and 2016, and both seem to work.

Can you verify this on another...

Maybe it does, maybe it doesn't, but it's something that you must verify or prove, depending on which side of the interview table you sit.

I would say that after a year, you're not new to SQL. You might not be competent, you might have 1 week of experience 52 times, but that's your issue....

yes, the sa login can do anything inside the SQL Server, which has XPs, cmdshell, etc, with potential access outside the system. In essence, the concern is that Sa can...

I'm not quite sure what you mean here. Do you mean that now the server is in the US, set to a US timezone and all data is stored as...

Does this appear as soon as you start setup? There isn't a place/time to choose the instance to apply this against?

These days, PoSh would be the way to go. Find all mdfs and then compare them with what's attache. In fact, I was just thinking about updating a script I...