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.

You can pick profile in the upper right, then on the side bar, edit profile. You can go down and change the email, but not the user name.

Gail is still around, but less on technical sites. Life has taken a turn for her, and we chat at times, but mostly she's less engaged in this space. She...

I like the Dog Mode having a big sign on the display and the temp setting. We'd certainly use that with our pups.

I'm torn with a lot of the electronic...