+612 9045 4394
$7.95 Delivery per order to Australia and New Zealand
100% Australian owned
Over a hundred thousand in-stock titles ready to ship
Portable DBA: SQL Server : SQL Server - Damir Bersinic

Portable DBA: SQL Server

SQL Server

Paperback Published: 21st January 2004
ISBN: 9780072230161
Number Of Pages: 339

Share This Book:


RRP $74.00
Ships in 10 to 15 business days

Earn 123 Qantas Points
on this Book

This book is the ultimate field guide for every SQL Server DBA's laptop bag. Don't go onsite without it Covers the most commonly used SQL Server database versions. Handy, easy-to-find information includes security, database creation and management, restoration and recovery, automating SQL Server administration, monitoring performance, tuning, and much more.

Acknowledgmentsp. xi
Introductionp. xi
SQL Server Overviewp. 1
Defining SQL Serverp. 1
SQL Server Communicationsp. 2
Transact-SQL: The Language of SQL Serverp. 3
SQL Server and the Windows Family of Serversp. 3
SQL Server Editions and Componentsp. 4
SQL Server Componentsp. 5
SQL Server Servicesp. 7
SQL Server Databasesp. 8
SQL Server Toolsp. 9
Installing, Configuring, and Upgrading SQL Serverp. 13
Hardware and Software Requirementsp. 13
Preparing to Install SQL Serverp. 14
Understanding Licensingp. 15
Character Sets, Sort Orders, and Collationsp. 17
Multiple Instance Support in SQL Server 2000p. 20
SQL Server Startup Account Selectionp. 22
Authentication Mode Selectionp. 23
Networking Library Selectionp. 25
Installing SQL Serverp. 26
SQL Server Attended Installationp. 27
Automating SQL Server Installationp. 28
Remote Installation of SQL Serverp. 30
Testing the Installationp. 31
Upgrading to SQL Server 2000p. 31
Troubleshooting SQL Server Installationp. 32
Applying SQL Server Service Packsp. 34
Completing Installation and Upgradep. 35
SQL Server Securityp. 37
SQL Server Security Modelp. 37
Configuring SQL Server Authentication Modesp. 38
SQL Server 2000 and Kerberosp. 39
Managing SQL Server Loginsp. 42
Managing Logins with Enterprise Managerp. 42
System Stored Procedures for Managing Loginsp. 44
Default Loginsp. 46
Getting Information on Loginsp. 46
Database Access with Users and Rolesp. 46
Assigning Logins to Database Usersp. 47
Roles in SQL Serverp. 49
Controlling Access with Permissionsp. 59
Permission Management Commandsp. 59
SQL Server Permission Categoriesp. 60
Obtaining Information on Permissionsp. 66
Security Management Recommendationsp. 66
Creating and Managing Databasesp. 69
SQL Server Storage Structurep. 69
Transactions Explainedp. 70
Devices in Previous Releases of SQL Serverp. 72
Creating Databasesp. 73
Planning File Placementp. 75
Managing Database Filesp. 79
Managing File Growth and Numbers of Data Filesp. 79
Filegroups in SQL Serverp. 81
Shrinking Databases and Database Filesp. 82
Retrieving File Informationp. 84
Setting Database Optionsp. 84
Dropping Databasesp. 90
The DBA Responsibility Truly Beginsp. 90
Creating and Managing Database Objectsp. 91
SQL Server Database Objectsp. 91
Managing Tables and Data Typesp. 93
SQL Server Scalar and User-Defined Data Typesp. 93
Creating and Managing Tablesp. 98
Managing Indexesp. 103
Why (Not to) Create Indexes?p. 103
SQL Server Data Retrieval Overviewp. 104
Creating and Dropping Indexesp. 106
Managing Viewsp. 108
Creating, Altering, and Dropping Viewsp. 109
Programming in Transact-SQLp. 111
Transact-SQL Programming Language Elementsp. 112
Stored Proceduresp. 112
User-Defined Functionsp. 116
Enforcing Integrityp. 118
Constraintsp. 118
Triggersp. 123
SQL Server Defaultsp. 126
SQL Server Rulesp. 128
Database Backupsp. 131
Understanding the SQL Server Recovery Modelsp. 131
Factors Affecting Your Choice of Recovery Modelp. 132
Setting the Recovery Modelp. 133
Understanding and Planning SQL Server Backupsp. 134
Backup Typesp. 135
The Backup Processp. 140
Creating Backup Devicesp. 140
Performing Full Backupsp. 141
Performing Differential Backupsp. 143
Backing Up the Transaction Logp. 144
Backing Up Files and Filegroupsp. 145
Backing Up a Database Using Enterprise Managerp. 145
Performing Dumps in SQL Server 6.5p. 146
Automating SQL Server Backupsp. 148
Restoring and Recovering Databasesp. 149
Overview of SQL Server Recoveryp. 149
Restoring and Recovering Databasesp. 151
Pre-Restoration Tasksp. 152
Restoring a User Databasep. 156
Restoring and Recovering System Databasesp. 163
Loading and Extracting Datap. 167
SQL Server Tools for Extraction, Transformation, and Loadp. 167
The Data Transformation Servicep. 170
The DTS Import/Export Wizardp. 173
The DTS Designerp. 175
The Copy Database Wizardp. 178
Using DTS for ETLp. 179
The BCP Utilityp. 180
Using Bulk Insertp. 184
Attaching and Detaching Databasesp. 186
Using sp_detach_db and sp_attach_dbp. 187
Using sp_certify_removable and sp_create_removablep. 188
Automating Data Loadsp. 189
Automating SQL Server Administrationp. 193
SQL Automation--An Overviewp. 193
SQL Server Agent and Automating Administrationp. 194
Configuring the SQL Agent Mail Servicep. 196
Managing Operatorsp. 197
Defining a Fail-Safe Operatorp. 200
Creating SQL Server Jobsp. 201
The Importance of the Job Ownerp. 203
Defining Job Stepsp. 204
Scheduling Jobsp. 207
Setting Notificationp. 210
Monitoring Job Historyp. 210
Creating and Managing SQL Server Alertsp. 211
Creating Alerts on Eventsp. 212
Adding User-Defined Eventsp. 214
Creating Alerts on Performance Conditionsp. 215
Defining Multi-Server Administrationp. 216
Performance Tuning Part 1: Monitoring SQL Server Performancep. 219
Factors Affecting SQL Server Performancep. 219
The Pyramid of Performancep. 220
Defining a Performance Baselinep. 224
Tools for Monitoring SQL Server Performancep. 225
Windows Event Viewerp. 226
Windows System Monitor and Performance Logs and Alertsp. 226
SQL Profilerp. 231
Monitoring Real-Time SQL Server Activityp. 233
Automating SQL Performance Monitoringp. 236
Performance Tuning Part 2: Tuning SQL Serverp. 237
Goals of Database Tuningp. 237
Tools for Tuning SQL Serverp. 238
Windows System Monitorp. 239
Execution Plans and the Query Optimizerp. 240
SQL Server Query Optimizerp. 240
Determining the Execution Plan in Usep. 242
Optimizing Queriesp. 250
Using Indexes to Cover a Queryp. 252
Tuning Indexesp. 254
SQL Server Replicationp. 259
Replication and Distributed Datap. 259
SQL Server Replication Architecturep. 261
SQL Server Replication Modelsp. 262
Replication Mechanicsp. 267
SQL Server Replication Typesp. 269
Designing and Planning Replicationp. 273
What Data Should be Publishedp. 273
Who Receives the Data and How Oftenp. 273
Considering Physical Network Characteristicsp. 274
Choosing the Type and Number of Subscribersp. 275
Considering Storage Spacep. 275
Data Definition Considerationsp. 277
Configuring SQL Server Replicationp. 279
Configuring a Distributorp. 279
Configuring Publishingp. 283
Configuring Subscribersp. 287
Monitoring Replicationp. 289
Managing Distributed Databasesp. 291
Working with Distributed Datap. 291
Working with Ad Hoc Queriesp. 292
Configuring and Managing Linked Serversp. 294
Securing Linked Server Connectionsp. 297
Clustering and Log Shippingp. 305
Clustering SQL Serverp. 305
Installing SQL Server in a Clustered Environmentp. 307
Administering SQL Server in a Clusterp. 314
Standby Servers and Log Shippingp. 318
Configuring a Production Database for Log Shippingp. 318
Monitoring Log Shippingp. 323
Switching Rolesp. 324
Removing Log Shippingp. 325
Indexp. 327
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072230161
ISBN-10: 0072230169
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 339
Published: 21st January 2004
Country of Publication: US
Dimensions (cm): 22.76 x 15.11  x 1.96
Weight (kg): 0.46

Earn 123 Qantas Points
on this Book