![Business intelligence development studio.](https://kumkoniak.com/107.jpg)
![business intelligence development studio. business intelligence development studio.](https://1.bp.blogspot.com/-E63nG4mZL4E/Vb3QZ0WZGBI/AAAAAAAACiY/W7B57FJDOOI/s1600/222.png)
![business intelligence development studio. business intelligence development studio.](https://i.stack.imgur.com/fPnh0.png)
Read more about it on the blog of Jamie Thomson ( blog | twitter): More SSDT naming confusion. One to download, one that came with the SQL Server install media. One for database projects, one for BI projects. Mildly schizophrenic to say the least.) This development environment uses the Visual Studio 2010 shell and you use it to build BI solutions solely for SQL Server 2012. However, you have a tool with the same name for creating database projects, which you had to download and install separately (don’t get me started on which names this tool had before. This piece of software was delivered to you when you installed SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2. The most non-confusing name of the bunch. BIDS or Business Intelligence Development Studio.
![business intelligence development studio. business intelligence development studio.](http://www.yaldex.com/sql_server/images/progsqlsvr_0218.jpg)
Let’s give an overview of the SSDT evolution: What I think the Microsoft Marketing department looks like Anyway, in this blog post I’ll revisit the subject since there is again (some sort of) a name change. At that point in time – the CTP release of SQL Server 2014 – you had to download the software separately (it was no longer part of the SQL Server set-up) and you had to install it as “a new instance”. Over 2 years ago, I wrote the blog post SQL 2014 CTP1, where is my BIDS? – one of my most popular posts I might add – where I tried to explain the confusion of yet another name change and also point out how you could get the software. So far so good, until the notorious marketing department of Microsoft decided to fiddle with the names of said software product. If you have a full blown Visual Studio installation, you needed the BI templates if you didn’t have Visual Studio (or the right version), you would install a shell that could only be used to develop BI projects. When you are developing for the Microsoft Business Intelligence stack, you always needed Visual Studio for your business intelligence (SSIS, SSAS & SSRS) projects.
![Business intelligence development studio.](https://kumkoniak.com/107.jpg)