It's not completely clear what you're describing here. I think you're making this confusing in some sense. Forget about VMs for a second and treat these as machines. The VM...

Note, this isn't likely to help you answer the questions if you don't do more research. I'm happy to help, but I'd like to see you make an effort to...

This sounds like a set of interview questions, but here goes:

1. I have code that needs two parameters used in the call (query, proc, etc.). I have a stored procedure...

Two places:

• Brent Ozar: https://www.brentozar.com/training/
• sqlSkills - https://www.sqlskills.com/sql-server-training/

To me, this is one of those places where you ought to have two stages of building software.

We don't deploy software to production if it hasn't come from the build...

Start. I would bet containers are going to be an important part of our future in 5-10 years.

Glad you like it. I was the hero early in my career. Learned to not do that, and ask questions/set expectations in the interview. I've walked away from lots of...

I'd always save locally and then pull from there for reporting. That way if the pull process has issues, at least you have some aggregate data in the db.

I tried...

What are you looking to check with  "we want to check that 7 instances replication status in one dashboard"?

If you want just a replication dashboard, you can build some things...

A side note, there is also sys.dm_db_resource_status in each db - https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-resource-stats-azure-sql-database?view=azuresqldb-current

You can't, because you can't just insert to another database. There is a way to do cross database queries, and it can be complex. I realized I should have written...

You can get away with it, but security changes the game. I wouldn't hesitate to run a small system on SQL 2000 if I had to, but I'd want it...

Perhaps, but that might mean the Windows continues to thrive on the desktop. You can run any Win/*nix/OSX app, but still on Windows.

The Windows shell and environment is pretty familiar...

Or check out the Python meeting of the San Diego TIG: https://www.meetup.com/San-Diego-Technology-Immersion-Group-SDTIG/events/223458320/

Actually, you should try Python. I think R is a mess, but Python is a very nice language to work in. If you want to have some fun, solve some...