Microsoft SQL Server 2000
A Guide to Enhancements and New Features
Book Details:
Pages: | 592 |
Published: | Mar 19 2002 |
Posted: | Nov 19 2014 |
Language: | English |
Book format: | CHM |
Book size: | 1.33 MB |
Book Description:
This is a focused guide to SQL Server 2000 for experienced SQL Server administrators and developers. Rahul Sharma focuses on helping professionals take advantage of the powerful new features built into SQL Server 2000 -- and on providing real-world solutions, scripts, and utilities that can dramatically improve your effectiveness. Sharma begins with an overview of SQL Server 2000 focused on its compelling new features for both OLTP and OLAP applications. He reviews major enhancements to SQL Server 2000, including XML support, tight Web integration, indexed views, distributed partitioned views, user-defined functions, and more. Next, he moves on to advanced SQL Server 2000 database administration, including the use of SQL-DMO object models, database consistency checks, optimization techniques, and the latest bug fixes. The book includes a detailed comparison with Oracle 9i, as well as specific guidance for database professionals migrating to SQL Server or planning to use both databases in tandem. An extensive library of powerful scripts and utilities for SQL Server administration is presented in the book and on the accompanying CD-ROM. Sharma concludes with a preview of SQL Server.N ET, and the evolving role of databases in the .NET era. For all SQL Server database administrators, developers, and managers, and for others who depend upon SQL Server databases, including Web and e-Business professionals.
Reporting Services
Design and deliver insightful and interactive Web-based reports Transform your companys valuable data into easily shared information with help from this definitive resource. Written by a member of the development team, this hands-on guide covers everything from installation to administration and shows you how to create visually appealing reports with ease and accuracy. Youll get a firm understanding of the entire report-building process by following a case study throughout the course of the book. Learn first-hand how to extract data using Query Builder and master key tools such as the Report Wizard and Report Manager. Leverage the power of Microsofts most powerful server-based reporting solution to improve business decision-making and facilitate comp...
Database Design
Each lesson covers one broad topic or set of related topics. Lessons are arranged in order of increasing proficiency with Microsoft SQL Server 2000; skills you acquire in one lesson are used and developed in subsequent lessons. For this reason, you should work through the lessons in sequence. We organized each lesson into explanatory topics and step-by-step activities. Topics provide the theory you need to master Microsoft SQL Server 2000, and activities allow you to apply this theory to practical hands-on examples. You get to try out each new skill on a specially prepared sample file. This saves you typing time and allows you to concentrate on the technique at hand. Through the use of sample files, hands-on activities, illustrations that give you fe...
Unleashed
2nd Edition
Microsoft SQL Server 2000 Unleashed, 2E offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server 2000 Unleashed covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL Server CE....
2007 - 2021 © eBooks-IT.org