SQL Server 7.0 - Maintain

Security

• TechNet SQL Server Security Center
  

  Access the latest security news for SQL Server, plus technical information about SQL Server security features and best practices to improve your database security.

• SQL Server 7.0 Security
  

  Learn about SQL Server 7.0 security features for developers and administrators and how to best configure and manage secure database servers.

Querying and Text Searches

• SQL Server 7.0 Query Processor
  

  This document describes the innovations and improvements to the SQL Server query processor, that portion of the database server that accepts SQL syntax, determines how to execute that syntax, and executes the chosen plan.

• Accessing Heterogeneous Data with SQL Server 7.0
  

  Find out how the Universal Data Access (UDA) architecture of SQL Server 7.0 is your key to developing powerful distributed solutions.

• SQL Server 7.0 Distributed Queries: OLE DB Connectivity
  

  This document describes how the Microsoft SQL Server 7.0 query processor interacts with an OLE DB provider to enable distributed and heterogeneous queries. Emphasis is on the OLE DB interface between the SQL Server query processor and the OLE DB provider.

• Optimizing Query Performance
  

  Get guidelines for optimizing query performance in this sample chapter from Inside Microsoft SQL Server 7.0.

• Advanced Query Techniques
  

  Learn how to query effectively through the use of subqueries and cursors by reviewing this sample chapter from SQL Server 7.0 Database Implementation Training Kit.

• Extensions to SQL Server to Support Full-Text Search
  

  This paper discusses SQL Server 7.0 facilities that support textual queries on data residing in SQL Server, including the support of textual queries against data within SQL Server tables.

• Textual Searches on File Data Using SQL Server 7.0
  

  Learn how to use SQL Server for textual searches, how queries can be used on file systems lacking tables, and which SQL Extensions you'll need to run full-text queries.