This text covers the core SQL Server topics combined with step-by-step application development. It is written from a Visual Basic developmental angle covering topics such as SQL DMO, Extended Stored Procedures, ODBC and the VBSQL OCX.
Part I: Managing SQL Server. An Essential Overview of SQL Server. SQL Server Administration. SQL Server Security. SQL Server Backup and Recovery. Data Replication and Data Warehousing. Data Performance. Advanced Management Using SQL-DMO. Part II: Database Development with SQL Server. Introduction to the Relational Database Model. SQL Primer: Data Definition Language. SQL Primer: Data Manipulation Language. Developing SQL Server Database Applications with Access. Developing SQL Server Database Applications with DAO and ODBCDirect. Developing NT Database Applications with RDO. Developing SQL Server Database Applications with OLE DB and ADO. Developing Database Applications with DB-Library. Web Integration and ASP Development. Part III: Appendices: A: Migrating from SQL Server 6.x to 7. B: Maximum Capacities.
