The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
In this issue, learn how to upgrade from SQL Server 6.5 to 2000, explore the new Visual Studio .NET, check out Analysis Services' drillthrough and actions features, and use our database replication buyer's guide to start researching your next purchase.
By Dan Fox
Learn how to implement the Analysis Services' drillthrough and actions features from a developer's point of view.
By Michelle A. Poolet
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 Michael Otey
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 Russ Whitney
The January MDX puzzle challenged you to write a query that sorts a set in ascending order while making sure the parents appear after their children. Here's a clever solution.
Create a calculated measure that returns a prediction of unit sales for the end of the current quarter, then use that calculated measure in an MDX query to predict unit sales for each month in fourth quarter 1997.
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.
Upgrading from SQL Server 7.0 to SQL Server 2000 is much less of a hassle than upgrading from SQL Server 6.5. Here's what you need to know.
Learn how to use the Generate() function and named sets in MDX to support iteration in your data-analysis solutions.
By Rich Rollman
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
Readers write in about using bcp with columns that have the identity property defined and about the value of SQL Server Magazine.
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.
Learn about seven new database-integration tools that can help you use Visual Studio .NET with SQL Server.
By Michael Hotek
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 Brian Moran
A reader asks how to avoid an error when executing the TRUNCATE TABLE command with linked servers.
Learn how to tweak the registry to change the default MSDE security mode.
By Kalen Delaney
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.
An example shows how to use the QUERYOUT keyword to facilitate copying a result set of a stored procedure.
By Scott Firestone IV
A collection of the latest new and improved products for the SQL Server market.
Microsoft’s SQL Server development team explains how to get a trigger to fire for each row that you insert.
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.
Changing the nullability of a column appears to make Enterprise Manager lock up--is this a known bug?
Some of the .NET Framework SDK's core enhancements lie in the new .NET-enabled languages. Let's look at three of them.
By Itzik Ben-Gan
Sometimes, avoiding cursors is tricky, but it's still possible, as this article demonstrates.
When you choose a primary key, remember that SQL Server manages simple data types more easily than variable-length character fields.
advertisement