Development Desktop

One of the great things about the Microsoft development tools is that you can keep your desktop up-to-date, yet still develop for older SQL Server platforms. Unlike some earlier releases, Visual Studio 2017 is extremely stable, so we highly recommend upgrading your desktop tools to this version.

Minimum Toolset

As a minimum, you will need to have the following installed on your desktop machine:

• Visual Studio 2017
• SSDT for Visual Studio adds support for Analysis Services, Integration Services and Reporting Services to Visual Studio
• SQL Server Management Studio
• BI Developer Extensions extension for Visual Studio (formally BIDS Helper)

T-SQL Development

Apart from SSDT and SSMS outlined above, you may consider extending your toolset with the following:

• RedGate SQL Search a free tool to search your SQL code on your deployed databases
• RedGate SQL Toolbelt Essentials a paid for toolset which encompasses 10 tools including ** SQL Prompt which helps you write, format, analyze and refactor your SQL effortlessly ** SQL Schema Compare ** SQL Data Compare ** SQL Data Generator ** Do not make the mistake of using SQL Source Control product as this works counter to how SSDT.

SSIS Development

We strongly recommend developing all your new SSIS packages using BIML. Cathrine Wilhelmsen has published many blogs and useful guides to BIML development on her web site.

• Varigence BIML Express extension for Visual Studio

Tabular Cube Development

• BISM Normalizer Beyond Compare 4