SQL Server Magazine October 2006
[Focus]
Regardless of the size and speed of your database, if you can’t trust your data, it’s useless. Learn how you can use some basic database best practices to set up your database and processing environment to enforce validation automatically.
By Brian Lawton
[Features]
How do you use SSIS to build an ETL system to populate a data warehouse? Here's your primer on basic package design and construction.
By Joy Mundy , et al.
If you need more report functionality than SSRS can offer, Visual Studio 2005's ReportViewer control might be just what you need.
By Brian Larson
[Editorial]
The release of SQL Server 2005, with its advanced BI functionality, increased SQL Server's market share compared to top competitors, ensuring future support of the product.
By Michael Otey
[Reader to Reader]
If you've ever had users call to tell you that a SQL Server database is slow, you'll likely find sp_Now a handy tool. This stored procedure determines what processes are currently executing and consuming resources on a database server.
By Bill McEvoy
[Inside SQL Server]
The more you know about SQL Server's inner workings, the better-equipped you'll be to troubleshoot problems and administer your databases efficiently.
By Kalen Delaney
[T-SQL Black Belt]
In this follow-up article, SQL Server 2005’s new APPLY operator and ROW_NUMBER function rev up solutions to a classic T-SQL problem.
By Itzik Ben-Gan
[Letters]
Readers contribute thoughts on storing session state and whether there's a downside to SATA.
By Readers , et al.
[New Products]
Check out new and improved SQL Server-related products.
By Blake Eno
[SELECT TOP(X)]
Check out these FAQs about the newest SQL Server database, a small-scale edition for mobile and desktop applications called SQL Server 2005 Everywhere Edition.
By Michael Otey
[From the Casebook of B.I. Powers, Consulting Detective ...]
A mysterious email message leads B.I. Powers to track down codes on National Manufacturing's reports and teach them how to use meaningful names.
By Brian Larson
[Vendor Briefs]
Our editors share insights from their conversations with Imperva, SPI Dynamics, and Lumigent.
By Editors
[Review]
Two data recovery solutions—Lumigent Technologies' Log Explorer and Red Gate Software's SQL Log Rescue—help you to isolate user errors, undo mistakes, and replay subsequent transactions after user accidents, but one costs nearly ten times more.
By Michael K. Campbell
|
