Thursday, June 30, 2016

Introduction to SQL Server 2012

Microsoft SQL Server Management Studio is a powerful and flexible tool.
This lesson shows you how the windows work together to present a design surface that makes your work easier. At the end of this lesson, you will know how to clear unwanted windows out of your way, how to quickly bring up windows with the information you need, and how to configure the default surface to support the work you do most often.

o   Starting SQL Server Management Studio
o   Connecting with Registered Servers and Object Explorer
o   Changing the Environment Layout
o   Displaying the Document Window
o   Showing the Object Explorer Details page


Starting SQL Server Management Studio: - Click Windows button, on the Start menu, point to All Programs, point to Microsoft SQL Server 2012, and then click SQL Server Management Studio. Alternately from the Run dialog box, type SSMS.exe and then click OK


In the next step, you connect to SQL Server using the Object Explorer component of SSMS. Click Object Explorer. In the Object Explorer menu, click the Connect button, and then click Database Engine.

The Connect to Server dialog box should appear. (If you have previously installed SSMS, the user settings might be causing the Connect to Server dialog box to appear automatically.)


In the Connect to Server dialog box, complete the Server name box. You can connect to one of three types of SQL Server. Each type has a slightly different format for the Server name box. Pick one of the following formats:

--
 A default instance of SQL Server: When you install SQL Server on a computer, you can specify that the instance of SQL Server will be a default (unnamed instance) or a named instance.
If you are connecting to a default instance of SQL Server, insert the name of the computer. For example, if you are running SSMS on a computer named Accounting and you are connecting to a default instance of SQL Server installed on that computer, type Finance in the Server name box.

--
 A named instance of SQL Server: During setup of SQL Server, you can specify a name for the instance; for example on a computer named Finance, you could specify a named instance named Department. To connect to a named instance, in the Server name box, type the computer name backslash instance name; for example Finance\ Department.




Database information is shown in Object Explorer and document windows.
Object Explorer is a tree view of all the database objects in a server.
This can contain the databases of the
·         SQL Server Database Engine,
·         Analysis Services,
·         Reporting Services,
·         Integration Services.
Object Explorer includes information for all servers to which it is connected. When you open Management Studio, you are prompted to connect Object Explorer to the settings that were last used. You can double-click any server in the Registered Servers component to connect to it, but you do not have to register a server to connect.
The document window is the largest portion of Management Studio.
The document windows can contain query editors and browser windows. By default, the Summary page is displayed, connected to the instance of Database Engine on the current computer.