SQL Server Magazine August 2000

    Options
Interoperability and Exclusive Paul Flessner Interview
SQL Server MVPs Kalen Delaney and Itzik Ben-Gan introduce you to the new distributed partitioned views technology available in SQL Server 2000. Also, we'll show you how to set up linked servers in SQL Server 7.0. PLUS: An exclusive interview with Microsoft VP of SQL Server Paul Flessner. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

Browse Archived Articles By: Issue | Author | Subject | Department |


[Focus]

Distributed Partitioned Views

Learn how to deploy the technology behind Microsoft's scale-out strategy.
By Kalen Delaney  , et al.

Linked Servers

Linked servers, the core technology in SQL Server 2000 distributed partitioned views, let you use distributed queries to query a SQL Server or non-SQL Server database as if it were on the local server.
By Brian Knight 



[Features]

An Early Look: SQL Server 2000 Windows CE

This pint-sized application gives mobile users powerful database functionality.
By Morris Lewis 

Setting SQL Server 7.0 and IIS Security

Follow these steps to upgrade your SQL Server security and improve data connection performance.
By John D. Lambert 

The Future of SQL Server

Contributing editor and SQL Server MVP Brian Moran talked recently with Paul Flessner, Microsoft’s VP of SQL Server and middleware, about the evolution of SQL Server and its role in corporate IT environments.
By Brian Moran 



[SQL Server Savvy]

Questions, Answers, and Tips

Read about finding installed OLE DB providers, escalating page locks to table locks, setting default values, and Microsoft's support policy for existing SQL Server versions.
By Brian Moran 



[Editorial]

DOJ vs. Microsoft

The Microsoft split won’t do the company—or consumers—any good.
By Michael Otey 



[Reader to Reader]

Readers' Tips and Tricks

A reader revisits a June Reader to Reader tip about shrinking active log files, which could have disastrous consequences, and shares a safe way to shrink log files.
By Various Authors 



[SQL Server Q&A]

Answers from Microsoft This article is only available to registered users. Sign up now and get instant access!

Here are answers to readers’ questions about dropping a database, starting SQL Server Services, and more.
By Richard Waymire 



[SQL Seven]

Installing Service Pack 2

Follow these steps to ensure that your SQL Server 7.0 Service Pack 2 (SP2) upgrade goes smoothly.
By Michael Otey 



[SQL Server/Office Integration]

Datetime Values in Access Projects

Learn how Access handles dates and times to extract results in the format you need.
By Rick Dobson 



[Inside SQL Server]

Managing Multiple Instances

Learn more about SQL Server 2000's ability to run multiple SQL Server installations on one machine.
By Kalen Delaney 



[Web Dev]

Debugging with Visual InterDev

Follow these steps to unleash the full power of the Visual InterDev debugging tool.
By Ken Spencer 



[Mastering Analysis]

Ragged Hierarchies

Here’s how SQL Server 2000 Analysis Services handles unbalanced hierarchies.
By Russ Whitney 



[Solutions by Design]

The Physical Design

Create a physical design to document and verify all of your database's physical implementation requirements before you start implementing the live database.
By Michelle A. Poolet 



[T-SQL Black Belt]

Using T-SQL with Magic Squares

Learning how to use T-SQL to populate magic square can sharpen your programming skills for more practical tasks.
By Itzik Ben-Gan 



[News Analysis]

Industry News

SQL Server Magazine presents Best of Show awards, and PASS 2000 North American is scheduled for October 2000 in San Francisco.
By Various Authors