emule resources can also be downloaded with thunder
| The following is a list of files that are shared by users, and you can download them by clicking on them after you install emule |
| [0 Basic science sql.server.2005. E-Tutorials/cd].0sql with books. Server.2005.iso Details |
12.2MB |
| [0 sql.server.2005 of basic science. E-Tutorials/books CD].0sql.server2005dianzijiaocheng.rar Details |
52.3MB |
Chinese name: 0 Basics SQL Server 2005 Electronic Tutorials/Books CD
Resource Type: ISO
version: Electronic tutorials/CD with books
Release Time: December 2007
Area: Mainland
language: Mandarin
Brief Introduction：
--> -->
Publishing House: Machinery Industry Publishing House
Series Name: 0 BASIC Programming
Author: meter/
Release Date: December 2007
The essence of the book
installation, upgrade of SQL Server 2005
Concepts, classifications, data types, and database objects for databases
Management, maintenance, browsing and modification of data tables
installation, anatomy, and use of the SQL Server 2005 self-with database
table, view editing, maintenance, and management (including administration using SQL statements)
Data additions, deletions, modifications, and queries in the database
Detailed explanations of T-SQL statements, syntax, variables, constants, and cursors.
Stored procedures, functions, constraints, triggers, transactions, and locks
Indexing and query optimization
application configuration, Engine tuning, and dedicated tools for SQL Server 2005
Database server connections, configurations, logs, and dynamic management views
Managing, detaching, attaching, snapshots and partitioning of databases
Database security management, permissions, users, keys
Backup and recovery of databases
System Automation: Agents, jobs, maintenance plans, alerts
Copy, publish, subscribe to database system
Full-Text Search of database system
The interaction of the database file with the XML file
Monitoring of database systems
SQL Server 2005 Business Intelligence: streaming, packages, Reporting Services, and more
An example of database development under .net
Book Catalogue:
The first SQL Server and database basics
1th Chapter SQL Server 2005 Overview 1
1.1 SQL Server Introduction 1
Development of 1.1.1 SQL Server 1
1.1.2 SQL Server 2005 version Performance 2
1.1.3 Transact-SQL language Introduction 2
1.2 SQL Server 2005 architecture design and new features 3
1.2.1 SQL Server 2005 's schema 3
New features and improvements for 1.2.2 SQL Server 2005 4
1.2.3 SQL Server 2005 Service Process 5
Chapter 2nd installation of SQL Server 2005 7
2.1 Preparing to install SQL Server 2005 7
2.1.1 Select the correct SQL Server 2005 database version 7
Hardware requirements for 2.1.2 Installation 8
2.1.3 Operating system support and software requirements 8
2.1.4 Basic installation Option 10
2.2 Installation Process 10
2.2.1 What is SQL Server instance 10
2.2.2 Install SQL Server 2005 11
2.2.3 How to view SQL Server 2005 Setup log file 17
2.2.4 Authentication Installation 19
2.3 Configure Server Options 20
2.4 Upgrade to SQL Server 2005 21
Issues to consider before 2.4.1 upgrade 21
2.4.2 using SQL Server 2005 Upgrade Advisor 21
2.4.3 upgrade to SQL Server 2005 23
3rd Chapter SQL Server Database Basics Overview 24
3.1 Database Basic Concepts 24
3.1.1 Data and Information 24
3.1.2 Database 24
3.1.3 Database System 24
3.1.4 Database Management System 24
3.2 Basic functions of database management System 25
3.2.1 Definition Data 25
3.2.2 Processing Data 25
3.2.3 Database Run Management 25
3.2.4 data organization, storage, and management 25
Establishment and maintenance of 3.2.5 database 26
3.3 Type of database 26
3.3.1-Level Database 26
3.3.2 Network Type Database 26
3.3.3 Relational Database 26
database objects for SQL Server 3.4 26
3.4.1 Table 26
3.4.2 View 27
3.4.3 Index 28
3.4.4 PRIMARY Key 28
3.4.5 FOREIGN Key 28
3.4.6 Stored Procedure 28
3.4.7 Trigger 30
3.4.8 Data Type 30
3.4.9 Constraint 30
3.4.10 Default Value 31
3.4.11 role 31
3.4.12 User 31
3.4.13 Architecture 31
3.5 Data Type 31
3.5.1 data type and features 32
3.5.2 Numeric data Type 32
3.5.3 Character data type 32
3.5.4 Date Time Data type 33
3.5.5 Binary Data Type 33
3.5.6 Other data Types 33
3.6 Data Definition Language 33
3.7 Data Manipulation Language 34
3.8 Data Control Language 34
3.9 Data Query Language 34
4th Chapter SQL Server Management Studio Manager 35
4.1 SQL Server Management Studio Introduction 35
4.1.1 Launch SQL Server Management Studio Tool 35
4.1.2 Connect Registered Servers and Object Explorer 36
4.1.3 Change Environment Layout 39
4.1.4 Set startup option 40
4.1.5 Query/Code Editor 41
4.1.6 Using Template Explorer, solution, script project 42
4.2 Using SQL Server Management Studio Design Database 43
4.2.1 CREATE DATABASE 44
4.2.2 Additional Database 45
4.3 Using SQL Server Management Studio Design Datasheet 47
4.3.1 New Datasheet 47
4.3.2 Modify Datasheet 48
4.3.3 View Table Properties 48
4.3.4 Delete data Table 49
4.4 Using SQL Server Management Studio to create an index 50
4.4.1 Create primary key index 50
4.4.2 Create a unique index 51
4.4.3 View index of Table 52
4.4.4 Delete Index 53
4.5 Maintenance Data Sheet 53
4.5.1 Inserts a new column in the table 53
4.5.2 Change the order of the columns in the table 54
4.5.3 autonumber column and identifier column 54
4.5.4 computed Column 55
4.5.5 Delete Field 55
4.6 Data Table Browse 56
4.6.1 View all records in a table 56
4.6.2 View a record of a table 56
4.7 Maintenance of data in data tables 57
4.7.1 add a new record 57
4.7.2 Modify existing Records 58
4.7.3 Delete Record 58
5th. SQL Server 2005 Case Study 59
5.1 AdventureWorks sample Database Introduction 59
5.1.1 Case Background 59
5.1.2 Installation Example 59
Structure of the 5.2 AdventureWorks sample database 61
5.2.1 AdventureWorks Database Data Type 61
5.2.2 AdventureWorks database Architecture and data table 62
5.2.3 AdventureWorks Database Stored procedure 66
5.2.4 AdventureWorks Database User-defined function 68
5.3 AdventureWorks Sample Database Logical Structure 70
5.3.1 Sales and marketing structure 70
5.3.2 Product Structure 74
5.3.3 Procurement programme and supplier structure 76
5.3.4 Production Structure 77
The second database basic management
6th Chapter Data Table 81
6.1 Creating table 81 with CREATE TABLE statement
6.1.11 small instances of creating a table 81
6.1.2 Basic Syntax 83
6.1.3 Create automatic Number column 84
6.1.4 Create a non-empty column 87
Default value of 6.1.5 Field 88
6.1.6 Select Table Storage file Group 89
6.1.7 using CHECK Constraint 90
6.1.8 set the collation of the field 91
6.2 Modifying table 92 with ALTER TABLE statement
6.2.1 Basic Syntax 92
6.2.2 Modify Field Properties 93
6.2.3 Add Field 94
6.2.4 Delete Field 95
6.2.5 Add constraint 95
6.2.6 Disable/enable CHECK constraint 98
6.2.7 Delete constraint 99
6.2.8 Set PRIMARY KEY 99
6.3 Delete data table 100 with drop table
Syntax structure of 6.3.1 DROP table 100
6.3.2 use drop table to delete datasheet 100
6.4 Temporary Table 100
6.4.1 example of creating a temporary table 101
6.4.2 example of deleting a temporary table 101
7th Chapter View 103
7.1 Understanding View 103
7.1.1 What is View 103
Type of 7.1.2 View 103
Advantages of 7.1.3 View 104
Constraints on the 7.1.4 view 104
7.2 Creating Views in SQL Server Management Studio 104
7.2.1 Use SQL Server Management Studio to create a standard view 105
7.2.2 View structure Information 106
7.2.3 View Results 107
7.3 Creating view with CREATE VIEW 108
7.3.1 example of creating a view using CREATE VIEW 108
7.3.2 Basic Syntax 108
7.3.3 Operation Example 109
7.4 Modifying view 112 in SQL Server Management Studio
7.4.1 Use SQL Server Management Studio to modify simple view 112
7.4.2 general procedure for modifying views using SQL Server Management Studio 113
7.5 Modifying view with ALTER VIEW 113
7.5.1 Example 113 using ALTER view to modify a view
7.5.2 Basic Syntax 114
7.5.3 Operation Example 115
7.6 Modifying data by View 117
7.6.1 example of using views to modify data 117
7.6.2 Operating Instructions Summary 118
7.7 Delete view 118 in SQL Server Management Studio
7.7.1 example of deleting a view using SQL Server Management Studio 119
7.7.2 general procedure for deleting views using SQL Server Management Studio 119
7.8 Delete view with drop view 120
7.8.1 Basic Syntax 120
7.8.2 example of deleting a view using Drop view 120
8th Chapter Data Operation 121
8.1 Query records with SELECT statement 121
8.1.1 SELECT statement 121
8.1.2 FROM clause 123
8.1.3 into clause 125
8.1.4 WHERE clause 127
8.1.5 ORDER BY clause 130
8.1.6 GROUP BY clause 131
8.1.7 HAVING clause 132
8.1.8 for clause 133
8.1.9 COMPUTE clause 133
8.1.10 distinct and all keyword 135
8.1.11 except and intersect keyword 137
8.1.12 Top N and Top N percent keyword 139
8.2 Use Connection 140
8.2.1 Internal Connection 141
8.2.2 LEFT Outer connection 142
8.2.3 Right Outer connection 143
8.2.4 Full External Connection 143
8.2.5 Cross Connection 143
8.3 Inserting records with INSERT statement 144
8.3.1 Simple INSERT Statement 144
8.3.2 INSERT statement Basic Syntax 145
8.3.3 146 of records inserted with values less than the number of fields
8.3.4 Insert field value in identity column field 146
8.3.5 a record from the datasheet and inserts it into another table 147
8.3.6 inserts data into uniqueidentifier column 148 by using NEWID ()
8.4 Update records with UPDATE statement 149
8.4.1 Simple UPDATE statement 150
8.4.2 UPDATE statement Basic Syntax 151
8.4.3 Update records by computing 152
8.4.4 update records with the TOP clause 153
8.5 Deleting records with the DELETE statement 153
Example of a 8.5.1 simple DELETE statement 153
8.5.2 DELETE statement Basic Syntax 153
8.5.3 example of deleting a statement using a WHERE clause 154
8.6 Deleting records with the TRUNCATE TABLE statement 154
Syntax of the 8.6.1 TRUNCATE table statement 155
8.6.2 Use TRUNCATE TABLE to delete data 155
8.7 Use Union 156
Syntax for the 8.7.1 Union keyword 156
8.7.2 uses union to combine two tables with 156
8.8 Using sub-query 157
8.8.1 uses the subquery result as a return field example 157
8.8.2 uses a connection instead of a subquery 158
9th. The basis of Transact-SQL language 159
9.1 T-SQL Syntax rule 159
9.2 Operators and Priority 159
9.2.1 Arithmetic operator 159
9.2.2 Assignment operator 162
9.2.3-bit operator 163
9.2.4 comparison operator 166
9.2.5 logical operator 167
9.2.6 string concatenation operator 168
9.2.71-dollar operator 168
Priority of the 9.2.8 operator 170
Constant 171 in 9.3 T-SQL
9.3.1 string constant 171
9.3.2 Unicode constant 171
9.3.3 Binary constant 172
9.3.4 Bit constant 172
9.3.5 DateTime constant 172
9.3.6 Integer constant 172
9.3.7 Decimal Constant 172
9.3.8 float and Real constant 173
9.3.9 Money Constant 173
9.3.10 uniqueidentifier constant 173
9.3.11 using constant 173 in T-SQL
9.4 The variable 174 in T-SQL
9.4.1 local variable 174
9.4.2 T-SQL parameter 174
9.4.3 Application Variable 175
9.5 Flow Control Statement 175
9.5.1 Begin ... End Statement 175
9.5.2 If...else Conditional Statement 176
9.5.3 While statement 177
9.5.4 Case Statement 178
9.5.5 Goto Statement 180
9.5.6 WAITFOR Statement 181
9.5.7 Return Statement 183
9.5.8 Try...catch Statement 185
9.5.9 EXECUTE Statement 187
9.6 Cursor 189
Introduction to 9.6.1 Cursors 189
9.6.2 definition Cursor 190
9.6.3 Open Cursor 191
9.6.4 Read CURSOR 192
9.6.5 Close and Delete cursors 195
9.7 Use of Cursors 197
9.7.1 A general procedure for processing data with cursors 197
9.7.2 global cursor vs. local cursor 198
Nesting of 9.7.3 Cursors 201
9.7.4 using cursor variable 202
9.7.5 use functions to view cursor status 203
9.7.6 use system stored procedures to view cursor Properties 206
10th Chapter Stored Procedure 209
10.1 Stored Procedure Overview 209
10.2 Design Stored Procedure 209
10.3 Create stored Procedure 210
10.3.1 set up stored procedures in SQL Server Management Studio 210
10.3.2 creates a procedure statement with create a stored procedure 212
10.4 Modify Stored Procedure 214
10.4.1 Modify stored procedures in SQL Server Management Studio 215
10.4.2 Modify stored procedure with ALTER PROCEDURER statement 215
10.5 Execute Stored Procedure 218
10.5.1 executes stored procedures in SQL Server Management Studio 218
10.5.2 execute stored procedure with EXECUTE statement 219
10.6 Delete stored Procedure 220
10.6.1 Delete stored procedures in SQL Server Management Studio 220
10.6.2 Delete stored procedure with the drop PROCEDURE statement 221
10.7 Common system stored Procedures 222
10.7.1 sp_help Stored Procedure 222
10.7.2 sp_rename, sp_renamedb stored procedure 223
10.7.3 common system stored procedure classification 223
10.8 Establish CLR stored procedure 227
11th Chapter Function 232
11.1 Functions Overview 232
Structure of the 11.1.1 function 232
Type of 11.1.2 function 232
Advantages of 11.1.3 using functions 233
11.2 Design user-defined function 233
11.2.1 Select function Type 233
11.2.2 function and stored procedure 233
11.3 Creating user-defined Functions 234
11.3.1 create user-defined functions in SQL Server Management Studio 234
11.3.2 to create function 236 with the CREATE FUNCTION statement
11.4 Execute user-defined function 239
11.4.1 Execution Position 239
11.4.2 example of executing a user-defined function 239
11.5 Delete user-defined function 239
11.5.1 Delete a user-defined function in SQL Server Management Studio 240
11.5.2 deletes a user-defined function with the DROP FUNCTION statement 240
11.6 Common system Functions 241
11.6.1 aggregate function 241
11.6.2 Configuration Function 242
11.6.3 cursor Function 243
11.6.4 Date and Time function 244
11.6.5 Mathematical Function 244
11.6.6 Meta Data function 245
11.6.7 Rank function 247
11.6.8 Row Set function 247
11.6.9 Security Function 247
11.6.10 String Function 248
11.6.11 system function 249
11.6.12 System Statistical Function 251
11.6.13 text and image functions 252
11.7 Creating CLR Functions 252
11.7.1 General Step 252 to create a CLR function
11.7.2 advantages of using CLR functions 253
11.7.3 create an instance of a CLR function 253
The 12th Chapter constrains 256
12.1 Constraints Overview 256
12.1.1 Data Integrity 256
Concept and type of 12.1.2 constraint 257
12.2 Design Constraints 258
12.2.1 define constraints by 258
12.2.2 syntax structure for defining constraints 258
12.3 PRIMARY KEY constraint 259
12.3. Example of 11 PRIMARY KEY constraints 259
12.3.2 Use Table Designer to define a primary KEY constraint 260
12.3.3 defines a primary KEY constraint using T-SQL 261
12.4 FOREIGN KEY constraint 262
12.4. Example of 11 foreign KEY constraints 262
12.4.2 define FOREIGN KEY constraints using Table Designer 263
12.4.3 defines a foreign KEY constraint using T-SQL 265
12.5 Unique Constraint 266
12.5. Example of 11 UNIQUE constraints 266
12.5.2 Use Table Designer to define a unique constraint 267
12.5.3 uses T-SQL to define a unique constraint 268
12.6 Check Constraint 268
12.6. Example of 11 CHECK constraints 269
12.6.2 Use Table Designer to define CHECK constraints 269
12.6.3 use T-SQL to define a CHECK constraint 270
12.7 Default constraint 271
12.7.1 Use Table Designer to define DEFAULT constraint 271
12.7.2 use T-SQL to define DEFAULT constraint 271
12.8 Disable constraint 272
12.8.1 disables foreign KEY constraints on replication 272
12.8.2 Disable CHECK constraints on replication 272
12.8.3 disables foreign key constraints on INSERT and UPDATE statements 273
12.8.4 Disable CHECK constraints on INSERT and UPDATE statements 273
13th Chapter Triggers 274
13.1 Triggers Overview 274
The role of 13.1.1 triggers 274
Classification of 13.1.2 triggers 274
How the 13.1.3 triggers work 275
13.2 Design triggers 275
13.2.1 understand the use requirements of after and INSTEAD of triggers 275
13.2.2 issues to consider before creating triggers 276
13.3 Creating triggers 276
13.3.1 creating triggers in SQL Server Management Studio Step 276
13.3.2 to create a trigger 277 using the CREATE TRIGGER statement
13.4 Modifying triggers 280
13.4.1 modify triggers in SQL Server Management Studio Step 280
13.4.2 use ALTER TRIGGER statement to modify trigger 280
13.5 Delete Trigger 281
13.5.1 Use SQL Server Management Studio to delete triggers 281
13.5.2 Use the DROP TRIGGER statement to delete triggers 282
13.6 Disabling/enabling triggers 283
13.6.1 Disable Trigger 283
13.6.2 Enable Trigger 285
13.7 Designing CLR Triggers 286
13.7.1 General Step 286 to create a CLR trigger
13.7.2 example of creating a CLR trigger 286
13.8 Design DDL triggers 290
13.8.1 CREATE TRIGGER syntax for creating DDL triggers 290
13.8.2 example of a DDL trigger using CREATE TRIGGER 290
14th Chapter Affairs and Locks 292
14.1 Business 292
Features of 14.1.1 Business 292
14.1.2 Start Transaction 292
14.1.3 Save Transaction 294
14.1.4 COMMIT TRANSACTION 295
14.1.5 ROLLBACK TRANSACTION 296
14.1.6 Auto COMMIT Transaction 298
14.1.7 an explicit transaction 300
14.1.8 Implicit transaction 302
14.1.9 Transaction Nesting 304
14.2 Managing concurrent data Access 307
Impact of 14.2.1 concurrency 308
14.2.2 concurrency control type 308
Isolation level for 14.2.3 transactions 309
14.3 Lock 309
14.3.1 can lock Resources 309
14.3.2 Lock Mode 310
14.3.3 dead Lock 311
15th Chapter index and query optimization 312
15.1 Index Overview 312
15.1.1 Clustered and nonclustered indexes 312
15.1.2 Fill Factor 312
15.1.3 Use catalog view to view indexes 313
15.2 Creating index 313 with the CREATE INDEX statement
15.2.1 Basic Syntax 314
15.2.2 Create a simple composite index 317
15.2.3 Create a unique index 317
15.2.4 Create a clustered index 319
15.2.5 The file group 320 that the specified index holds
15.3 Modifying index 321 with ALTER INDEX statement
15.3.1 Basic Syntax 321
15.3.2 option 322 to set index
15.3.3 Disable/Enable index 323
15.4 Delete index 324 with DROP INDEX statement
15.4.1 Basic Syntax 325
15.4.2 uses drop index to delete the clustered index and move the table to the new filegroup 326
15.4.3 use DROP Index to remove primary KEY constraint 329
15.5 re-organizing and rebuilding indexes 330
15.5.1 Understanding re-organization, build index 330
15.5.2 Index 331
15.5.3 Rebuild Index 332
Third SQL Server 2005 advanced Features
16th SQL Server 2005 Administration Tools 335
16.1 SQL Server Configuration Manager 335
16.1.1 Management Service 335
16.1.2 Management Server-side network protocol 336
16.2 SQL Server Perimeter Application Configurator 338
16.2.1 start the perimeter application Configurator 338
16.2.2 the perimeter Application configurator using services and connections 338
16.2.3 using the perimeter configuration of the feature 340
16.3 Database Engine Tuning Advisor 341
16.3.1 Start Database Engine Tuning Advisor 341
16.3.2 design Tools Options and layouts 342
16.3.3 using Database Engine Tuning Advisor 343
16.4 SQL Server command prompt utility 345
16.4.1 BCP data Replication tool 345
16.4.2 DTA Database Engine Tuning Tool 346
16.4.3 SAC perimeter application Settings Import and Export tool 348
16.4.4 sqlcmd Utility 349
16.4.5 SQLdiag Diagnostic Information Collection Tool 350
16.4.6 sqlmaint Maintenance Utility 351
16.4.7 sqlservr Instance Run program 352
16.4.8 SQLWB Utility 352
Data comparison tool in 16.4.9 tablediff table 353
16.4.10 Other Utilities Introduction 354
16.5 SQL Server Books Online 355
17th Chapter Database Server Management 357
17.1 Connection and Disconnect database server 357
17.1.1 Add server group with server 357
17.1.2 disconnect from the database server 358
17.2 Configuring SQL Server service 359 using Configuration Manager
17.2.1 start, stop, pause, and restart SQL Server service 359
17.2.5 Configure client Network protocol 361
17.2.6 Hide Database Engine instance 363
17.3 Configuring SQL Server 2005 Server Properties 363
17.3.1 View server Properties 363
17.3.2 Set Memory Properties 364
17.3.3 Set processor Properties 364
17.3.4 Set security Property 364
17.3.5 Set connection Properties 365
17.3.6 Set Database Properties 366
17.3.7 View advanced Properties 366
17.4 Log view of server operation 367
17.4.1 View SQL Server log 367
17.4.2 View Windows System log 368
17.5 View server information through dynamic management view 369
17.5.1 dynamic management views related to databases 369
17.5.2 dynamic management view associated with the SQL Server operating system 369
Chapter 18th Management database and database file 370
18.1 Understanding Database File 370
18.1.1 understand data access process 370
18.1.2 Database File 370
18.1.3 Database File Group 371
18.1.4 set up database files and filegroups 372
18.2 Creating a Database 373
18.2.1 CREATE DATABASE Statement 373
18.2.2 example of creating a database 375
Owner of the 18.2.3 database 379
18.3 Modifying the database 379
18.3.1 Expanded Database 379
18.3.2 Shrink Database 380
18.3.3 Shrink Database File 381
18.3.4 Add and remove data files and log files 382
18.3.5 Mobile Database File 384
18.4 Delete Database 384
18.4.1 Use SQL Server Management Studio to delete a database 385
18.4.2 Delete database with drop DB statement 385
18.5 Separation with additional database 385
18.5.1 Separation Database 385
18.5.2 Additional Database 386
18.6 Understanding System Database 387
18.6.1 System Database Description 388
18.6.2 Hidden System database Objects 388
18.7 Establish a database snapshot 389
18.7.1 Working principle 389
18.7.2 Typical Use 390
18.7.3 Create and delete database snapshots 390
18.8 Data partition Management 391
18.8.1 Understand partitioned table 392
18.8.2 create partition Function 392
18.8.3 create PARTITION Scheme 393
18.8.4 create partition Table 394
18.8.5 example of creating a partitioned table 394
19th Chapter Security Management 399
19.1 SQL Server Security 399
19.1.1 Main body 399
19.1.2 security Object 400
19.1.3 Permission Hierarchy 400
19.1.4 Query Permission 401
19.2 server-wide security management 403
19.2.1 SQL Server Authentication Mode 403
19.2.2 Use password policy 404
19.2.3 Server-scoped role 405
19.2.4 Admin Login Name 405
19.2.5 Administrative Credentials 407
19.3 Database-wide security management 408
19.3.1 Management User 408
19.3.2 Special User 410
19.3.3 Database-scoped Roles 410
19.4 User Architecture Separation 411
19.4.1 Understanding Architecture 411
19.4.2 use the SQL Server Management Studio tool to create a schema 412
19.4.3 creates schema with CREATE SCHEMA statement 413
19.5 Management keys and certificates 413
19.5.1 SQL Server password system architecture 413
19.5.2 Create key 413
19.5.3 Create certificate 416
19.5.4 Simple Encryption Example 417
Chapter 20th database Backup and recovery 418
20.1 Understanding Database Backup 418
Purpose of 20.1.1 backup 418
20.1.2 backup process and Recovery mode 418
20.1.3 Full Recovery Mode 420
20.1.4 Bulk-Logged Recovery Model 420
20.1.5 Simple Recovery Mode 420
20.2 Backup Strategy 421
Type of 20.2.1 backup 421
20.2.2 Understanding Backup Strategy 422
20.2.3 full Database backup strategy 422
20.2.4 database and transaction log backup policy 423
20.2.5 Differential backup Strategy 423
20.2.6 file or filegroup backup policy 423
20.3 perform and manage backups 423
20.3.1 database Backup Under the simple recovery model based on a full database backup policy 424
20.3.2 database Backup Under the full recovery model according to the differential backup policy 427
20.3.3 Backup DATABASE with T-SQL statement 430
20.4 RESTORE Database 433
20.4.1 Understand restore process 433
20.4.2 Restore a full backup of the database in the full recovery model 433
20.4.3 use T-SQL to restore a database 437
21st Chapter System Automation Task management 438
21.1 SQL Server Agent 438
21.1.1 SQL Server Agent Introduction 438
21.1.2 SQL Server Agent Settings 438
21.1.3 start and stop SQL Server Agent 440
21.1.4 SQL Server Agent Security 441
General Step 444 of 21.1.5 using SQL Server Agent
21.2 Job 444
21.2.1 Create Job 444
21.2.2 Create job step 446
21.2.3 Create job time schedule 447
21.2.4 View and modify jobs 448
21.2.5 Run Job 450
21.2.6 View Job History 450
21.3 Maintenance Plan 453
21.3.1 maintenance tasks that can be run automatically 453
21.3.2 Use the wizard to create a maintenance plan step 453
21.3.3 Manually create a maintenance plan step 454
21.4 Alarm 455
21.4.1 Create alert 455
21.4.2 Delete Alert 457
21.5 operator 457
21.5.1 Create operator 457
21.5.2 Assign alerts to operators 458
Chapter 22nd Replication 460
22.1 Replication Overview 460
22.1.1 Replication Publishing Model Overview 460
22.1.2 Replication Type 461
22.2 Create replication 462
22.2.1 Create release 463
22.2.2 Create subscription 465
22.3 Management Replication 468
22.3.1 View and modify publication Properties 469
22.3.2 View and modify project Properties 469
22.3.3 specified history retention period 470
22.3.4 View the publisher's information and perform its tasks 470
23rd Chapter Full-Text Search 472
23.1 Introduction to Full-text search 472
23.1.1 Full-Text Search concept 472
23.1.2 install full-Text Search 474
23.1.3 Full-Text search structure 474
23.2 Admin Full-Text Search 475
23.2.1 Use SQL Server Management Studio to create a Full-text catalog 475
23.2.2 Use SQL Server Management Studio to create a Full-text index 477
23.2.3 using T-SQL Full-text data Definition Language 478
23.2.4 example of using T-SQL to create a FULL-TEXT index 482
23.2.5 Delete Full-text index from datasheet 484
23.2.6 Delete Full-text catalog from database 484
23.3 Use full-text search 484
23.3.1 Custom Data Dictionary 484
23.3.2 search for a specific word or phrase 486
23.3.3 Execution Prefix search 486
24th Chapter Processing XML Data 488
24.1 XML Overview 488
24.1.1 understand XML 488
Attributes of 24.1.2 XML 488
24.1.3 SQL Server 2005 database support for XML 489
24.2 using the FOR XML clause and the OPENXML function 489
24.2.1 using for XML 489
24.2.2 Use OPENXML 495
24.3 XML data type and processing 499
24.3.1 XML Data type 499
24.3.2 XML Data type method 502
Chapter 25th Monitoring SQL Server Status 508
25.1 View Current Activity 508
25.1.1 Use Activity Monitor 508
25.1.2 dynamic Management Object 510
25.2 using System Performance Monitor 512
25.2.1 Run System Performance Monitor 513
25.2.2 SQL Server performance Object 514
25.2.3 Monitor SQL Server Note Point 515
25.3 using SQL Server Profilter 516
25.3.1 SQL Server Profilter Introduction 516
25.3.2 How to create a trace 516
25.3.3 How to set global tracking option 517
25.3.4 How to specify event and data column 518 for trace files
25.3.5 How to save trace results to table 519
25.3.6 How to modify filter 519
26th SQL Server Business Intelligence services 520
26.1 SQL Server 2005 set into service 520
26.1.1 Integration Services Profile 520
Structure of 26.1.2 SSIS 521
26.1.3 Create SSIS Project 521
26.1.4 set up data source and Data View 522
26.1.5 Build Package 524
26.1.6 set up control flow 525
26.1.7 set up data flow 525
26.1.8 Run SSIS package 528
26.1.9 Deployment SSIS Package 529
26.2 SQL Server Report service 531
26.2.1 SSRS Introduction 531
26.2.2 Create a Report Server project 532
26.2.3 set up a data source 532
26.2.4 Set up report 533
26.2.5 Run Report 536
26.2.6 Release Report 536
The fourth Article database development
27th Chapter Visual Basic.NET and SQL Server development application 539
27.1 Visual Basic.NET Connection database 539
27.1.1 familiar with vb.net integrated development environment 539
27.1.2 connect to database via Ado.net 541
27.2 Visual Basic.NET Development student file management system 543
27.2.1 Example describes 543
27.2.2 Database Design Structure 544
27.2.3 set up database and base data table 545
27.2.4 Create Visual Basic.NET engineering 551
27.2.5 Add Visual Basic control 552
27.2.6 Set DataGridView Control 552
27.2.7 Write event code 554
27.2.8 Compile Application 555
28th Chapter ASP. NET and SQL Server 2005 556
28.1 familiar with ASP.net development operation 556
28.1.1 ASP. NET's development environment 556
28.1.2 ASP. NET code Model 557
28.1.3 use Web.config file 558
28.1.4 connect to database via Ado.net 559
28.1.5 query data in asp.net 560
28.2 ASP. NET Development online Student file management system 563
28.2.1 System Goal 563
28.2.2 New Web site project 564
28.2.3 Write login Page 565
28.2.4 Management System Main interface 567
28.2.5 write a page to view student information 568
28.2.6 Write page 570 for entering student information
28.2.7 running asp.net Web page in Microsoft IIS 573
