SQL Server Magazine March 1999
[Focus]
Fixed upper limits to database size frustrate database administrators (DBAs) using SQL Server 6.5. Microsoft changed space management in SQL Server 7.0, making your life easier. Databases can grow and shrink automatically.
By Kalen Delaney
DTS provides a fast, robust, extensible architecture for moving data out of traditional relational databases and into Microsoft's new SQL Server OLAP Services.
By Don Awalt , et al.
SQL Server 7.0 supports distributed heterogeneous queries, which let you compile data from multiple sources, including relational and non-relational databases. The examples in this article focus on distributed queries running against Access.
By Brian Moran
[Features]
Microsoft's ActiveX Data Object (ADO) implements the client side of the Universal Data Access (UDA) specification, which lets you access data in all forms. Here's a primer on using ADO to access SQL Server databases.
By Morris Lewis
Security in SQL Server 7.0 is more flexible--and more complex--than in SQL Server 6.5. This overview includes a primer on the hottest new part of SQL Server 7.0 security: database roles, sets of permissions associated with specific functionality.
By Victoria Launders
As Visual Basic and SQL Server evolve, data-access options increase. Microsoft offers five primary interfaces, and several of those have various flavors. Examine the interface options and tips for choosing the best interface for your project.
By Ken Miller
[Columns]
Welcome to SQL Server Magazine
By Mark Smith
Database normalization is a technique to organize the contents of tables for transactional databases and data warehouses. Organizing tables properly is crucial for system accuracy and performance.
By Michelle A. Poolet
The inclusion of OLAP Services in SQL Server 7.0 heralds the widespread use of business intelligence products.
By Michael Otey
For readers who are new to database management, this column defines Transact SQL (T-SQL) and gives you a tour of SQL Query windows, which you use with T-SQL to retrieve, change, and add data to databases.
By Michael D. Reilly
Some critics worry that Microsoft's wizard-festooned SQL Server 7.0 will put DBAs and toolmakers out of work, but indications are to the contrary.
By Karen Watterson
[Lab Reports]
Crystal Reports 7.0, the latest release of Seagate Software's widely used and highly acclaimed report writer, provides a sophisticated graphical report designer that you can use with many databases.
By Michael P. Deignan
[Departments]
Use SQL Server's Enterprise Manager and SMS Security Manager to complete the 6-step process of securing your SMS.
By Various Authors
The business intelligence market heats up, Microsoft offers certification for SQL Server professionals, and database vendors evaluate Java for their products.
By Craig Barth , et al.
[SQL Server Q&A]
A SQL Server 7.0 program manager for Microsoft gives you tips for a smooth upgrade. Topics include upgrading from SQL Server 4.21 to SQL Server 7.0, migrating stored procedures, and installing the client utilities for SQL Server 7.0.
By Richard Waymire
[SQL Seven]
Mike Otey, senior technical editor for SQL Server Magazine, lists his top seven favorite features of SQL Server 7.0.
By Michael Otey
[Inside SQL Server]
Pages in SQL Server 7.0 are 8KB in size rather than 2KB. This page capacity growth required other features to change. Here's how you and your applications can benefit from the new, larger page size.
By Kalen Delaney
[VB Toolkit]
In a push to make ActiveX Data Object (ADO) easier to use, Microsoft introduced new database technologies in Visual Basic (VB) 6.0. Here are tips on using Data Environment, an ActiveX designer that provides a graphical front end for building databases.
By Ken Spencer
|
