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

What pietlinden noted is what I've done. What you are really doing here is auditing, so a trigger works well. From here, what you then do is replicate for some...

I'd like to think this is how most organizations think, but I'm amazed at the number of high profile incidents blamed on a low level worker. That doesn't typically happen,...