I learned about .eye() first, so I added that. From what I see, identity() should work as well.

You should not be assuming this is part of anything else. If the question doesn't list it, it's not part of the scenario. This is a simple look at what...

Licensing is always touchy. As with many companies, Microsoft moved to a model that favors larger organizations, not smaller ones. In the grand scheme of things, is that expensive for...

That was really the idea here, to get people thinking of how to test scenarios. I think this is more powerful an argument than a general introduction to testing. I...

You can do that, but the key will not decrypt any data that you've already encrypted. These symmetric keys are deterministic with the same identity and key source, so you...

glad you liked it. I'm trying to find some more interesting questions by trolling blog posts and forums

I'm vacationed out. Spent last weekend watching my daughter play college volleyball live, but I've had a good year of trips and am ready to just stay home for a...

I use WordPress.org (or .com) for my voiceofthedba.com. I can't do a lot of modules, but it has worked for me and they manage everything. Cheap too. Use GOOG for...

Certainly a thorny problem, but an important one to solve in order to bring better health to others.

https://kb.k12usa.com/Knowledgebase/Make-an-IP-Reservation-in-your-Windows-DHCP-Server-with-Remote-Administration-Tools

In the restore dialog, there are selections on the left side, one of which is for the Files tab. This is the second one. There is a "relocate" checkbox on...

Honestly, while this is a good exercise, there is a script that does this very well and has been thoroughly tested.  I would recommend: https://www.sqlservercentral.com/forums/topic/recommended-sql-backup-software-2/#post-3681962

If you're interested, writing up your experiences and learning how to do this would make a great beginner article. You may have a perspective other authors don't.

Good luck and hope you don't lose much data.

That's certainly not right. Bug filed.