SQL Server Magazine

		Options
SQL Server 2005's Powerful "Code Words:" CLR and SMO SQL Server 2005's CLR integration is capturing the imaginations of developers and rewritten features such as SMO are replacing familiar tools. Check out the backup and restore buyer's guide, learn about time-recording schemes, and more!		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Easy Coding with SMO

SMO, the new programming access layer in SQL Server 2005, lets you quickly and easily develop applications while reducing coding errors and increasing the likelihood that your solution will work the first time.
By John Paul Cook 

Making the Most of the CLR

The integration of the common language runtime (CLR) in SQL Server 2005 opens up so many new possibilities that a developer might not know where to start. Here are three ways you can start taking advantage of SQL Server 2005's enhancements.
By Vinod Kumar 

Buyer's Guide: Backup and Restore Software

Backup and recovery software offers fabulous new features to help you work safer and faster; but which software is best for you? Use this handy guide to narrow down your choices.
By Morris Lewis 

Rev Up Performance with Custom Connectors

SQL Server 2005 Integration Services lets you create custom source components that improve performance and solve uncommon ETL problems. Walk through the steps to create your own custom connector and see how easy it is.
By Douglas McDowell  , et al.

SQL Server's Rounding Secrets

Find out how SQL Server calculates the result precision and scale for various operations.
By Brian Moran 

The High Availability Puzzle

Creating a highly available environment requires more than just technology. Make sure you have all the pieces before it's too late.
By Michael Otey 

10 Things to Love About SQL Server 2005

Whet your appetite with this sneak peek at the top new and enhanced features of SQL Server 2005.
By Kalen Delaney 

Time-Recording Schemes

A walk-through of a common data-modeling problem shows how to sift through many potentially workable solutions to find the one that is best for the company.
By Michelle A. Poolet 

Assigning Row Numbers for Non-Unique Rows

Assigning row numbers has many practical applications, but what if your table has non-unique rows? You don't have to give up on the idea, but you do need to flex your logic muscles a bit.
By Itzik Ben-Gan 

New Products, May 2005

Check out new and improved SQL Server-related products.
By Dawn Cyr 

SQL Server 2005 Editions

Microsoft has announced the four SQL Server 2005 editions, their pricing plans, and three licensing options.
By Michael Otey 

Seeing the CLR's Potential

The SQL Server CLR draws strong reactions from all camps. If you know how to use it judiciously, you'll see great rewards.
By Matt Nunn 

Preventing Runaway Connection Growth

Microsoft's Patrick Conlan describes how to keep your connection pool size and number of connections from runaway growth.
By Microsoft's SQL Server Development Team