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

String Split would be easy. Add an optional parameter that adds an "order" column. I'm not sure why they won't do this one.

For SSMS, lots of ergonomic things would help,...

I'm definitely closer to Glenn, and I'm actually a bit excited. I ordered a Tesla recently, and I'm looking forward to the car.

I haven't used a key to get in...

I tend to agree with Jeffrey. While the separate volumes might not give performance improvement, they certainly make it easier to grow/move/change if you separate instances at some point.

It is a seek operation. A query could potentially seek multiple times for different reasons, like the complexity, row lookups, etc.