Friday, May 12, 2006

SQL 2005 - Overview

SQL 2005 Management Studio
'Management Studio' is the primary interface for managing SQL 2005 servers and is backwards compatible with older servers.
It acts as the replacement for the main SQL 2000 tools, namely 'Enterprise Manager' , 'Query Analyser' and 'Analysis Manager'.
Management Studio Overview
SSIS - Sql Server Integration Services
In Sql Server 2005, The DTS (Data Transformation Services) functionality has been replaced with SSIS - Sql Server Integration Services.
SSIS is an installable component and provides powerful ETL (extraction, transformation & loading) capability.
SSIS supports automation in the same was that DTS packages could be executed and monitored from within other languages.
To design 'Integration Services' projects you use the Business Intelligence Studio Interface (also used for Analysis Services & Reporting Services components). If you already have Visual Studio 2005 installed, SQL 2005 projects fall within the 'Business Intelligence Projects' project type.
To execute 'Integration Services' projects you use 'SQL Server Management Studio'.
Integration Services Resources
Analysis Services 2005
Analysis Services was present on Sql Server 2000.
Like its predecessor, Analysis Services 2005 allows you to create and manage OLAP (Online Analytical Processing) cubes.
Unlike its predecessor, Analysis Services 2005 makes the task a lot easier by combining old Enterprise Manager, Query Analyser and DTS functionality.
'Analysis Services' projects are designed within the Business Intelligence Studio Interface (also used for Integration Services & Reporting Services components). If you already have Visual Studio 2005 installed, SQL 2005 projects fall within the 'Business Intelligence Projects' project type.
Analysis Services Resources
SSRS - Sql Server Reporting Services
Originally an add-on to SQL 2000, Sql Server Reporting Services is included in SQL 2005 for free.
It consists of 2 components, 'Report Designer' and 'Report Builder'
Report Designer features a 'drag and drop' interface and will be familiar to developers who have used Crystal Reports or Access.
Report Builder is an adhoc reporting tool which allows users to specify
A unique feature of SSRS (at this time) is that it allows users to subscribe to reports and features the functionality to have these reports emailed out periodically. Licencing for SSRS is free, which should accelerate its take up in the market place.
Reporting Services Resources

No comments: