This should work.

At my place it is not unusual for the publisher and distributor to be at a lower SQL version than some of the subscribers. We are currently...

Gail's code looks like it might work 🙂

I am out of office until Monday 10 and will check it out then. Thanks for the suggestion!

BTW, Buffer Pool Extension is...

You are severely limiting the capabilities of what you can do by continuing with the use of SQL 2000 and SQL 2008. You will end up with a system...

P2P replication provides the ability to automatically store details of conflicts. It will also automatically tie-break a conflict based in the internal Id number of the servers involved with...

My 2 pennies worth... it depends.

Using a separate account for each SQL Service on each SQL instance gives maximum security and maximum maintenance overhead. Using the same account for...

It is worth looking at your Microsoft Licensing terms. You may able to install Enterprise in non-production environments under the MSDN provisions for no charge. In this situation...

The error message is implying that a SQL Server instance with the name (or more strictly the guid) you want is already installed.

1) Are you doing an ADDNODE action install,...

I think our understanding is the same.

If you licence all the physical cores on a server you own, then you can run an unlimited number of VMs on...

I am not sure which aspect you are referring to. This link

has a section called hyper-threading which may be of help.

"In theory, theory and practice are the same. In practice, they are not" - A. Einstein

If you want to stop or start SQL Services on a Cluster, you should use the Cluster Manager to put the resource group On or Off. If you do...

The most a DBA should be doing is to advise what additional licensing may be required. There are professionals in this area who should make the final decision. ...

Most people say that best practice is to have a dedicated DBA administration machine that you do RDP on to, and use SSMS on that machine to do your administration...

sp_makewebtask does not exist in SQL 2012. You will have to re-engineer anything that uses sp_makewebtask to use different facilities.

As already noted, Microsoft suggests using SSRS to generate HTML....

Internet access is not required to install SQL Server. However, you do need to work out what components will also be installed when you do your SQL Server install...