SQL Server Magazine August 1999
[Focus]
The SQL Server Magazine migration alerts you to compatibility conflicts you'll encounter in migrating from SQL Sever 6.5 to 7.0
By Don Awalt , et al.
[Features]
Microsoft Transaction Server (MTS) is a powerful middleware system for NT that manages objects and transaction processing. Here's how you can use MTS as an interface between COM objects and applications that use them.
By Ken Spencer
SQL Server 7.0's improved query optimizer generates statistics from index and column.
By Kalen Delaney
Office 2000 brings in new capabilities, including a new file type, to take SQL Server data across the office.
By Rick Dobson
If you have waited to implement a new version of your corporate database until Microsoft released its first service pack, now is the time to start using SQL Server 7.0.
By Andrey Kruchkov
[Columns]
One of the most touted new features of SQL Server 7.0 is its ability to do true row-level locking.
By Kalen Delaney
Member Properties let you increase the amount and type of information available for analysis in a data cube.
By Brian Moran , et al.
A foreign key is an integral part of relational database design. It establishes relationships between tables, and it makes possible the procedures that cross-reference data stored in separate tables in the database.
By Michelle A. Poolet
Every column in a table must have a defined data type that controls the values you can enter into that column. Learn how user-defined data types can add a level of consistency and control to your projects.
By Michael D. Reilly
Microsoft has identified healthcare as a vertical market.
By Karen Watterson
The Data Environment's graphical nature and tools makes it easy to create data applications without having to remember a lot of technical details about the underlying ADO code.
By Ken Spencer
[Departments]
Companies are focusing significant development resources toward business intelligence, which is becoming a core component of many IS departments.
By James Drover
Is there a market for SQL Server lite?
By Hugh Willoughby-Davis
This month's topics include aliases in SQL Server 7.0, DTC service errors, restoring database users, foreign-key levels, and network packet size.
By Richard Waymire
[Editorial]
What does Microsoft have up its sleeve? Senior technical editor Michael Otey speculates on the company's product development plans.
By Michael Otey
[SQL Seven]
Here's a look at SQL Server's seven core database replication components, which let database changes propagate across a LAN or WAN connection to target systems.
By Michael Otey
|
