locked
sql management studio RRS feed

  • Question

  • User576623942 posted

    hello, i am very new to the .NET world. For real world web applications and website, do I need to use sql server management studio? Or the inbuilt server explorer and stuff is enough? Sorry if this sounds silly. Just wanted to clear all my doubts before proceeding ahead

    Friday, November 10, 2017 10:15 AM

Answers

  • User347430248 posted

    Hi pjanicked,

    Sql Management Studio provides below features.

    Supports most administrative tasks for SQL Server.

    • A single, integrated environment for SQL Server Database Engine management and authoring.

    • Dialogs for managing objects in the SQL Server Database Engine, Analysis Services, and Reporting Services, that allows you to execute your actions immediately, send them to a Code Editor, or script them for later execution.

    • Non-modal and resizable dialogs allow access to multiple tools while a dialog is open.

    • A common scheduling dialog that allows you to perform action of the management dialogs at a later time.

    • Exporting and importing SQL Server Management Studio server registration from one Management Studio environment to another.

    • Save or print XML Showplan or Deadlock files generated by SQL Server Profiler, review them later, or send them to administrators for analysis.

    • A new error and informational message box that presents much more information, allows you to send Microsoft a comment about the messages, allows you to copy messages to the clipboard, and allows you to easily e-mail the messages to your support team.

    • An integrated Web browser for quick browsing of MSDN or online help.

    • Integration of Help from online communities.

    • A tutorial on SQL Server Management Studio to help you take advantage of the many new features and become more productive right away.

    • A new activity monitor with filtering and automatic refresh.

    • Integrated Database Mail interfaces.

    Reference:

    Features in SQL Server Management Studio

    you may find that some of the features are not available in the Server Explorer which are available in the Management Studio.

    Server Explorer

    so you can try to refer both of them and check what kind of feature provided by both and then according to your requirement you can consider to use anyone of it or both of it.

    Regards

    Deepak

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, November 13, 2017 6:02 AM

All replies

  • User753101303 posted

    Dépends what you are doing. Visual Studio should be enough for dev related stuff.

    SSMS still have additional features related to SQL Server administration (and I'm using it since long ago so I'm still doing all SQL related stuff using SSMS even when VS is enough).

    Friday, November 10, 2017 10:58 AM
  • User-1716253493 posted

    AFAIK, you still need Sql Management Studio.

    There are many features in Management Studio that not exist in server explorer.

    For example export/import data, generate script and more features

    For easy way, use SQL Management Studio to manage your databases, not for web app only.

    Sunday, November 12, 2017 12:48 PM
  • User347430248 posted

    Hi pjanicked,

    Sql Management Studio provides below features.

    Supports most administrative tasks for SQL Server.

    • A single, integrated environment for SQL Server Database Engine management and authoring.

    • Dialogs for managing objects in the SQL Server Database Engine, Analysis Services, and Reporting Services, that allows you to execute your actions immediately, send them to a Code Editor, or script them for later execution.

    • Non-modal and resizable dialogs allow access to multiple tools while a dialog is open.

    • A common scheduling dialog that allows you to perform action of the management dialogs at a later time.

    • Exporting and importing SQL Server Management Studio server registration from one Management Studio environment to another.

    • Save or print XML Showplan or Deadlock files generated by SQL Server Profiler, review them later, or send them to administrators for analysis.

    • A new error and informational message box that presents much more information, allows you to send Microsoft a comment about the messages, allows you to copy messages to the clipboard, and allows you to easily e-mail the messages to your support team.

    • An integrated Web browser for quick browsing of MSDN or online help.

    • Integration of Help from online communities.

    • A tutorial on SQL Server Management Studio to help you take advantage of the many new features and become more productive right away.

    • A new activity monitor with filtering and automatic refresh.

    • Integrated Database Mail interfaces.

    Reference:

    Features in SQL Server Management Studio

    you may find that some of the features are not available in the Server Explorer which are available in the Management Studio.

    Server Explorer

    so you can try to refer both of them and check what kind of feature provided by both and then according to your requirement you can consider to use anyone of it or both of it.

    Regards

    Deepak

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, November 13, 2017 6:02 AM
  • User576623942 posted
    Thank you for all your responses. Got a good idea about it. Thank you. Happy coding!
    Monday, December 4, 2017 1:07 PM