A Data Access Worldwide White Paper by Marcia Ferreira – The main objective of this White Paper is to list all the installation steps that one needs to go through on both Server and Client (using Windows NT), and some configuration involved when preparing Pervasive.SQL 2000 version 7.82 to be the ba

Dynamic SQL is a term used to mean SQL code that is generated programatically (in part or fully) by your program before it is executed. As a result it is a very flexable and powerful tool. You can use dynamic sql to accomplish tasks such as adding where clauses to a search based on what fields are f

The printed SQL Server 2000 system table map has been a very popular tool for database administrators, programmers, and other professionals working with SQL Server 2000. The online system table map incorporates the benefits of the visual representation of table relationships from the printed version

Coming off record breaking attendance at the last user event in San Francisco, PASS 2001 North America is gearing up for the premier SQL Server user conference. This is a great opportunity for you to increase your knowledge base and stay in touch with the issues and solutions affecting your technolo

Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) is the compact database for rapidly developing applications that extend enterprise data management to mobile and embedded devices. Developers, database administrators, and IT Professionals can now download the 120-day trial sof

Microsoft has added an enormous amount of features to DTS – Data Transformation Services – in its new release of SQL Server. In this session, you will learn about the new tasks in SQL Server 2000 and how they can help transform data.

A complete database and analysis package, SQL Server 2000 delivers a new generation of features and functionality that help you adapt to ever-changing data management and analysis requirements. Great support for Web standards, powerful new tools for system management and tuning, and truly affordable

By Brad M. McGehee – In case you need a little escape from work, a challenge, or you just want to learn a little more, I have created a 20 question quiz to test your knowledge about SQL Server performance tuning and optimization. The quiz covers SQL Server performance tuning basics that apply to eve

By S.S. Ahmed – The SQL Distributed Management Objects (SQL-DMOs) are OLE automation-compatible COM objects. These objects and a set of properties and methods are used to write programs to administer multiple SQL Servers distributed across a network. Also, SQL-DMO is the foundation of SQL Enterprise

As an e-commerce business, you must deliver the highest levels of trust and security so your customers can be certain that your site is genuine, and that the information they send you via Web browsers, and other devices stays private and confidential. VeriSign's Site Trust Services offer you