About the Book
This guide to Windows NT database development using Microsoft's SQL Server introduces the capabilities of SQL Server and its core concepts. It guides the reader through basic SQL Server database management functions, such as creating databases, tables and views. The book also focuses on primary database application envelopment methodologies, providing both a broad picture of the primary development tools that are available for SQL Server and practical examples using each database access method. Coverage of both NT 4.0 and Server 7.0 are included. Windows NT is Microsoft's network operating system. It was first introduced three years ago, but it didn't make much headway in the marketplace due to a lack of sophistication in its technology. Hovever, with the release of Windows NT 4.0, Microsoft has produced a powerful, multi-purpose network operating system that is easy to administer, flexible, scaleable and is further expanded by its built-in Internet/Intranet and communication services. NT 4.0 competes head-on with UNIX and NetWare as a comprehensive solution to enterprise-wide computing. Indications show that Windows NT is steadily gaining market share.
Table of Contents:
Part 1 Managing SQL Server: introduction - brief overview of relational databases; brief history of SQL Server; new features in Release 7.0; SQL SQL Server fundamental concepts - SQL Server's client/server model, SQL Server basic components, servers, databases, devices, transact-SQL, administrator, command-line utilities; SQL Server administration - using the SQL Enterprise Manager, starting and stopping SQL Server, installing clients, creating databases, creating tables, SQL Server data types, creating indexes, creating views, using transact SQL, creating stored procedures, importing and exporting data; SQL Server security - SQL Server security concepts, standard security, integrated security, using the SQL Security Manager, adding administrators, adding and dropping users, adding and dropping groups, securing databases, securing table and views, securing columns, using permissions, restricting access through views; SQL Server backup and recovery - using checkpoints, backing-up and restoring databases, back-up and restoring transaction logs, using removable media; data warehousing with SQL Server - SQL Server replication fundamentals, system requirements, replication model, publisher, distributor, subscriber, the pushing model, the pulling model, setting up SQL Server data replication, setting up publishing, setting up a subscriber, publishing to ODBC data sources; performance tuning SQL Server - sizing a database, putting tembdb in RAM, caching, indexing, using ShowPlan, using stored procedures, NT Performance Monitor; advanced management using SQL DMO - the DMO architecture, application, SQL Server, database, tables, sample DMO application - export tables, adding the SQL OLE reference to VB, enumerating collections. Part 2 Database development with SQL Server: introduction to relational databases; an SQL primer; developing applications with VB and DAO; developing applications with ODBC; developing applications with VB and RDO; developing applications with VB library OCX; developing Internet applications. (Part contents)
