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

The wording of the question was a bit misleading. I should not have conflated a value with a type, as NULL doesn't have a type, but conforms to the type...

If your intention...

We do need to bake security in from the beginning. This should be a part of all teaching for coding, as well as early on for setting up systems. I...