Microsoft SQL Server 2005

Introduction to Microsoft SQL Server 2005

Microsoft SQL Server 2005, the powerful tool that enables to implement data management and Business Intelligence Projects.This includes numerous data management and various analysis technologies.The important aspect to be focused are as follows

• Database Engine -- This is the core service for processing, storing and securing data providing controlled access and rapid transaction processing meeting most of the requirements within the enterprise

• Analysis Services -- This delivers Online Analytical Processing (OLAP) and data mining functionality for Business Intelligence applications

• Integration Services -- Provides a platform for building high performance for data integration solutions providing Extract, Transform and Load (ETL) processing for Data Warehousing

• Replication -- A technology providing copying and distributing data and other database objects from one database to another database for maintaining the consistency and distributing data to different locations either to remote or to mobile users through LAN, WAN and dial-up-connections, etc

• Reporting Services -- Delivers enterprise, web enabled reporting functionality that enables to create reports from different data sources.

• Notificaiton Services -- Provides an environment for developing and deploying applications that helps the user to generate notification services by sending messages
  

• Service Broker -- Helps the developers to build scalable and secure database applications thereby providing a message base communication platform enabling the funtionality of the independent application components as a whole

• Full-Text Search -- Contains the functionality that can be utilised for issuing full- text queries against the plain character-based data in Sql Server tables