Closing. Please answer in the other post.

The only thing that appears to be missing from the procedure is the memberid. If this is only for one user, you can get that value from the membermaster table...

Like others, I tend to use paper/pen. I often will get this moved to some electronic medium, like Visio, but it's a manual thing. There are tools, but they tend...

You may be right. Didn't know they could use these for  tasks, so it likely means the app needs to work with these.

I wouldn't expect a gMSA to work for these. These are for Windows services, not credentials for access.

Lots in info out there, and I wouldn't panic, but I do think we ought to be cautious. I'll be extra careful in public spaces, disinfecting things that lots of...

Glad you liked it. These have been fun to create.

Slightly running low on ideas, but if you have some, send them in - https://www.sqlservercentral.com/contributions

Lol, not me. Network security people use this all...

You can determine much of how an AI works, but it's very hard. Also, few people do it, so as Roger noted, in the practical world we won't know without...

Agent Jobs - script, search and replace instance names, security accounts if needed

SSRS - backup restore dbs.

Repl - script and be ready to rebuild. Once you install, migrate, get running,...

This might also help you. It's free (for an email): https://www.sqlservercentral.com/books/the-art-of-sql-server-filestream-by-jacob-sebastian-and-sven-aelterman

I wouldn't upgrade until I ran out of support or had another need.

Filestream/filetable don't necessarily mean changes for your client. This tech is designed to somewhat sync the filesystem with the db, include the binaries (files) in backups, and prevent sync issues.

Filetable...

Haven't done this specifically, but what I've learned in the past is to test, test, test. If you want to move things, the backwards support is pretty good for 2017...

This question isn't designed to cover all possibilities. Writing questions like that is hard and fraught with perils. You are welcome to submit your own questions about other types of...