SQL Server

Professional SQL Server 7.0 Programming

Name: Professional SQL Server 7.0 Programming
Author: Robert Vieira
ISBN: 9781861002310

by Robert Vieira, Robert Vieria, Rob Vieira

Write a review

Overview

With a general understanding of programming principles, SQL Server Programming provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server. From basic database design concepts a tutorial explains more advanced topics and specific areas including Stored Procedures and Advanced Queries. Advanced topics of performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. Data Transformation Services are explained in detail and Remote and Linked SQL Server Agents are covered. With over 1,000 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so programmers can get the most out of SQL Server 7.0.

Senior Software Engineer STEP Technology. With 15 years database experience, Rob has moved from analyst, coding and architectural roles with primary focus on data. With 4 years SQL Server experience, focus is primarily on database architecture and advanced database and query design to produce a string of qualifications.

Synopsis

With the big step up from 6.5 to 7.0, SQL Server 7.0 is effectively a new product that can be installed on a pc. This enables a more flexible and powerful database for high database transaction volume. Microsoft SQL Server 7.0 is available as a standalone product and also as part of the Microsoft Backoffice suite of products. The adoption of SQL Server 7.0 is reflected in increasing sales figures for competing titles.

About the Author, Robert Vieira

Robert Vieira is Senior Software Engineer of STEP Technology. With 15 years database experience, Rob has moved from analyst, coding and architectural roles with primary focus on data. With 4 years SQL Server experience, focus is primarily on database architecture and advanced database and query design to produce a string of qualifications.