With the release of SQL Server 2008, Microsoft included Change Data Capture (CDC) functionality for the first time. This highly anticipated feature provides administrators with the ability to perform detailed auditing of database changes.

Read the full story: Change Data Capture in Microsoft SQL Server

In a recent forum message, Kulashnikov24 wrote:

"I am creating a database for my contacts in which I intend to store their visiting details with date and time and also want include an option in the form to check the history for their previous visits.

Is this possible?"

Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!

Foreign key constraints allow you to create relationships between data elements stored in multiple database tables. In addition to facilitating cross-table database queries (called JOINs), these relationships also ensure that the referential integrity of the database is preserved when information is added, removed or modified.

Read the full story: Foreign Keys in SQL Server

In a recent forum message, Maru314 wrote:

"I recently had to normalize the attached table for my final exam of my database course. I got really turned around because all of our other examples, we had composite primary keys that would be used to uniquely identify everything that was on the normalized form. Yet with this example, I really only need to use PropertyID, Listing Agent or the Office Phone to uniquely select anything on this table. So how do I go about getting this to the third normal form?"

Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!