The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
This issue alerts you to compatibility conflicts you'll encounter in migrating from SQL Server 6.5 to 7.0. This month also features SQL Server 7.0's query optimizer tool and what's in SQL Server 7.0's Service Pack 1.
By Ken Spencer
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 Richard Waymire
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 James Drover
Companies are focusing significant development resources toward business intelligence, which is becoming a core component of many IS departments.
By Hugh Willoughby-Davis
By Michael Otey
What does Microsoft have up its sleeve? Senior technical editor Michael Otey speculates on the company's product development plans.
By Kalen Delaney
One of the most touted new features of SQL Server 7.0 is its ability to do true row-level locking.
By Russ Whitney
SQL Server 7.0's improved query optimizer generates statistics from index and column.
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 Rick Dobson
Is there a market for SQL Server lite?
By Michael D. Reilly
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 Karen Watterson
Microsoft has identified healthcare as a vertical market.
By Andrey Kruchkov
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.
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 Michelle A. Poolet
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.
Office 2000 brings in new capabilities, including a new file type, to take SQL Server data across the office.
By Brian Lawton
The SQL Server Magazine migration alerts you to compatibility conflicts you'll encounter in migrating from SQL Sever 6.5 to 7.0
Member Properties let you increase the amount and type of information available for analysis in a data cube.
advertisement