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

You can change the default language: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-default-language-server-configuration-option?view=sql-server-ver15

There is no choice in install. I thought that some languages had localized binaries, but the MS docs seem to indicate that you...

Are you using Hadoop, Eric?  I ask because some folks at work are talking about using "map reduce" (AWS EMR to be specific) and I may have been mislead...

Is this in the wrong topic? Not sure what you mean?

On a different note, here's one of the many reasons I fear both the cloud and any automatic performance metrics collected by any company...

https://mspoweruser.com/microsoft-accidentally-exposes-250-million-customer-support-records-online/

This has gotten to be a...

Hi Steve,

I am confused by this point :

" I find less and less resistance from developers about using sensitive production data in development environments, but still too much."

Are you...

Steve,

While I do like the article that you wrote, I would like to point out that you never defined PII ( Personally identifiable information ) in it.  I am...

Not really a switch, but an area of interest. I was hoping to get better at working with and gathering data. This is a big area of growth in SQL...

Calling another procedure isn't returning data from the procedure.

You can install Standard or Express on Win 10. Not Enterprise.

Win 10 has some limits on connections and resource usage. Windows server is designed for lots of connections. If this...