1 / 4

SQL Server Management Studio Introduction

SQL Server Management Studio Introduction. 2914. What Is It. SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

wayne-figueroa
Download Presentation

SQL Server Management Studio Introduction

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server Management Studio Introduction 2914

  2. What Is It • SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. • SQL Server Management Studio combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators. • SQL Server Management Studio combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. • In addition, SQL Server Management Studio works with all components of SQL Server such as Reporting Services.

  3. Tool Windows in SQL Server Management Studio • Tools • Using Object Explorer Browse servers, create and locate objects, manage data sources, and view logs. This tool is accessed from the View menu. • Managing Registered Servers Store connection information for frequently accessed servers. This tool is accessed from the View menu. • Using Solution Explorer Store and organize scripts and related connection information in projects called SQL Server Scripts. You can store several SQL Server Scripts as Solutions and use source control to manage scripts as they evolve over time. This tool is accessed from the View menu. • Using SQL Server Management Studio Templates Create queries based on existing templates. You can also create your custom queries or alter the existing templates to fit your scenarios. This tool is accessed from the View menu • .Dynamic Help Show a list of related Help topics as you click on a component or type code.

  4. Administering Servers with SQL Server Management Studio • Use Management Studio to: • Register servers. • Connect to an instance of the Database Engine • Configure server properties. • Manage database and SSAS objects such as cubes, dimensions, and assemblies. • Create objects, such as databases, tables, cubes, database users, and logins. • Manage files and file groups. • Attach or detach databases. • Launch scripting tools. • Manage security. • View system logs. • Monitor current activity. • Configure replication. • Manage full-text indexes. • Work citied http://msdn.microsoft.com/en-us/library/ms174173.aspx

More Related