Installing SSDT

SQL Server data tools (SSDT) for those that don’t know is an IDE for building SQL server content (Relational DBs, SSIS, SSRS or SSAS projects and packages). It’s gone by a few different names over the years (and versions) but broadly speaking, no matter the name, they all have the same look and feel. What has changed though, is how you install it.

Prior to SQL server 2012, BIDS ( Business Intelligence Development Studio) was as an optional install within every SQL server installation to develop SSIS, SSAS, SSRS packages. It did not however support the development of relational databases. However…