SQL Server Magazine

		Options
Balance Design Choices for Top Performance Build a smooth-running performance-engineering process by using these design, monitoring, and maintenance techniques. Then you'll be able to anticipate certain behaviors and characteristics and determine how they will affect performance.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Database Design for Performance

In a database performance-engineering process, applying the right design techniques will ensure smooth-running operations. Here’s a laundry list of essential technical items you need to include in your process.
By Kimberly L. Tripp 

Making the Most of Login Controls with ASP.NET

ASP.NET 2.0 lets you use Visual Studio login controls with a SQL Server membership provider to dramatically simplify Web-site membership management.
By Rick Dobson 

Take Control of Your Reports with ReportViewer, Part 2

The ReportViewer control is a powerful tool for integrating reports into Windows and Web form applications. You can make it even more powerful if you're willing to write a few lines of Visual Basic .NET or Visual C# code.
By Brian Larson 

Itanium's Comeback

Despite media rumors, Intel's Itanium is still alive and well. Find out how its high-end power will save it from demise.
By Michael Otey 

The Hidden Costs of Row-Level Versioning

Row-level versioning can stress your tempdb database—but you can mitigate the increased demand by monitoring tempdb usage using SQL Server 2005 tools.
By Kalen Delaney 

Implementing Supertypes and Subtypes

Are you unsure how to use supertypes and subtypes to your advantage? Learn why they are used and how to implement them correctly.
By Michelle A. Poolet 

The Perils of T-SQL Randomization

T-SQL randomization isn't particularly straightforward. But some improvements in SQL Server 2005—the use of TOP with input expressions, the APPLY operator, and the TABLESAMPLE option—pave the way toward more accurate randomization.
By Itzik Ben-Gan 

New Products

By Blake Eno 

Virtual Labs for SQL Server 2005

Using Microsoft's virtual labs, you can get hands-on experience with SQL Server 2005—but which of the 17 SQL Server 2005 virtual labs should you try first? Here's a quick preview of 5 of the most useful.
By Michael Otey 

SQL Health and History Tool

A free Microsoft change-management and trending tool helps you head off potential performance problems and get the most out of your multi–SQL Server environment.
By Kevin Kline 

Hit Software's DBMoto 5.0

Check out DBMoto 5.0 if you're looking for a replication solution that's highly scalable and had been designed to help you move and copy data between heterogeneous database platforms.
By Michael K. Campbell