SQL Server 2000 Developer's Guide

Name: SQL Server 2000 Developer's Guide
Price: 5.7 USD
Availability: InStock
ISBN: 9780072125696

ISBN-10: 0072125691

ISBN-13: 9780072125696

Edition: 2nd 2001

Authors: Michael Otey, Paul Conte

List price: $59.99

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $5.70

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Expert authors highly recognized in industry. Covers hot industry topics like security, backup and recovery, and XML's integration into SQL Server. Examines Data Transformation Services (DTS) and Data Access Wizards in detail. Demonstrates how to migrate to SQL Server 2000 and provides tutorials on the new version. Contains CD-ROM with code examples.

Book details

List price: $59.99
Edition: 2nd
Copyright year: 2001
Publisher: McGraw-Hill Osborne
Publication date: 12/22/2000
Binding: Paperback
Pages: 1280
Size: 7.00" wide x 8.75" long x 2.50" tall
Weight: 4.488
Language: English

Michael Otey is the Senior Technical Editor of SQL Server Magazine and Windows 2000 Magazine. He is also the President of TECA, a consulting and software development company in Portland, Oregon that specializes in Windows, SQL Server and AS/400 utilities. Michael has published numerous articles in SQL Server Magazine and Windows 2000 Magazine. He is the co-author of the SQL Server 7 Developer's Guide and the author of VB Answers! published by Osborne/McGraw-Hill. He is also the author of AS/400 Client Server Programming and the AS/400 Application Developer's Guide published by 29th Street Press. Michael has a B.S. in psychology from Lewis and Clark college and he enjoys running, playing…

