Microsoft Sql server

Ms Sql server


Huh!! Sql Server is the No 1 Database.Microsoft Sql Server is still continuing to hold it position.According to 2007 database and data access integration and reporting study that 74.7 percent of enterprises are using Sql Server.

For more comments on Ms SQl Server Pleas locate @

http://www.sdtimes.com/content/article.aspx?ArticleID=30932

Internet Information Services

Internet Information Services(IIS) 7.0

Huh! Microsoft has released the latest version of Internet Information Services (IIS) 7.0.This version of IIS has enormous features as compared with the older version of IIS.For more details of latest feature of IIS 7.0, please locate the below url.

http://msdn.microsoft.com/msdnmag/issues/07/03/IIS7/#S1

Welcome to the World of MS SQL Server

Welcome to the world of MS SQL Server

As mentioned in my previous article regarding the MS SQL Server 2008

Data Warehousing: Microsoft Sql Server 2008


the latest MS Sql Server 2008 Community Technology Preview (CTP), the trial version (10 days) can be downloaded from the following link

http://www.microsoft.com/sql/2008/prodinfo/download.mspx

What is SSIS ?

SQL Server Integration Services


Microsoft Sql Server 2005 Integration Services (SSIS), an extensive data integration platform which is used to transfer, transform and merge the information fom various sources and load to multiple systems.SSIS is not an Extraction, Transformation and Loading (ETL) tool but an data integration platform providing a wide range of capabilities.

In the earlier version of MS SQL Server 2005, we had the option of Data Transformation Services(DTS) which is the most important tool for the transformation process.This contains te workflow engine which support all complex logic and that can be used for a variey of database maintainance and also for data transfer operations.

IBM to Acquire Cognos to Accelerate Information on Demand Business Initiative

IBM to Acquire Cognos to Accelerate Information on Demand Business Initiative



The combination of IBM and Cognos will make IBM the premier world class leaders in the Business Intelligence industry.
For information refer @

http://www.cognos.com/news/releases/2007/1112.html?mc=-web_hp

Microsoft SQL Server Reporting Sevices

Microsoft SQL Server Reporting Sevices

Sql Server Reporting Service, a server-based solution enabling the creation, management and delivery for both traditional reports and found to be very interactive.The Microsoft's Business Intelligence framework, Reporting Services, thereby combining the data management capabilities of SQL Server and Microsoft Windows Server. SQL Server Reporting Services supports a wide range of data sources such as OLE DB, Open Data Base Connectivity (ODBC) and various other multiple formats including the web browsers and Microsoft Office System Applications.

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