SQL Server Magazine June 2000

    Options
Windows 2000 and SQL Server
Windows 2000--the fifth major release of the Windows NT OS--includes many sophisticated features that enable it to compete head-to-head with UNIX systems in the enterprise market. And Win2K's networking and usability improvements make the new OS a better database platform for SQL Server than NT 4.0. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

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


[Focus]

Windows 2000 and SQL Server

Organizations that adopt Win2K will pay a price in increased processor and memory requirements, but they’ll reap commensurate rewards in system reliability, performance, and manageability.
By Michael Otey 



[Features]

English Query from the Beginning

English Query (EQ) gives users maximum flexibility to get answers from SQL Server databases. We'll show you how to set it up and preview what's new in EQ 2000.
By Wayne Snyder 

Indexing for Sort Performance

Defining the right indexes on sort columns can yield dramatic performance results for queries that need ordered data.
By Dusan Petkovic  , et al.

Relational to Dimensional

This simple data mart solution demonstrates an effective way to pull operational data into a dimensional database so that decision makers can quickly and easily access business information.
By Bob Pfeiff 



[Lab Reports]

RippleTech LogCaster 2.51

Ripple Technologies' flexible monitoring program keeps a watchful eye on SQL Server and other critical applications.
By Jonathan Chau 



[SQL Server Savvy]

Questions, Answers, and Tips

Learn how to use CONVERT to format dates, how to use –L options to find SQL Servers on a LAN, how to find disabled triggers, what happens when your 120-day SQL Server 7.0 Evaluation Edition expires, and more.
By Brian Moran 



[Editorial]

SQL Server Is Tops

How did Windows 2000 and SQL Server 2000 blow the lid off the TPC benchmark scores? By employing new distributed partitioned view technology, which consists of joined, updateable views that span multiple servers.
By Michael Otey 



[Reader to Reader]

Readers' Tips and Tricks

Readers share their tips for accessing the appropriate table view, safely changing SQL Server 7.0's service account, and shrinking an active log file in SQL Server 7.0.
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!

Richard Waymire answers your questions about SQL Server.
By Richard Waymire 



[SQL Seven]

Finding Tools in Windows 2000

If you’re moving from Windows NT to Windows 2000 (Win2K), you’ll need these directions for finding your favorite administrative tools in Win2K.
By Michael Otey 



[SQL Server/Office Integration]

Securing SQL Server Through Access

Here are the basics of SQL Server security for Access 2000 projects.
By Rick Dobson 



[Inside SQL Server]

Database Recovery Models

SQL Server 2000 recovery models replace two database options and give you more flexibility for backup and recovery.
By Kalen Delaney 



[Web Dev]

Solving Error-Handling Mysteries

When you’re troubleshooting Web applications, the answers you seek aren’t always in obvious places.
By Ken Spencer 



[Solutions by Design]

Entity Modeling

When you use entity relationship diagrams to map your business' data, the database begins to take shape.
By Michelle A. Poolet 



[Certifiably SQL]

Defining Jobs

SQL Server 7.0 lets you set up not just a single task, but a series of tasks with dependencies.
By Michael D. Reilly 



[Mastering OLAP]

Analysis Services Drillthrough

Dig deeper with drillthrough, a new feature of SQL Server 2000 Analysis Services.
By Russ Whitney