|
|
||||||||||||||||||||||||||
Windows IT Pro Magazine May 2006
[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 |
|||||||||||