Đại học Thăng Long

Tổng quan về SQL Server

Giảng viên: Trần Quang Duy

13-Apr-20
 Content
1. Overview SQL Server 2008/2012
 SQL Server Edition
 SQL Server Components
2. SQL Server Management Studio
 Registered Servers
 Object Explorer
 Summary page

2/25
 Mục tiêu
 Objectives: In this hour you'll learn
 SQL Server 2008 Components
 The versions of SQL Server 2008 that are available
 Using SQL Server Management Studio

3/25
 Overview SQL Server 2008
 SQL Server is a database and data analysis platform
for large-scale online transaction processing
(OLTP), data warehousing, and e-commerce
applications. (Books online)

4/25
 SQL Server 2008 Edition
1. SQL Server 2008 Enterprise Edition (32-bit and 64-bit):
server environments
2. SQL Server 2008 Standard Edition (32-bit and 64-bit):
server environments
3. SQL Server 2008 Workgroup Edition (32-bit only): server
environments
4. SQL Server 2008 Developer Edition (32-bit and 64-bit)
5. SQL Server 2008 Express Edition (32-bit only)
6. SQL Server 2008 Mobile Edition (SQL Server CE)

5/25
 SQL Server 2008 Enterprise Edition
 Includes all the tools that you need to manage an
enterprise database management system.
 Offers a complete set of enterprise management and
business intelligence features, and provides the highest
levels of scalability and availability of all the SQL
Server 2008 editions.
 It supports an unlimited number of CPUs and provides
all the features unavailable in the other versions of SQL
Server 2005.

6/25
 SQL Server 2008 Standard Edition
 Is the data management and analysis platform for small-
and medium-sized organizations.
 It includes the essential functionality needed for e-
commerce, data warehousing, and line-of-business
solutions.
 Standard Edition is ideal for the small- to medium-
sized organization that needs a complete data
management and analysis platform.

7/25
 SQL Server Workgroup Edition
 Provides a great solution for small organizations or
workgroups within larger entities.
 It includes a rich feature set, but is affordable and
simple to work with. There is no limit on database size
and that it supports the SQL Agent Job Scheduling
Service
 The disadvantages of SQL Server 2008 Workgroup
Edition include
 Support for only three gigabytes of RAM
 Support for only two CPUs
 Absence of the Database Tuning Advisor
8/25
 SQL Server 2008 Developer Edition
 Is designed specifically for developers who are building
SQL Server 2008 applications.
 It includes all functionality of SQL Server 2008
Enterprise Edition, but with a special license that limits
its use to development and testing.
 Its license specifies that you cannot use it for production
development

9/25
 SQL Server 2008 Express
 Is a free, easy-to-use, and simple-to-manage database. Integrated
with Microsoft Visual Studio 2008
 SQL Server Express makes it easy to develop data-driven
applications that are rich in capability, secure in storage, and fast
to deploy.
 SQL Server Express is free and can be redistributed (subject to
agreement), and functions as the client database, as well as a
basic server database.
 Disadvantages:
 Support for only one gigabyte of RAM
 Support for a four-gigabyte maximum database size
 Support for only one CPU
 Absence of the SQL Agent Job Scheduling Service
 Absence of the Database Tuning Advisor
10/25
 SQL Server 2008 Mobile Edition
 Extends Microsoft enterprise solutions to line-of-
business and personal information management (PIM)
applications on a device.
 SQL Server 2008 Mobile Edition enables you to easily
port corporate applications over to mobile devices
 SQL Server Mobile is a mobile database platform that is
designed for developers who develop Microsoft
Windows mobile-based devices. Its characteristic
features are a robust data store, an optimizing query
processor, and reliable, scalable connectivity
capabilities
11/25
 SQL Server 2008 Components
 Database Engine
 Reporting Services
 Analysis Services
 Notification Services
 Integration Services
 Full-Text Search
 Replication
 Service Broker

12/25
 SQL Server Management Studio
 The main tool that use to administer SQL Server 2008
databases.
 To administer SQL Server instances, Analysis Services
instances, Integration Services instances, and Reporting
Services instances

13/25
 SQL Server Management Studio
 Running Management Studio
 Registering a SQL Server instance
 Exploring the Object Explorer
 Looking over the Summary tab
 Querying with the query pane
 Applying templates in Management Studio

14/25
 Starting SQL Server Management Studio
 On the Start\All
Programs\Micro
soft SQL Server
2008\SQL
Server
Management
Studio.
 In the Connect to
Server dialog
box, verify the
default settings,
and then click
Connect. 15/25
 SQL Server Management Studio
 Three component
 Registered Servers
 Object Explorer
 the Summary page

16/25
 Using Register Server
 On the Registered Servers
toolbar, click Database Engine
if necessary. (It may already be
selected.)
 Right-click Database Engine,
point to New, and then click
Server Registration. The New
Server Registration dialog box
opens.
 In the Server name text box,
type the name of your SQL
Server instance.
 In the Registered server name
box, type AdventureWorks.
 On the Connection Properties
tab, in the Connect to database
list, select AdventureWorks,
and then click Save.

17/25
 Object Explorer
 To connect with Object Explorer
1. Click the relevant icon on the Registered Servers toolbar to select the type
of instance to connect to.
2. Right-click the SQL Server instance that you want to connect to.
3. From the context menu, choose Connect\Object Explorer.
(Or On the toolbar of Object Explorer, click Connect to drop down the list of
possible connection types, and then select Database Engine. The
Connect to Server dialog box opens.)
 To connect with new query
1. Click the relevant icon on the Registered Servers toolbar to select the type
of instance to connect to.
2. Right-click the SQL Server instance that you want to connect to.
3. From the context menu, choose Connect\New Query.

18/25
 Exploring the Object Explorer
 The Object Explorer allows
 Create and manage databases
 View and modify database properties
 Create and manage database objects such
as tables and views
 Grant and revoke privileges and
permissions
 Configure replications
 Manage SQL Server Integration Services
packages
 View SQL Server and Windows log files
 Manage SQL Server Agent

19/25
 Sumary
 Provides
information
that
summarizes
some
characteristics
of the SQL
Server
instance

20/25
 Sumary - Report
 Report

21/25
Sumary - Report

22/25
 Query Pane
 To create a new query, click the New Query button on the
Standard toolbar.

 The five types of query supported in Management Studio are

Transact-SQL:Runs against the relational database engine

MDX (Multi-Dimensional Expressions):Runs against

Analysis Services
DMX (Data Mining Extensions):Runs against Analysis

Services
XMLA (XML for Analysis):Runs against Analysis

Services
SQL Server Mobile Query:Runs against an instance of

SQL Server 2005 Mobile Edition

23/25
 Customizing the Environment
 Customizing the Environment:Choose Tools\options
 Setting Startup options: General tab
 Displaying results: Query Results tab
 Keyboard shortcuts: General\Keyboard
 Restoring the default configuration: chooseWindow\Reset
Window Layout.
 Using templates in Management Studio: View\Template
Explorer.

24/25
 Reference
 Books online
 https://docs.microsoft.com/en-us/sql/sql-server/sql-server-
technical-documentation
 Pro SQL Server Administration, Peter A Carter, 2015,
Apress Pub, ISBN: 9781484207116
 Microsoft SQL Server2005 For Dummies, Published by
Wiley Publishing, Inc. 111 River Street

25/25