SQL Server Magazine December 2000
[Focus]
Lab tests show that Virtual Interface (VI) Architecture network adapters cLAN and ServerNet II can boost SQL Server processing performance.
By John Green
Learn how SQL Server 2000 improvements, including online index defragmentation and enhanced backup technologies, can give you greater data availability.
By Kalen Delaney
Check out this robust yet low-cost, low-tech road to high availability and disaster protection.
By Ron Talmage
[Features]
Use ADO 2.6 to perform three key XML functions: retrieving XML from stored procedures, executing templates, and executing XPath queries against XML Views.
By Dan Fox
Solve complex problems by teaching your SQL Server 2000 database new tricks with user-defined functions.
By Itzik Ben-Gan
[Lab Reports]
CAST’s analysis tool lets you produce graphical views and reports of your application’s structure.
By Bob Pfeiff
[SQL Server Savvy]
Learn the advantages of storing SQL Profiler trace data in a text file vs. a table, how to query trace data by event class, and more.
By Brian Moran
[Editorial]
Microsoft’s C# development language seems to bring no technological advantages over Sun Microsystems’ Java.
By Michael Otey
[Reader to Reader]
A reader shares his tip for using views to implement security in a data warehouse project.
By Various Authors
[SQL Server Q&A]
Richard Waymire answers questions about moving transaction logs, assigning permissions to Access users, and more.
By Richard Waymire
[SQL Seven]
Check out these seven new DTS tasks introduced in SQL Server 2000.
By Michael Otey
[SQL Server/Office Integration]
You can successfully log in to SQL Server from an Access project when you understand login process aspects such as authentication modes and login accounts.
By Rick Dobson
[Inside SQL Server]
The INSTEAD OF trigger gives you increased flexibility in validating data modifications and lets you update otherwise static views.
By Kalen Delaney
[Mastering Analysis]
Learn to manipulate member properties for improved cube analysis.
By Russ Whitney
[Solutions by Design]
Michelle Poolet's readers take center stage with their questions about her data modeling series.
By Michelle A. Poolet
[T-SQL Black Belt]
You can use INSTEAD OF triggers to—among other tasks—support multirow inserts that fire an AFTER trigger for each row, to log invalid rows to a log table instead of rejecting the whole modification.
By Itzik Ben-Gan
[News Analysis]
Oracle CEO Larry Ellison issued another $1 million challenge this fall.
By Paul Thurrott
Microsoft and Compaq announced in October that they had set a new TPC-C benchmark record with SQL Server 2000.
By Paul Thurrott
[XML Q&A]
In his inaugural XML Q&A column, Rich Rollman answers readers’ questions about using ADO with XML and using XML to populate a data stream outside a Web browser.
By Rich Rollman
|
