Foreign key constraints are an integral part of SQL Server database design. These are used to maintain integrity among related data in different tables. While implementing update and delete operations on values in the parent table (referenced table with primary key) we have to consider the impact on related values in the child table. SQL Server provides different rules for managing the effect of updates and deletes on child table values. How can these rules be used effectively without threatening the relational integrity?

100% Microsoft?

by Brad McGehee

SQLServerCentral.com

Editorial

This week Brad McGehee asks if your company is a 100% Microsoft software shop or if you are allowed to use third party software with your SQL Server.

The Intelligence Cloud

by Steve Jones

SQLServerCentral.com

Editorial

More cloud talk today as the Air Force is building a new intelligence sharing system in the cloud? Why the cloud? Is the cloud really better?

TSQL Challenge 55 - Multiply two very long decimal strings and return

by Jacob Sebastian

SQLServerCentral.com

T-SQL Challenges

This challenge to multiply two positive integer strings and return their product. The strings can be really long: up to 1024 digits

Performing DBCC Checks Using SQL Virtual Restore

by Additional Articles

SimpleTalk

DBCC CHECKDB

Ever restored a corrupted database from the backup, only to find that the backups are corrupted too - All the backups? Sure it can happen and it isn't nice when it does. To check that a database backup is internally consistent you have to use DBCC CheckDB. On a huge highly-loaded live system? Grant Fritchey has, as usual, a practical solution.

Temporary Indexes

by Steve Jones

SQLServerCentral.com

Editorial

Temporary indexes can speed up processes that run periodically in your applications. This Friday Steve Jones asks how many of you use temporary indexes and how you do so.

SQL Diag Configuration Tool

by Press Release

Microsoft MSDN

SQL Diag

SQL Diag is a very useful diagnostic tool that will help capture performance information from SQL Server. This tool is shipped with the SQL Server product. Howerver there is not an easy way to configure the tool - it requires the hand editing of an XML file, which is tedious and error prone. That is until now!
SQL Diag Configuration Tool (SDCT) is an intuitive, easy to use tool that will read existing sqldiag.xml configuration files, allow you to select your desired options and save those options to a new file.

SSIS Event Handlers Basics

by Additional Articles

SimpleTalk

Integration Services (SSIS)

SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is auditable, reacts appropriately to error conditions, reports progress and allows instrumentation and monitoring your SSIS packages. They are easy to implement, and provide a great deal of flexibility. Rob Sheldon once again provides the easy, clear introduction.