Serve up optimal database solutions with SQL Server 7 Get vital information for developing SQL applications and administering and managing SQL Server in your enterprise environment. SQL Server 7 Developer's Guide by Michael Otey is a breakthrough resource that takes a 360-degree view of SQL to help you take control of database administration and application development. Reduce total cost of ownership within your organization with start-to-finish coverage of core SQL Server 7 concepts including: *Administration techniques using MMC and the Enterprise Manager *Data access using Transact-SQL, SQL-DMO, ODBC, DB-Library, DAO, ODBCDirect, RDO, OLEDB, and ADO *Breaking the speed limit on response times *Performance tuning using SQL Profiler *Rapid development using Access *Web integration using ASP o*Integrated security and roles Includes Data Access Wizards on CD with ready-to-use code samples. See all programs access APIs in action on your own system!
SQL Server 7 database development from start to finish!
Master SQL Server 7 database administration and application development, and learn ways to reduce Total Cost of Ownership within your organization, using this complete guide for power programmers. Written by two SQL Server experts, SQL Server 7 Developer's Guide combines start-to-finish coverage of core SQL Server 7 concepts with step-by-step programming examples in text and on CD-ROM. It also provides special tutorials on relational database concepts and building SQL statements - PLUS a complete guide to using Visual Basic for SQL Server application development.
Inside, learn about:
*Administration techniques using MMC and the Enterprise Manager
*Data access using Transact-SQL, SQL-DMO, ODBC, DB-Library, DAO, ODBCDirect, RDO, OLE DB, and ADO
*Breaking the speed limit on response times
*Performance tuning using SQL Profiler
*Rapid development using Access
*Web integration using ASP
*Integrated security and roles.