concept power in category sql

appears as: The power, power, power
SQL Server MVP Deep Dives Vol. 2

This is an excerpt from Manning's book SQL Server MVP Deep Dives Vol. 2.

Primary keys are designated on a column in a table to define the rows unique to the table. A primary key can consist of multiple columns or a single column. The power of data referential integrity lies in the ability to show a relation between tables by using foreign keys based on the primary key values. For example, an address table may contain addresses and may have a primary key on it to distinguish unique addresses, but the referential integrity lies in the relationship of a foreign key to a customer table. The relationship can require the database to mandate that a customer have at least one address. The biggest mistake made when looking at primary keys and foreign keys in a database is not using them.

By now you can see how easy it is to tap the power of SSAS to create an interactive SSRS report, without having to know a great deal about SSAS and MDX.