When asked to prioritize your job duties as a DBA, you may not immediately think to add "ensure data integrity"...
to the top of list -- yet it is critical to the success of your SQL Server.
By definition, data integrity assures that information can only be accessed or modified by those authorized to do so. You may protect the physical environment, restrict access, segregate data, maintain a solid set of backups or any number of other tasks for integrity's sake, but improperly performing such tasks can harm integrity as well. In this fast guide, we offers tip and tricks to ensure and maintain data integrity, with a particular focus on avoiding the "gotchas" that can compromise your data.
| TABLE OF CONTENTS
Ensuring data integrity
Avoiding data integrity gotchas
Maintaining data integrity
Get detailed steps to enforce and ensure SQL Server data integrity in this guide.
A data warehousing initiative shouldn't result in multiple data silos, but too often that's just what happens. One columnist identifies the problem.
How well SQL Server functions over time depends on how you've built your database, where you put your code and how you handle business logic. Get tips for improved scalability.
Find out how to use DTS in SQL Server 2000 to ensure data integrity by importing exporting and transforming data from disparate sources into single or multiple destinations.
Data integrity may be compromised if a single-table restore isn't properly handled. Find out what precautions you must take.
Mixing Unicode's multiple encoding methods can lead to damaged or improperly stored data. Get steps to preserve your Unicode data.
SQL Server 2000's PHYSICAL_ONLY helps you find hardware problems before they result in data loss. Learn how to use this option to maintain data integrity.
You'll want to cleanse data of delimiters for storage -- but beware that removing some delimiters can harm data integrity.
Beware the ramifications of storing XML data in SQL Server 2005 using the new XML data type.
The success of your backup and restore efforts depends more on small mistakes made than on best practices followed. Find out which backup and recovery worst practices to avoid.
Get a list of activities appearing on a typical maintenance plan schedule, and learn how to use DBCC commands and stored procedures associated with each aspect of database maintenance.
Triggers allow you to control how your database responds to INSERTs, DELETEs and UPDATEs, and they can be used to maintain data integrity -- but they may slow or fail to run. Get troubleshooting tips here.
MAX data types add a great element of flexibility to handling large data in SQL Server 2005. Find out how you can benefit.