Standalone Microsoft SQL Server Management Studio

Finally! you can install Microsoft SQL Server Management Studio for Free! and without the need to install a SQL Server Instance!
It’s just awesome, isn’t it?

Here is the download link:
http://go.microsoft.com/fwlink/?LinkID=820751

Or if they canged it in the future you can find more details and the new doanload link in this MSDN page:
https://msdn.microsoft.com/en-us/library/mt238290.aspx

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. This release features improved compatibility with previous versions of SQL Server, a stand-alone web installer, and toast notifications within SSMS when new releases become available.

Version Information

This release of SSMS uses the Visual Studio 2015 Isolated shell.

The version number for SQL Server Management Studio June 2016 generally available release is: 13.0.15500.91

Supported SQL Server versions

This version of SSMS works with all supported versions of SQL Server (SQL Server 2008 — SQL Server 2016), and provides the greatest level of support for working with the latest cloud features in Azure SQL Database.

There is no explicit block for SQL Server 2000 or SQL Server 2005, but some features may not work properly.

Additionally, this version of SSMS can be installed side-by-side with earlier released non-preview versions.

Supported Operating systems

This release of SSMS supports the following platforms when used with the latest available service pack:

Windows 10, Windows 8, Windows 8.1, Windows 7 (SP1), Windows Server 2012 (64-bit), Windows Server 2012 R2 (64-bit), Windows Server 2008 R2 (64-bit)

I hope this helps and you can just simply get access to your remote SQL instances (as that is normally the scenario you work on.

Who needs a local SQL Server Instance running on their dev box? I’m going to uninstall all those server instances right now!