SQL Server Magazine March 2001
[Focus]
By eliminating some options and revamping others, Microsoft helps you to better configure SQL Server.
By Brian Knight
[Features]
Learn to properly define various types of relationships to take full advantage of English Query.
By Wayne Snyder
Use SQL Server 2000’s FOR XML EXPLICIT mode to produce data in XML format.
By Bob Pfeiff
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
Use UDFs in SQL Server 2000 to create new IDENTITY functionality.
By Fernando G. Guerrero
[SQL Server Savvy]
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]
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 share their tips for viewing transaction logs, cascading outer joins, and finding and inserting missing records.
By Various Authors
[SQL Server Q&A]
Richard Waymire answers questions about security with dynamic T-SQL, executing local temporary tables, and more.
By Richard Waymire
[SQL Seven]
Here's a preview of the seven main objects in the ADO.NET data-access architecture.
By Michael Otey
[SQL Server/Office Integration]
You can use SQL-DMO to program a custom security interface.
By Rick Dobson
[Inside SQL Server]
Learn how to let your SQL Server use more memory.
By Kalen Delaney
[Mastering Analysis]
The powerful new Cell Properties feature in SQL Server 2000 Analysis Services lets analysis applications support exception highlighting.
By Russ Whitney
[Solutions by Design]
Visio 2000 Enterprise Edition helps you model everything from databases to software applications.
By Michelle A. Poolet
[T-SQL Black Belt]
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]
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
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]
Rich Rollman answers readers' questions about representing many-to-many relationships and building a SELECT statement into a template.
By Rich Rollman
|
