Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


Windows IT Pro Magazine May 2006

  Current Issue: Windows IT Pro 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 | Product Reviews | Code Library


[Focus]

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.
 — Michael Otey


[Features]
Neverfail
Definitely worth a look, Neverfail for SQL Server might be the high availability solution you've been seeking.
 — 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.
 — 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.
 — Dennis Hurst


[SQL Server Savvy]

Define Attribute Relationships for Better Performance
Here's a tip about defining relationships between key and non-key attributes in your dimensions.
 — 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.
 — Brian Moran


[Inside SQL Server]

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


[Solutions by Design]

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.
 — Michelle A. Poolet


[T-SQL Black Belt]

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.
 — Itzik Ben-Gan


[New Products]
New Products, May 2006
Check out new and improved SQL Server–related products.
 — Blake Eno

Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2009 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing