I'm not quite sure what you mean, but with your questions.

1. The backup file will contain this data inserted into a FILESTREAM table, so it will be larger.
2. Not sure...

https://stackoverflow.com/questions/18996157/what-does-lock-communication-buffer-resources-mean

https://dba.stackexchange.com/questions/49538/sql-server-deadlocked-on-lock-communication-buffer-resources

These might help. A new one to me as well.

If you are asking if the CAST can be part of an insert, it can.

A few things noted above, but also query store can help here, and force a particular plan for a query.

I've queried Microsoft, but it looks like encryption is set by protocol, not IP. So while you might be able to force encryption for IP connections from anywhere, which likely...

You should have a deployment script (s) of some sort to do this. Something like FlywayDB would make this easy: https://flywaydb.org/

Disclosure: I work for Redgate Software.

Xevents looking for this will also help. That is non-intrusive to your system.

There are also community scripts you can look at: https://www.sqlservercentral.com/search/failed+job/section/scripts

You can also use Substring() to return a part of the string only.

Nice, Bill. Some great pictures in there of nature. I'm going to be following.

I'll try to search those out, but not sure. The threading in here isn't really a place to run a project or post the code. The GH repo is much...

I think this has been true most of the time, but I am starting to see some companies build parallel tracks to keep advancing tech people without them going into...

I agree. While I was looking around, I was thinking about putting in another example there.

I don't think that CONTAINSTABLE allows a "NOT NEAR" to be used. At least, the docs on NEAR don't seem to show this.

https://docs.microsoft.com/en-us/sql/relational-databases/search/search-for-words-close-to-another-word-with-near?view=sql-server-ver15

I think a subquery that finds rows...

I don't believe the linked server can access the key. Architecturally, this works by the decryption happening in your driver, on your machine, not on the server. The linked server,...