OK, you weren't clear in the explanation.

If you are loading data from staging to target, not updating,but new data, there shouldn't be many locks. You might have minor...

I'm not sure I'm ever going to forgive the PoSh builders for using -eq instead of = or ==. I just lost 30 minutes trying to debug a script that...

Ah, sorry, Rod. There are two places for subscriptions. You're looking at the ones for the forums. I assume those are the emails you're not getting? Nothing I've seen has...

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....