Is there a SQLDeveloper for Microsoft SQL Server?

Question

What is the recommended tool for developing against a Microsoft SQL Server database? We have a legacy Microsoft SQL Server that I'm developing new services for. I have never worked with Microsoft SQL Server before.

For example, for developing against Oracle databases, currently I use Oracle SQLDeveloper to figure out queries and explore indexes, etc.

Answer 1

Typically, you will use SQL Server Management Studio or SSMS. You can also use Visual Studio.

Answer 2

You can download Microsoft SQL Server Management Studio Express to get started.

Choose the last Download button corresponding to ENU\x86\SQLManagementStudio_x86_ENU.exe, if you only want the Management Studio.

Descriptions about the other executables are listed on the page.