SQL Server Magazine October 1999
[Focus]
Are you ready to migrate your Access files to SQL Server 6.5? Here are step-by-step instructions on using the Upsizing Wizard, tips on resolving the problems that the Wizard creates, and an alternative solution to using the Upsizing Wizard.
By Michael D. Reilly , et al.
[Features]
A development team uses SQL Server and Access to create an interactive Web application.
By Bob Pfeiff
Custom transformations in DTS offer powerful maintainability, functionality, and performance. Here's an example showing how you can use a Visual C++ extension to build a custom transformation that generates XML documents from database tables.
By Don Awalt , et al.
A little-known aspect of SQL Server 7.0 can prevent you from getting up-to-the-minute database
recovery. Here's what you can do to protect your business data.
By Wayne Snyder
[Columns]
Certifiably SQL covers topics for those who are seeking certification in SQL Server Administration and Implementation or Data Warehousing with SQL Server.
By Michael D. Reilly
In SQL Server 7.0, reusing compiled plans for stored procedures can make a dramatic difference in overall system performance.
By Kalen Delaney
You can extend the Multidimensional Expression (MDX) language to more tightly integrate it with you OLAP applications.
By Brian Moran , et al.
How Web users can generate reports from Internet and intranet applications of what's on the screen or selected data that they query on.
By Ken Spencer
The goal of a relational database is to store true and accurate data; using NULLs can help achieve this goal.
By Michelle A. Poolet
Read the tea leaves of key technologies--collaboration and KM.
By Karen Watterson
[Departments]
Will SQL Server 7.0 scale to meet my requirements?
By Michael Otey
Delegate tasks by adding new stored procedures. Winners are announced.
By Tibor Karaszi
Creating a user activity log can help you track user activity informtion for decision-making.
By Stefano Bisca
Microsoft answers your questions.
By Richard Waymire
The ADO model exposes the functionality of the OLE DB API to client applications. Here's a review of seven ADO objects.
By Michael Otey
|
