Активное администрирование в SQL Server
-
: Microsoft SQL Server
6.0.
:
423
-
1999.
.
..39
1.
1.2.
,
,
.
, ,
.
, ,
.
,
.
,
.
, ,
.
-
,
. ,
,
. , . ,
,
.
2.Microsoft SQL Server 6.0
Microsoft SQL Server 6.0
-. ,
,
, ,
.
Microsoft SQL Server ,
. SQL Server
.
, -
. Microsoft SQL Server
Microsoft BackOffice, ,
.
Microsoft SQL Server ,
-.
,
.
,
,
.
Microsoft SQL Server 6.0
, (Dynamic Locking),
.
Microsoft SQL Server
, Oracle, IBM DB2, Sybase, Microsoft Access
ODBC ,
(ODBC Open DataBase Connectivity, Microsoft,
,
).
, OLE Automation,
,
OLE, SQL Server.
Visual Basic 4.0 32-
DB-Library (OCX). Transact-SQL
,
..
Microsoft SQL Server 6.0. .
.
,
( ) ,
, ,
, .
. Enterprise Manager
.
, :
,
( );
;
;
- ;
;
/
;
: ,
, .
, , Microsoft SQL Server
6.0. Microsoft SQL Server 4.x
Sybase. SQL Server
.
,
.
,
.
.
SQL Server
.
Microsoft SQL Server 6.0.:
SQL Setup ,
SQL Server .
Setup
, , Master
.
SQL Service SQL Server
Manager (SQL Server SQL Executive).
iSQL/w Transact-SQL
.
SQL Security
Manager SQL.
SQL Client Server
.
SQL Transfer Manager
Server .
SQL Trace ,
, Microsoft SQL Server 6.0. SQL Trace
,
, .[1]
2.1. SQL Server 6.0.
Server
SQL Server
Server. ,
Microsoft SQL Enterprise Manager
,
. ,
,
( , ,
, ..).
,
, , ,
,
.
,
.
Microsoft SQL Server
.
,
,
,
. Microsoft SQL Server
(alert),
.
.
,
. SQL Server
.
.
:
, *.CMD *.EXE
Transact-SQL ( ).
,
,
(,
). ,
,
.
,
. .
, ShutDown Server,
. ,
. , Windows NT
, . ,
SQL Server SQL Executive
, . SQL
Server , ,
. ,
, .
, .
, ,
: ,
, .
OLE, SQL-DMF
.
: SQL Enterprise Manager 32-
,
. SQL-Distributed Management Objects
(SQL-DMO) , OLE automation ,
. SQL Executive
,
,
, , .
, OLE, SQL
DMF ,
Visual Basic Visual Basic for Applications (VBA) , ,
, Visual FoxPro.
SQL-DMF .
- ,
.
. Microsoft SQL Server,
,
.[2]
3. Microsoft SQL Server
Microsoft SQL Server 6.0 ,
Microsoft SQL Server,
. SQL Server 6.0
- ,
, DBMS ,
. Microsoft SQL Server 6.0
OLE .
SQL Server 6.0 ,
ANSI SQL ,
,
, ANSI.
3.1.
Microsoft SQL Server
SQL Server,
SQL Server. ,
, SQL
Server. ,
. SQL
Server, , ,
, .
, ,
.
, Transact-SQL,
SQL ( ). ,
Microsoft Windows NT, Microsoft Windows 95/98, Microsoft
Windows MS-DOS.
3.2.
SQL Server 6.0 -
.
Online Help
, Help SQL Server,
Help F1 SQL Enterprise Manager ISQL/W. isql,
sp_helpsql.
SQL Server Books Online
Microsoft SQL Server Books
Online. ,
Books Online Microsoft SQL Server 6.0.
,
SQL Server.
Microsoft SQL Server
,
.
. ,
,
, , ,
, .
.
Microsoft SQL Server
Transact-SQL, SQL,
,
, , ,
.
Microsoft SQL Server Transact-SQL Reference
, Transact-SQL
, ,
Transact-SQL, ,
.
Microsoft SQL Server Setup
SQL Server
6.0.
Microsoft SQL Server Programming SQL Distributed Management Objects
SQL Distributed
Management Objects, 32- OLE Automation
Microsoft Windows 95 Windows NT. ,
, ,
SQL Server .
Microsoft SQL Server Programming DB-Library for C
DB-Library:
(API), ,
C/C++ Microsoft Windows NT, Microsoft
Windows 95, Microsoft Windows MS-DOS .
Microsoft SQL Server Programming DB-Library for Visual Basic
DB-Library API,
Microsoft
Visual Basic Windows.
Microsoft SQL Server Programming Open Data Services
Microsoft Open
Data Services API, , C/C++
Windows NT.
4. Microsoft SQL Server
Microsoft SQL Server 6.0,
/
. Microsoft SQL Enterprise Manager,
SQL Server 6.0, - ,
,
SQL Server 6.0.
Microsoft SQL Server 6.0 -
,
/ -
. Microsoft SQL Server 6.0
Microsoft Windows NT
.
4.1.
- , ,
, ,
, , , .
.
- .
. SQL Server
: , ,
, .
SQL Server ,
MASTER, MSDBDATA MSDBLG. model, tempdb,
pubs MSDBDATA,
msdb MSDBLOG.
, ,
. ,
,
.
4.1.1.
SQL , MASTER
,
.
SQL Server .
, ,
, ,
, ,
SQL Server,
, , .
, .
. MASTER ,
.
,
- , , ;
MASTER; ,
.
4.1.2. model
SQL Server , MASTER
. ,
- model.
, .
, , SQL Server
model
.
,
model.
model
.
, model,
.
model:
, ,
, .
,
SQL Server.
model.
.
,
model.
, model
.
4.1.3. msdb
msdb SQL Executive
.
,
(2 MB 1 MB)
msdb 2-MB (MSDBDATA)
1-MB (MSDBLOG).
4.1.4. tempdb
SQL Server , MASTER
. ,
- tempdb.
. , tempdb.
tempdb, ,
, .
tempdb.
tempdb - ,
SQL Server.
tempdb, SQL Server
.
, .
.
tempdb - 2 MB.
tempdb:
(
tempdb)
GROUP BU
tempdb. ,
tempdb MASTER .
MASTER
.
4.1.5. pubs
pubs - ,
MS SQL Server. pubs
Microsoft SQL Server.
pubs Microsoft SQL Server,
.
4.2.
- (), .
SQL Server .
.
.
, SQL
Server.
, .
sys.
4.2.1.
- ,
.
SQL Server Setup ,
, .
4.2.2.
,
.
SQL Server ,
.
. ,
syslogs DELETE, UPDATE INSERT.
SQL Server .
, syslogs
, , , .
4.3.
-
Transact-SQL . -
SQL Server
.
sp_.
MASTER,
.
, MASTER,
, .
Transact-SQL , ,
.
,
, SQL Server.
SQL Server
(DLL)
,
. SQL Server
SQL Server.
SQL Server ,
,
.
, Microsoft Open Data
Services.
4.4.
, SQL Server
. - 256 , ,
. 128
. 128 .
- , , SQL Server
.
,
SQL , GROUP BY, ORDER BY DISTINCT.
, ,
, , WHERE DISTINCT.
, SQL Server
, .
- ANSI (ISO 8859-1),
- .
,
.
Microsoft SQL Server.
, SQL Server
, MASTER.
SQL Server
,
.
5.
SQL
Server 6.0. ,
.
6.
,
-
Microsoft SQL Server 6.0, Windows NT
.
Microsoft SQL Server:
SQL Setup - , .
,
, , master,
,
, , SQL Server.
SQL Service Manager - , , ,
SQL Server SQL Executive.
ISQL/w - Transact-SQL
. ISQL/w
.
SQL Security Manager -
SQL Server, Windows NT.
SQL Enterprise Manager -
.
, .
,
, ,
, .
SQL Transfer Manager - ,
SQL Server .
Microsoft SQL Server Windows NT.
SQL Performance Monitor - Windows NT Performance Monitor SQL
Server, .
SQL Server Books Online -
Microsoft SQL Server.
.
Microsoft ODBC SQL Server Driver - ,
Microsoft ODBC SQL Server Driver.
SQL Distributed Management Objects - ,
Microsoft SQL Distributed Management Object Model.
SQL Client Configuration Utility -
.
DB-Library
DB .
,
Server:
bcp - .
isql -
.
, SQL
.
makepipe readpipe - .
, SQL
Server, Transact-SQL.
7.
,
:
32-
,
32- ,
(, , DB)
,
, .
,
32- :
ISQL/w
SQL Security Manager
SQL Enterprise Manager
SQL Server Books Online
SQL Client Configuration
bcp
isql
makepipe readpipe
16-
16-
SQL Servers Tools program group, SQL
Client Configuration Utility, ISQL/w, SQL Server Books Online.
8. SQL Server
SQL Server:
(Sas), (DBOs),
.
(SA) -
, .
(SA) SQL Server;
;
, ;
; SQL Server
; SQL Server;
; ;
; SQL Server;
.
.
SA ; SQL Server
SA. SA ,
. , SA
SA.
(DBO) - , .
. DBO
,
. ,
DBO; ,
. DBO
. login ID DBO,
login Ids DBO. ( -
, login
Ids). ,
, . SA
DBO - .
- ,
(, , , ,
, ).
.
.
.
,
.
.
.
login Ids - probe, repl_publisher,
repl_subscriber -, , ,
.
SQL Server , login probe ID.
- login ID,
,
(, SQL Performance
Monitor) SQL Server,
. , SQL Server
, SA probe.
,
, repl_publisher login ID.
(
,
/),
.
,
, repl_subscriber login ID.
,
.
9. SQL Server
SQL Server,
- login ID ,
.
9.1. SQL Server
SQL Server SQL Executive.
SQL Service Manager
9.2.
,
login ID ( ,
SQL Server).
, ,
, ,
SQL Server, .
, SQL Server, ,
, login ID . , SQL
Server, isql.
, :
isql/U login_id/P password/S servername,
Login_id - .
sa . ,
, SQL , login
ID .
Password - . sa
.
Servername - .
SQL ,
sa . ,
, SA,
.
, SA
, SQL Enterprise Manager sp_password.
9.3. SQL Server
SQL Server SQL Executive.
SQL Service Manager.
, SQL Server, SQL Service
Manager MSSQL Server , SQL
Server .
. ,
, SQL Server.
SQL Executive , SQL Server.
10. SQL Server
SQL
.
- 256 SQL Server.
- 32 . (
- 8 TB (256 * 32 GB ).
32,767 . - 1 MB.
- 1 (TB). (
32 GB,
32 (32 GB * 32 = 1 TB).
- 2 .
- 1962 ( ).
- 1 TB.
- 250 .
- 1 249 .
16 .
- - INSERT, UPDATE,
DELETE. 16 .
255
16 .
- 32,767 ( Microsoft SQL Server 6.0
Workstation Microsoft SQL Server,
, - ,
15 .
- 32,767
- 2 (2,147,483,647)
- 2 (2,147,483,647)
11. SQL Distributed Management Framework
SQL Distributed Management Framework (SQL-DMF) -
, , ,
Microsoft SQL Server. SQL-DMF
, .
SQL-DMF
- , , , -
, SQL
Server.
SQL-DMF - SQL Server.
SQL-DMF SQL Server ,
, ,
, - ,
.
, SQL-DMF SQL
Server Engine Transact-SQL.
-
(DMOs), SQL Server Engine.
- , SQL
Enterprise Manager,
.
, , .
SQL Server Engine - Transact-SQL,
SQL. Transact-SQL,
, , ,
. , ,
SQL Server.
(DMOs) - 32- OLE
SQL . DMO
60 1000 . SQL Server
DMO , ,
Transact-SQL , ,
, , .
Microsoft SQL Enterprise Manager ,
, Microsoft
SQL Server . SQL Enterprise Manager
SQL Server, , ,
; ; ;
, .
11. Microsoft SQL Enterprise Manager
Microsoft SQL Enterprise Manager - -
Microsoft SQL Server 6.0. -
SQL Server .
SQL Enterprise Manager
.
,
.
SQL
Server -, ,
. ,
SQL Server
.
SQL Enterprise Manager
Server Windows NT ,
Windows NT - Windows95. (
SQL Enterprise Manager - 32- ,
, 16- .)
SQL Server SQL Enterprise
Manager; - .
SQL Enterprise Manager
.
(SA),
. - (DBO),
,
DBO. ,
,
.
SQL Enterprise Manager :
- SQL Server
- ,
-
-
-
-
-
-
-
- SQL
-
- login Ids
-
-
- SQL Server
The Server Manager Window
Server SQL Enterprise Manager
. ,
. [3]
:
., ., . .- .:
, 1997.- . 100-105.
., ., . Microsoft SQL Server
.- .: , 1998.- .80-190.
Database Administrators Companion: Microsoft SQL Server.- Microsoft
Corporation, 1998.- c. xi-35.