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

Visual Studio is quite happy with SQL 2012 / 2014 and with Azure.

Your choice of IaaS or PaaS is likely to be influenced by your current infrastructure and plans. ...

If your CAL licences are valid and you are changing to Core licensing, then you may not need to do anything within SQL Server.

If your core licenses are...