Advanced SQL Database Programmer Handbook

Author: Donald K. Burleson, John Paul Cook, Joe Celko

Publisher: Rampant TechPress

ISBN: B0000DYXK5

Maker: Team DDU

Pages: 100 Pages

Packer: Team DDU

Edition: September 2003

Supplier: Team DDU

Language: ENGLISH

Format: PDF

RLS Date: 03/03/04

Size: 12.8 MB

    Written by the world's top SQL programmers, this eBook utilizes their substantial knowledge in SQL database programming. With combined experience of over a century, these experts share their secrets for programming with SQL. This is an advanced eBook that explores topics such as using advanced SQL constructs and writing programs that utilize complex SQL queries. Not for the beginner, this eBook explore complex time-based SQL queries, managing set operations in SQL, and relational algebra with SQL. This is an indispensable handbook for any developer who is challenged with writing complex SQL inside applications.

Inside Microsoft SQL Server 2000

ISBN:0735609985

Author:Kalen Delaney

Publisher:Microsoft Press

Page:1088 pages

Edition:Book and CD edition (November 15, 2000)

Catalog:Database Management - SQL Server

Format:CHM

Size:7.60 MB

Supplier:Unknown

    To help you design Microsoft database servers that must achieve the best possible performance, Inside Microsoft SQL Server 2000 has the details you need. For one thing, author Kalen Delaney (who used Ron Soukup's fantastic first edition as a starting point) explains how SQL Server 2000 works at a level that will interest all database administrators. She packs in the sort of minutiae that can make a real difference in the performance of especially large or complex data-storage structures, explaining what goes on inside the database management system (DBMS) when it's presented with various commands, and using that information to back up her abundant advice on the right way to design, build, and operate databases under SQL Server 2000.

Microsoft Access Projects with Microsoft SQL Server

ISBN:0735610029

Author:Ralf Albrecht and Natascha Ni / Ralf Albrecht / Dr. Natasha Nicol

Publisher:Microsoft Press

Page:656 pages

Edition:Book and CD-ROM edition (January 16, 2002)

Catalog:Client/server computing

Format:CHM

Size:18.49 MB

Supplier:Unknown

    Here's the expert, hands-on guidance that professional Access programmers need to fully exploit the world-class scalability and knowledge-management capabilities in SQL Server 2000. This authoritative guide focuses on understanding and using the innovative Microsoft Data Engine (MSDE) technology that serves as the powerful core of SQL Server 2000. Readers are taken inside its high-performance data-management and data-replication features, developers dive into a whole new subset of Access technologies, known as Access projects, that they must learn in order to effectively program for SQL Server 2000. Topics include the Access project interface, specification table techniques, data types and constraints, and forms techniques. The book digs into stored procedures-a subject that's new to most Access developers-in depth and covers ASP and security issues as well. Throughout, the emphasis is on applying the reader's expertise building desktop database tools to accessing the enterprise-level power and performance in SQL Server 2000. The CD-ROM features all the book's sample applications, as well as a complete electronic version of the text for fast searches and reference.

Programming Microsoft SQL Server 2000 With XML

ISBN:0735613699

Author:Graeme Malcolm

Publisher:Microsoft Press

Page:277 pages

Edition:Book and CD edition (June 30, 2001)

Catalog:Client/server computing

Format:CHM

Size:1.22 MB

Supplier:Unknown

    For any developer who wants to do more with XML and databases on Windows, Programming Microsoft SQL Server 2000 with XML provides an up-to-date guide to some current XML tools and features available on the Microsoft platform. This example-packed book can let you get more productive with the latest generation of SQL Server tools.

SQL Server 2000 for Experienced DBAs

ISBN:0072227885

Author:Brian Knight

Publisher:McGraw-Hill Osborne Media

Page:520 pages

Edition:(March 25, 2003)

Catalog:Client/server computing

Format:CHM

Size:7.25 MB

Supplier:Team LiB

    After reviewing some of the issues that commonly arise during SQL server installation and administration, this guide offers advanced advice on tuning the server, optimizing administration tasks through automation, and deploying SQL server in the Enterprise environment. Step-by-step instructions are provided for working with data transformation services (DTS), rebuilding SQL registry entries after reinstalling Windows, developing a backup and recovery plan, configuring log shipping, and replicating data.