How do I get the tools back? It also provides source control functionality by allowing offline project work among other features. To further the confusion, both tools are downloaded from the same website: Moreover, two versions of each distinct tool is available, one for Visual Studio and one for Visual Studio as illustrated below. The big decision you need to make is whether you would want to install the BI tools as part of Visual Studio or as part of Visual Studio
They have two options for licensing Core or CAL. In my company the customer support its not the best of all the Microsoft products, sometimes they solve the problem only with a patch and do not help with a temporary solution.
Microsoft SQL Server 2014 - Introductory Tutorial