The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Take advantage of six important aspects of database design. You can improve your data's validity by setting up your database and processing environment to enforce validation automatically.
By Michael K. Campbell
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 Otey
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
Our editors share insights from their conversations with Imperva, SPI Dynamics, and Lumigent.
By Blake Eno
Check out new and improved SQL Server-related products.
By Brian Larson
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.
If you need more report functionality than SSRS can offer, Visual Studio 2005's ReportViewer control might be just what you need.
By Kalen Delaney
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 Brian Lawton
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 Itzik Ben-Gan
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 Bill McEvoy
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.
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.
Readers contribute thoughts on storing session state and whether there's a downside to SATA.
By Warren Thornthwaite
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.
advertisement