SQL Server Magazine

		Options
When the Time Is Right: T-SQL or CLR The CLR integration in SQL Server 2005 is perfect for some jobs, but other times you need a different tool. Itzik Ben-Gan explains which scenarios are best for CLR and which are still jobs for T-SQL.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

CLR or Not CLR: Is That the Question?

Some DBAs and developers look at the SQLCLR as a dangerous weapon, but when it’s used wisely, the CLR can greatly improve performance. Here’s how to know when to use the CLR--and when T-SQL is still the best choice.
By Itzik Ben-Gan 

Brush Up on Design Essentials with the SQL Diagrammer

Data modeling lets you optimize database performance, share your schema, and archive and track database changes. But often, this important basic design step is left out. See how SQL Server's in-the-box data-modeling tool can get you started.
By Michelle A. Poolet 

Dimensional Modeling Basics

SQL Server 2005--and especially Analysis Services 2005--embraces industry-standard dimensional modeling like a long-lost friend. Learn how you can build dimensions that realistically represent how your business operates and change with your business.
By Joy Mundy  , et al.

Market Watch: Dual-Core Processors

This up-and-coming technology is one to watch. We analyze its benefits and drawbacks.
By Anne Grubb 

Visual SourceSafe

Microsoft Visual SourceSafe is a great tool to use to centrally manage file version control. It also helps to simplify common tasks such as code reviews, project management, source-code change auditing, and backups.
By Shilpa Shah  , et al.

Merry-Go-Round Scans: A Culprit For Performance Variances?

There's variance in how the Enhanced Read-ahead and Scan option works on the SQL Server 2005 Standard and Enterprise Editions, which can result in performance differences.
By Brian Moran 

Running .NET Applications With the SQLCLR Tool

Find out how to enable the SQLCLR tool and set the appropriate permissions before running .NET applications on your server.
By Brian Moran 

The Challenge of Complexity

Instead of migration, I've decided to cover one of the fastest growing trends in the IT industry: the rising tide of complexity.
By Michael Otey 

What's That User Doing?

Compare the SQL Server 2000's functionality to SQL Server 2005's new options for determining a running process's actions and execution environment.
By Kalen Delaney 

New Products, April 2006

Check out new and improved SQL Server-related products.
By Blake Eno 

Hotfix Corrects SQL Server 7.0 Access Violation

When you transfer a lot of data from a universal database to a computer that's running SQL Server 7.0 with Service Pack 4 (SP4), an access violation might occur.
By Dawn Cyr 

SQL Server 2005 Builds

Is your company running multiple builds and betas of SQL Server 2005? You can't always distinguish between the prerelease versions and the final release—but this list of build numbers can help.
By Michael Otey 

TIP: Executing Statements in a User Database

Microsoft’s Gert Drapers explains how to execute statements in the context of a user database.
By Microsoft's SQL Server Development Team 

Peer-to-Peer: The Next Replication Generation

Peer-to-peer transactional replication is the direct descendant of SQL Server 2000’s bi-directional transactional replication. But this newer version of the technology provides improved availability and scalability as well as simplified setup wizards.
By Matt Nunn 

Vendor Briefs April 2006

Our editors share insights from their conversations with Asigra, MiraLink, SPI Dynamics, and TimeSpring.
By Editors