Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issue

Automation Technology, Inc. (ATI) releases beta version 5.0 of OpenAccess SDK. We have been hard at work adding SQL 99, Unicode, and .NET enhancements to the OpenAccess SDK product suite. Newly added features include Arrays and WCHAR data types.

The Microsoft SQL Server product team is accepting applications for the SQL Server 2000 Service Pack 2 (SP2) beta program. Only registered members of this private program will receive the beta version of SP2 for testing and evaluation purposes. Apply today to become a part of this select group.

The error message shown in the "Symptoms" section may occur if the application receives an error during the initial synchronization. When an error occurs during the initial synchronization process, the subscription is actually incomplete and does not contain all of the required metadata and system t

Voss Software Development announces ItemAction Version 2.1.1 with All New History View and Enhanced Database code! Access DB and SQL Server support. Switch Databases on the fly! Powerful, Flexible, and Affordable.

Scan through full texts of slightly outdated database books covering Access, Informix, Oracle, SQL Server and various programming languages.

This article describes how to change the location of the data and log files for any SQL Server 7.0 or SQL Server 2000 database.

by Various Writers – Learn the basics of how to program Analysis Services using ADO MD from the book, Professional SQL Server 2000 Data Warehousing with Analysis Services from Wrox Press.

This book is for VB programmers, with a grasp of ASP and SQL, who want to leverage their skills into producing high quality, low cost e-commerce solutions for small businesses. This book will take you from apllication development to ISP-hosted solution deployment. To get the most from this book you’

By Itzik Ben-Gan and Thomas Moreau – This article is a chapter excerpt from the book Advanced Transact-SQL for SQL Server 2000 from APress Books. This chapter covers the use of declarative referential integrity as well as the use of triggers to maintain data integrity.