Page 171 - DCAP609_CLOUD_COMPUTING

Cloud Computing

Notes All communications with the server go through the security layer. Good security for a
server is too complex a subject for now. The security layer is a blending of operating
system functions and functions specific to SQL Server.
Jump below the picture to continue with a discussion of SQL and the layers above it.
Figure 11.1: SQL Server Application

Source: http://www.databasezone.com/techdocs/sql_server.html
SQL is the communications protocol between the SQL Server and the outside world. Most
communications with SQL Server are in Standard Query Language (SQL).
Look to the top-right at SQL Server Management Studio. Management Studio is a
development environment that is installed on the developer’s machine. It comes with SQL
Server, but doesn’t need to be on the same machine. A free version of SQL Server and
Management Studio is available on the Microsoft website. You are probably safe
downloading the third option “Database with Management Tools”. If you have 64-bit
Vista or 64-bit Windows 7 you can download and install the 64-bit version. The 32-bit
version will work on either 32-bit or 64-bit Windows.
SQL Server Management Studio gives us a single location to manage our SQL Servers and
develop and test our databases and SQL code.

!
Caution Before we can manage servers or run SQL code we must set up a connection to each
server we want to work with. The servers can be anywhere. The only requirements are a
network connection and security clearance.

166 LOVELY PROFESSIONAL UNIVERSITY