SQL Server Magazine

		Options
Office 2003: Bring the Power of SQL Server to Your Desktop Microsoft Office 2003's built-in tools let you incorporate and use data from your SQL Server database. From customizing data entries in Access to summarizing information in Word, Michael Otey shows how to integrate the two applications.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Integrating SQL Server & Office 2003

All the major Microsoft Office 2003 applications include tools that let you incorporate and use data from a SQL Server database. These instructions for importing data into Word, Access, and Excel will get you started.
By Michael Otey 

Neverfail

Definitely worth a look, Neverfail for SQL Server might be the high availability solution you've been seeking.
By Michael Otey 

Shrink-Wrapped DBAs

Check out this comparative review of two hefty database-adminstration products, in which we examine how well Embarcadero Technologies' DBArtisan and Quest Software's Quest Central for SQL Server provide value to both experienced and less-skilled DBAs.
By Michael K. Campbell 

SQL Injection: The Hacker’s Gold Mine

Learn what SQL injection is, how it happens, and how to protect your organization from it.
By Dennis Hurst 

Define Attribute Relationships for Better Performance

Here's a tip about defining relationships between key and non-key attributes in your dimensions.
By Douglas McDowell 

Tip: Check for Fragmentation

Check for fragmentation in database files on the disk array. It could be causing some of your performance problems.
By Brian Moran 

Special Snapshots

The database snapshot feature in SQL Server 2005 lets you query your databases and run system health reports without blocking end users.
By Kalen Delaney 

Designing for Performance: NULL or NOT NULL?

The useful NULL condition lets you represent unknown values in a database, but you might worry about its effect on database performance. Never fear: You can use NULL sensibly.
By Michelle A. Poolet 

Custom Aggregations: The Pivoting Technique

In this second part of a four-part series about custom aggregations, we look at a class of solutions that relies on pivoting techniques.
By Itzik Ben-Gan 

New Products, May 2006

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