SQL Server Magazine March 2001

    Options
Configuring SQL Server
In SQL Server 2000, Microsoft made several substantial new server and database configuration changes that will make your life as a DBA easier. Read all about them in this issue. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

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


[Focus]

Configuring SQL Server 2000 Options

By eliminating some options and revamping others, Microsoft helps you to better configure SQL Server.
By Brian Knight 



[Features]

English Query Relationships

Learn to properly define various types of relationships to take full advantage of English Query.
By Wayne Snyder 

In Control with FOR XML EXPLICIT

Use SQL Server 2000’s FOR XML EXPLICIT mode to produce data in XML format.
By Bob Pfeiff 

Refreshing the Data

Part 3 of Bob Pfeiff's "Relational to Dimensional" series shows you how to periodically refresh the data in your data mart.
By Bob Pfeiff 

UDFs Provide a New IDENTITY

Use UDFs in SQL Server 2000 to create new IDENTITY functionality.
By Fernando G. Guerrero 



[SQL Server Savvy]

Questions, Answers, and Tips

SQL Server MVP Brian Moran answers readers' questions about debugging triggers and stored procedures, creating Data Transformation Services packages in Visual Basic, and more.
By Brian Moran 



[Editorial]

Perception vs. Reality

The Transaction Processing Performance Council now sorts its results in a way that lets Oracle claim one top spot.
By Michael Otey 



[Reader to Reader]

Readers' Tips and Tricks

Readers share their tips for viewing transaction logs, cascading outer joins, and finding and inserting missing records.
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 questions about security with dynamic T-SQL, executing local temporary tables, and more.
By Richard Waymire 



[SQL Seven]

ADO.NET's Primary Objects

Here's a preview of the seven main objects in the ADO.NET data-access architecture.
By Michael Otey 



[SQL Server/Office Integration]

Programming SQL Server Security

You can use SQL-DMO to program a custom security interface.
By Rick Dobson 



[Inside SQL Server]

Memory Management

Learn how to let your SQL Server use more memory.
By Kalen Delaney 



[Mastering Analysis]

Setting Display Characteristics

The powerful new Cell Properties feature in SQL Server 2000 Analysis Services lets analysis applications support exception highlighting.
By Russ Whitney 



[Solutions by Design]

CASE Tool: Visio 2000

Visio 2000 Enterprise Edition helps you model everything from databases to software applications.
By Michelle A. Poolet 



[T-SQL Black Belt]

Parameterizing Result Order

Learn several ways to return a sorted output based on a parameter that you pass to a stored procedure.
By Itzik Ben-Gan 



[News Analysis]

Microsoft Unveils XML for Analysis

XML for Analysis, Microsoft’s new protocol for Web-based business intelligence, promises to boost OLAP and data-mining capabilities across the Internet.
By Paul Thurrott 

SQL Server Yukon is Key

Mircrosoft’s Ballmer hints at a future starring role for Yukon, SQL Server’s next generation, in the development of .NET and Windows technology.
By Paul Thurrott 



[XML Q&A]

XML Q&A This article is only available to registered users. Sign up now and get instant access!

Rich Rollman answers readers' questions about representing many-to-many relationships and building a SELECT statement into a template.
By Rich Rollman