Introduction to Sql Server 2005 and Its Various Features

INTRODUCTION

Organizations today face numerous data challenges; for example, the need for faster and more data-driven decisions, the need to increase the productivity and flexibility of development staff, and pressure to reduce overall Information Technology budgets while at the same time scaling the infrastructure to meet ever-increasing demands.

Microsoft SQL Server 2005 is a next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications, while making them easier to build, deploy, and manage.

Business people are often faced with the challenge of identifying patterns, trends, rules and relationships from volumes of information too large to be processed by human analysis alone. Business Intelligence (BI) is an approach to turn these large volumes of data into insight and action. Microsoft SQL server 2005 features an enhanced Business Intelligence toolkit designed to help companies use data more effectively and make better decisions. In this report, I will examine the components of Microsoft BI package in SQL Server2005 and discuss some of the problems you can solve with these tools.

DATA INTEGRATION

Data integration involves combining data residing in different sources and providing users with a uniformed view of these data. This process becomes significant in a variety of situations both commercial and scientific. Data integration appears with increasing frequency as the volume and the need to share existing data explodes. It has become the focus of extensive theoretical work, and numerous open problems remain unsolved. In management circles, people frequently refer to data integration as Enterprise Information Integration.

Data Integration forms the solid data foundation needed to support any enterprise information needs. It provides capabilities for enterprise data access and processing across systems and platforms; integrated data quality, which is...