The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
In the premiere issue of SQL Server Magazine, we highlight some of the hottest new features of SQL Server 7.0, such as Data Transformation Services, heterogeneous queries, and revised page structures. In this and future issues, we also cover tips, tools, and techniques for leveraging SQL Server 6.5.
By Ken Miller
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 Hugh Willoughby-Davis
The business intelligence market heats up, Microsoft offers certification for SQL Server professionals, and database vendors evaluate Java for their products.
By Michael Otey
The inclusion of OLAP Services in SQL Server 7.0 heralds the widespread use of business intelligence products.
By Morris Lewis
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 Ken Spencer
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 Brian Moran
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 Michelle A. Poolet
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 Brian Lawton
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 Kalen Delaney
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
Use SQL Server's Enterprise Manager and SMS Security Manager to complete the 6-step process of securing your SMS.
By Michael D. Reilly
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 P. Deignan
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 Mark Smith
Welcome to SQL Server Magazine
By Richard Waymire
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.
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 Karen Watterson
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 Victoria Launders
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.
Mike Otey, senior technical editor for SQL Server Magazine, lists his top seven favorite features of SQL Server 7.0.
advertisement