Well, having to read data from disk (unless you're on SQL 2019 BDC) introduces the need for CPU cycles to do so (I would for arguments sake assume the PLE...

I'm not sure if having Jeff on that board would really be such a good idea - at least for some of us.

• Anything that tries to RBAR would throw...

well, many instances can share one listener port, however no instances should share the same port as is configured on the listener.

You said DB names have been matched to listener...

from looking around generally speaking eventually no 

if you can use it at the session level, could you use it on a statement level? If so OPTION(RECOMPILE) might be better...

You need to create a FileGroup for In-Memory Objects, you cannot undo this at a later point in time. You will most likely need to configure Resource Governor to Limit...

If I get a chance to, I'll happily be the first one to make it work in production. Same as I got Memory Usage of Memory Optimized Tables under control...

There was a part of the query as a INNER JOIN clause which had trouble with lookups due to the package not being adopted to In-Memory Tables (TRUNCATE TABLE was...

I still look at Memory-Optimized TempDB Tables with jealousy. I wish SQL Server 2019 was out there just a few months earlier and I would've argued for 2019 right...

I was just having similar thoughts, You could go FCI 2 node hardware wise if you want with dual expander JBOD shelves and just replicate to the 3rd node. I...

Odd number of nodes isn't that big of an issue - as said before you can up the votes on resources individually -

As for the sync pair, obviously you...

It runs for about 12 seconds before it reports successful. Which is about the same amount of time until first rows are displayed. The query runs for a total of...

Well to be exact the package is failing on the last fact table I'm trying to fill, it's data is mostly based on the previously finished fact table.

Well the source...

well there is enough Software Defined Storage, as mentioned before VSAN and Storage Spaces Direct (S2D) are some of the Options amongst others like Starwind, you don't need to go...

Yes it's about wether WMI Service State queries work or not.

Enabling these Windows Firewall rules

Windows Management Instrumentation (WMI-In)

Windows Management Instrumentation (DCOM-In)

on your prod environment should turn the Icon green.

Adding to what Jeff said: Preferably  the second SAN would be in a different DC, a fire wouldn't stop just before the secondary SAN unit sitting above the one burning...