Email Alerts
-
Featured resources
Ask the Expert
-
Permanently prevent query analyzer from accessing particular database
Ask the Expert
-
Step 4: Be careful how you enforce internal referential integrity through triggers
Learn how to properly use triggers to protect SQL Server data integrity rules. Article
-
Step 7: Use a "check-in/check-out" mechanism for contested data
Get help handling contention for updating a particular row in SQL Server. Article
-
Step 5: Use constraints and relationships to keep out bad data
Learn why you must use SQL Server's CHECK constraints to enforce constraints on inserted data. Article
-
Step 1: Back up, optimize and enable safety features
Step 1 of our data integrity guides explains how to develop your data integrity strategy. Article
-
Step 2: Segregate data aggressively into files and filegroups
Find out how data segregation can help you preserve SQL Server data integrity in this step of our step-by-step guide. Article
-
Step 6: Don't expose interfaces that create dynamic SQL to the end user
Be careful not to create poisoned code when using dynamic SQL. Article
-
Visual FoxPro 9.0 more SQL Server friendly
The recent update to the Microsoft development platform -- with new features such as an enhanced report writer -- finds fans in the database application development community. Article
-
How to set up a QA box that closely simulates production
Ask the Expert