SQL Server Magazine

		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 |

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 

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 

RippleTech LogCaster 2.51

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

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 

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 

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 

Answers from Microsoft

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

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 

Securing SQL Server Through Access

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

Database Recovery Models

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

Solving Error-Handling Mysteries

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

Entity Modeling

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

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 

Analysis Services Drillthrough

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