SQL Server Magazine February 2002
[Focus]
If you've been putting off upgrading your SQL Server 6.5 databases, now is the time to bring them into the twenty-first century. Don't miss our tips, tricks, and advice about how to prepare for and implement an upgrade to SQL Server 2000.
By Michael D. Reilly , et al.
[Features]
Learn how to implement the Analysis Services' drillthrough and actions features from a developer's point of view.
By Dan Fox
Visual Studio .NET isn't just another pretty face: It's fully .NET-enabled and speaks several new languages. Here are some of its most important new development and database features.
By Michael Otey
[Lab Reports]
Looking for an effective database-replication solution? Here’s a concise product guide that you can use to get your search off the ground.
By Michael Hotek
[SQL Server Savvy]
Changing the nullability of a column appears to make Enterprise Manager lock up--is this a known bug?
By Brian Moran
Learn how to tweak the registry to change the default MSDE security mode.
By Brian Moran
A reader asks how to avoid an error when executing the TRUNCATE TABLE command with linked servers.
By Brian Moran
An example shows how to use the QUERYOUT keyword to facilitate copying a result set of a stored procedure.
By Brian Moran
[Editorial]
As essentially a 1.0 release of a new technology, ADO.NET provides a host of cool new functionality, but it’s also missing some pieces of the more mature ADO technology that it replaces.
By Michael Otey
[SQL Seven]
Learn about seven new database-integration tools that can help you use Visual Studio .NET with SQL Server.
By Michael Otey
[Inside SQL Server]
You can tune GROUP BY or DISTINCT queries by making sure that a covering index exists. Also, learn how SQL Server uses stream and hash aggregation types to process these queries.
By Kalen Delaney
[Mastering Analysis]
Learn how to use the Generate() function and named sets in MDX to support iteration in your data-analysis solutions.
By Russ Whitney
[Solutions by Design]
Choosing between a surrogate identifier and a natural value for your table’s primary key need not be difficult. If your candidate meets the four criteria that this article presents, you have a winner.
By Michelle A. Poolet
[T-SQL Black Belt]
Sometimes, avoiding cursors is tricky, but it's still possible, as this article demonstrates.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server development team explains how to get a trigger to fire for each row that you insert.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team discusses the pros and cons of running virus-scanning software on the same server with SQL Server by evaluating three types of software.
By Microsoft's SQL Server Development Team
[Exploring XML]
If you're converting from XSL to XSLT, you'll find that the context() operator is no longer valid. This Q&A shows you how to work around that omission.
By Rich Rollman
[Letters]
Readers write in about using bcp with columns that have the identity property defined and about the value of SQL Server Magazine.
By Various Authors
[New Products]
A collection of the latest new and improved products for the SQL Server market.
By Carolyn Mader , et al.
|
