The short answer is you cannot encrypt code. You can obfuscate it with the "WITH ENCRYPTION" option, but this is easily reversable, as pointed out above. SQL Compare does this...

First, don't use profiler anymore. Use Extended Events or the xEvent Profiler to watch things.

Second, do you have the primary set for read/write? This should limit the read...

I would write this more compactly
UPDATE  WMWHSE1.LOTATTRIBUTE
  SET LOTTABLE05 =     I.LOTTABLE05
  FROM WMWHSE1.ITRN I

   JOIN WMWHSE1.LOTATTRIBUTE L

    ON I.LOTTABLE06 = L.LOTTABLE06

Is the data in the column stored at "2019-01"?

You are going to have problems at some point trying to do range work. What I'd suggest is you create...

Ah, forgot to add it post-publication. It's in there now.

That's what we do. They really encourage you to take holiday and while you can sell xx back, you can't carry more than xx. The push is to take time...

Personally, I think you ought to be able to sell some time back, but they ought to have to give you, or make you take, a percentage of time off....

If anyone wants to nominate Redgate, you can do so for the Reader's Choice Awards: http://www.dbta.com/ReadersChoice/2019/

If you read the BPE section, it requires a restart if the size is smaller than currently. If larger, it doesn't require a restart.

If there is an attack, especially an insider attack, you want an air gap between some of your backups. While it's nice to have immediate access, I would also be...

This one is similar to others. Easy if you read a bit about this before

I would agree with you, Dave. Too many companies have treated us, or at least our data, poorly. That is one of the things I really like about the GDPR....

I don't think you need to grant someone control. The issue is that both the nodes (or all the nodes) need to be able to open the DMK. Usually the...