563 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Introduction to SQL Server Management Studio
Part one of a two-part series of blogs
Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio.
SQL Server Management Studio is the application that allows you to do everything with a SQL Server installation. You can use it to create, delete and maintain databases, write and execute queries and stored procedures, and a host of other tasks. This short article introduces you to the basics of the application to help familiarise you with the Management Studio environment.
Assuming you've installed Microsoft SQL Server 2005 or later on your computer you will have access to the Management Studio application from the Start menu.
This machine has several versions of SQL Server installed. Here we're opening the version of Management Studio that was installed along with SQL Server 2008 R2.
When you choose to open Management Studio, before you can start working with the application, you are asked to connect to a server. You don't have to do this at this stage but it makes sense to do so and the diagram below explains how:
This dialog box allows you to connect to a server. The options shown are described below.
Once you have followed the steps above you will see the server you selected appear at the left hand side of the screen.
The server you selected will appear in the Object Explorer window at the left of the screen.
You can disconnect from a server by right-clicking on the server name and choosing the option shown in the diagram below:
Right-click on the name of the server and choose the option shown here to disconnect from it.
You can reconnect to a server using the Connect tool at the top of the Object Explorer window, as shown below:
Choose the type of server to which you want to connect.
When you choose an option from the list you'll be presented with the same dialog box you see when you open Management Studio for the first time.
You can close any windows in Management Studio by clicking the cross in the top right hand corner of the window.
Click the cross in the top right hand corner to close the selected window.
To open a window that is closed you can use the View menu at the top of the screen.
Click on the name of the window you want to open. You can also use the keyboard shortcuts listed next to certain windows to open them.
Rather than closing and reopening windows you might find it easier to auto-hide them instead.
To auto-hide a window, click the vertical pushpin icon in the top right hand corner.
Once you have chosen to auto-hide a window it will collapse into a tab at the edge of the screen. The diagram below shows how to bring it back.
|Move the mouse cursor over the tab...||...to make the window pop out.|
You can stop the window from auto-hiding by clicking the pushpin icon again at the top right hand corner of the window.
Click the horizontal pushpin icon to pin the window in place.
|Parts of this blog|
25 Aytoun Street