Acknowledgments	p. xxiii
Introduction	p. xxv
Mastering Transact-SQL
An Overview of SQL Server 2000	p. 3
SQL Server's Networked Architecture	p. 4
SQL Server's Basic Components	p. 8
Transact-SQL	p. 9
SQL Server Database Architecture	p. 9
Administrative Components	p. 22
A Brief Development History of SQL Server	p. 27
What's New with SQL Server 2000	p. 28
Conclusion	p. 33
Data Definition Language Basics	p. 35
Introduction to SQL	p. 36
Creating a Database	p. 46
Creating a Table	p. 50
Creating a View	p. 70
Re-creating a View	p. 78
Creating an Index	p. 78
Dropping Databases, Tables, Views, and Indexes	p. 80
The SQL Catalog and Information Schema	p. 80
DDL Coding Suggestions	p. 83
Conclusion	p. 86
Additional Resources	p. 86
Advanced Database Definition	p. 87
Specifying Database File Locations and Sizes	p. 88
Altering a Database	p. 90
Defining Filegroups	p. 90
Cascading Foreign Key Constraints	p. 93
More View Examples	p. 95
Indexes Over Computed Columns and Views	p. 106
Using the Query Analyzer	p. 109
Adding Extended Object Properties	p. 117
Conclusion	p. 120
Data Manipulation Language Basics	p. 121
Introduction to DML	p. 122
Retrieving Rows with the Select Statement	p. 123
Using DML to Modify Table Data	p. 154
DML Coding Suggestions	p. 160
Conclusion	p. 161
Advanced DML Statement Features	p. 163
Complex Select Statements	p. 164
Performance Hints	p. 202
Concurrent Access and Resource Locks	p. 203
DML Coding Suggestions	p. 211
Conclusion	p. 211
Writing Stored Procedures, Triggers, and Functions	p. 213
Stored Procedures	p. 214
Triggers	p. 232
User-Defined Functions	p. 245
Debugging Stored Procedures, Triggers, and User-Defined Functions	p. 250
Conclusion	p. 253
Developing Extended Stored Procedures	p. 255
Extended Stored Procedures	p. 256
OLE Automation Stored Procedures	p. 276
Conclusion	p. 283
Additional References	p. 283
Windows Applications
Using ADO	p. 287
OLE DB and Universal Data Access	p. 288
OLE DB Architecture Overview	p. 288
ADO (ActiveX Data Objects)	p. 291
OLE DB and ADO Files	p. 293
ADO Architecture	p. 293
Adding the ADO Reference to Visual Basic	p. 295
Using ADO Objects with Visual Basic	p. 296
Advanced Database Functions Using ADO	p. 352
Conclusion	p. 380
Additional References	p. 380
Using the ODBC API	p. 381
ODBC Architecture	p. 383
Configuring an ODBC Data Source	p. 385
Conclusion	p. 426
Additional References	p. 426
Using DAO	p. 427
DAO Files	p. 429
DAO Architecture	p. 430
An Overview of Using DAO	p. 432
Adding the DAO Reference to Visual Basic	p. 432
Using DAO Objects with Visual Basic	p. 433
General Performance Tips for DAO and ODBC	p. 488
Conclusion	p. 489
Additional References	p. 489
Using ODBCDirect	p. 491
ODBCDirect Files	p. 493
ODBCDirect Architecture	p. 493
Adding the DAO Reference to Visual Basic	p. 494
An Overview of Using ODBCDirect	p. 495
Creating the DBEngine Object	p. 496
Creating an ODBCDirect Workspace Object	p. 496
Ending the DBEngine Object	p. 497
Connecting to SQL Server	p. 497
Retrieving Data with ODBCDirect	p. 501
Modifying Data with ODBCDirect	p. 513
Advanced Database Functions Using ODBCDirect	p. 521
Conclusion	p. 528
Additional References	p. 529
Using RDO	p. 531
RDO Files	p. 534
RDO Architecture	p. 534
An Overview of Using RDO	p. 535
Adding RDO 2.0 Objects to Visual Basic	p. 536
Using the RDO Objects with Visual Basic	p. 537
Advanced Topics	p. 563
Conclusion	p. 570
Additional References	p. 571
Web Applications
Using the Web Wizard	p. 575
Web Integration Using the Web Assistant Wizard	p. 576
Conclusion	p. 591
Using ASP and ADO	p. 593
Web and Database Integration Using ASP	p. 594
The ASP Object Model	p. 597
ASP Basics	p. 599
Using ADO Objects with ASP	p. 601
Advanced ADO-based Web Building Techniques	p. 641
Conclusion	p. 649
Additional References	p. 650
Using XML	p. 651
XML Basics	p. 653
SQL Server 2000's Support for XML	p. 655
Using XML Streams and ADO	p. 684
Conclusion	p. 692
Additional Resources	p. 692
Management and Analysis Applications
Using SQL-DMO	p. 695
Distributed Management Framework	p. 696
SQL-DMO Files	p. 705
Using SQL-DMO	p. 705
Building the SQL-DMO Sample Application	p. 713
Conclusion	p. 734
Developing Applications Using DTS	p. 735
An Overview of DTS	p. 736
Creating DTS Packages with the DTS Designer	p. 742
DTS Command Line Options	p. 760
Programming with DTS	p. 762
DTS Architecture	p. 762
Conclusion	p. 781
Additional References	p. 781
Full-Text Search and English Query	p. 783
Full-Text Catalogs and Searches	p. 784
English Query	p. 794
Conclusion	p. 831
Administration for the Developer
Managing Servers	p. 835
Overview of a SQL Server Installation	p. 836
Setting Enterprise Manager Properties	p. 847
Registering and Unregistering a Server	p. 849
Stopping, Starting, Pausing, and Continuing a Server	p. 854
Setting Server Properties	p. 855
Server Logins and Roles	p. 874
Working with SQL Server Agent	p. 875
Displaying Event Logs	p. 891
Viewing and Creating SQL Server Messages	p. 892
Working with Linked Servers	p. 894
Other Enterprise Manager Facilities	p. 897
Conclusion	p. 897
Managing Databases	p. 899
Managing Databases and Database Objects	p. 900
Copy Database Wizard	p. 927
Conclusion	p. 933
SQL Server Security	p. 935
Security Basics	p. 936
Setting Up Database Users	p. 947
Managing SQL Server Database Access	p. 977
Using Stored Procedures	p. 980
Permissions	p. 984
The Grant, Revoke, and Deny SQL Statements	p. 993
Role Permissions	p. 998
Stored Procedures and Permissions	p. 999
Ownership Chain	p. 1000
Database Security Principles and Guidelines	p. 1000
Conclusion	p. 1002
Backup and Recovery	p. 1003
Why Back Up the Database?	p. 1004
Backing Up Database Objects	p. 1005
Database Recovery	p. 1025
Backup and Recovery Server Options	p. 1035
Using a Standby Server	p. 1036
Conclusion	p. 1036
Database Performance Troubleshooting	p. 1037
Selecting the Appropriate Tool	p. 1039
SQL Profiler	p. 1042
Windows 2000 Server System Monitor	p. 1073
Enterprise Manager Current Activity Categories	p. 1096
Index Tuning Wizard	p. 1099
Showplan	p. 1106
Other Performance Tools	p. 1114
SQL Statement Hints	p. 1118
Hardware Considerations	p. 1125
Conclusion	p. 1126
Relational Database Concepts
Introduction to the Relational Database Model	p. 1129
Background: Database Management Systems	p. 1130
The Relational Database Model	p. 1135
Conclusion	p. 1157
Additional Resources	p. 1158
Introduction to Entity Relationship Diagrams (ERDs)	p. 1159
ERDs--A Design Tool	p. 1160
Basic ERD Concepts and Symbols	p. 1160
Adding Properties to ERDs	p. 1163
Multivalued Properties	p. 1165
Representing Associations	p. 1166
Exclusive Relationships	p. 1167
Entity Subtypes	p. 1168
When to Use ERDs	p. 1169
SQL Server Database Diagrams	p. 1171
Conclusion	p. 1178
Additional Resources	p. 1179
Appendixes
Maximum Capacities	p. 1183
System Capacities	p. 1184
Database Capacities	p. 1184
SQL Capacities	p. 1185
Creating and Editing UDL Files	p. 1187
Creating UDL Files on Windows 9x and NT Using Explorer	p. 1190
Creating UDL Files on Windows 2000 Using Explorer	p. 1191
Creating UDL Files Using the Data Link API	p. 1192
Conclusion	p. 1195
Index	p. 1197
Table of Contents provided by Syndetics. All Rights Reserved.