In SQL Server 2005, how many pages are...

You are developing security policy for your SQL...

What does the term ACID refer to?

Strategy, Tactics, and Business Intelligence

There is a lot of talk these days about “business intelligence” (BI for short). Pick up any magazine aimed at business or technology professionals, and you’re sure to read about things like data warehouses, dashboards, cubes, ETL, SCD, and a seemingly endless list of other specialized terms and acronyms. One might be left wondering, is this something to which I should be paying attention?

What is the granularity in seconds of the...

Business Intelligence or Data Warehouse

Is a data warehouse required for business intelligence? Are these synonyms for the same concept? Vincent Rainardi brings us the next part of his data warehousing series that examines these two concepts and how they fit into your data analysis infratructure.

What is a bookmark lookup?

The Service Broker operates on messages in which...

Data Extraction Methods Part 2

The fourth part of a great data warehousing series from Vincent Rainardi. This article continues the look are still other methods of extracting data from the source system along with the advantages and disadvantages of each.

Making Complex Data Simple: Transforming Your Data Transformation

This article examines the problem of complex data in integration projects and presents solutions for handling this data to create seamless integration throughout the enterprise.