The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Fernando G. Guerrero
Use UDFs in SQL Server 2000 to create new IDENTITY functionality.
By Rick Dobson
You can use SQL-DMO to program a custom security interface.
By Brian Moran
SQL Server Query Analyzer templates offer a great way for novices to quickly write SQL scripts for specific tasks.
By Michael Otey
Here's a preview of the seven main objects in the ADO.NET data-access architecture.
By Paul Thurrott
XML for Analysis, Microsoft’s new protocol for Web-based business intelligence, promises to boost OLAP and data-mining capabilities across the Internet.
By Michelle A. Poolet
Consult these Web sites for Visio 2000 user documentation.
Visio 2000 Enterprise Edition helps you model everything from databases to software applications.
Mircrosoft’s Ballmer hints at a future starring role for Yukon, SQL Server’s next generation, in the development of .NET and Windows technology.
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 Kalen Delaney
Learn how to let your SQL Server use more memory.
By Bob Pfeiff
Use SQL Server 2000’s FOR XML EXPLICIT mode to produce data in XML format.
The Transaction Processing Performance Council now sorts its results in a way that lets Oracle claim one top spot.
By Rich Rollman
Rich Rollman answers readers' questions about representing many-to-many relationships and building a SELECT statement into a template.
By Russ Whitney
The powerful new Cell Properties feature in SQL Server 2000 Analysis Services lets analysis applications support exception highlighting.
Part 3 of Bob Pfeiff's "Relational to Dimensional" series shows you how to periodically refresh the data in your data mart.
By
Readers share their tips for viewing transaction logs, cascading outer joins, and finding and inserting missing records.
By Itzik Ben-Gan
Learn several ways to return a sorted output based on a parameter that you pass to a stored procedure.
Here's the solution to February's MDX puzzle.
By Richard Waymire
Richard Waymire answers questions about security with dynamic T-SQL, executing local temporary tables, and more.
Here's the MDX puzzle for March.
By Brian Knight
By eliminating some options and revamping others, Microsoft helps you to better configure SQL Server.
By Wayne Snyder
Learn to properly define various types of relationships to take full advantage of English Query.
advertisement