Sql Server

Microsoft SQL Server Business Intelligence

SQL Server 2005/2008 BI tools

Microsoft delivers a full BI solution with the SQL Server datatbase engine. This includes:

  • SQL Server Database engine
  • SQL Server Analysis services (SSAS) - multidimensional analysis tool
  • SQL Server Reporting services (SSRS) - reporting framework
  • SQL Server Integration services (SSIS) - built-in ETL tool

    Microsoft SQL Server is shipped with the following environments for designing and managing business intelligence applications:
  • SQL Server Management Studio - an application used for managing databases and data warehouse which can be used for executing deployed SSIS packages.
  • Business Intelligence Development Studio is a powerful design environment for developers which helps in the development of SSAS cubes, SSRS reports and SSIS packages.
  • SQL Server Surface Area Configuration - connectivity configuration tool
  • SQL Server Configuration Manager
  • SQL Server Profiler - monitoring tool
  • Database Engine Tuning Advisor - a tool for optimizing database performance

    SQL Server resources

    MSSQL Server 2005 tutorial
    MSSQL Server 2005 tutorialThe Microsoft SQL Server 2005 tutorial provides lessons which help learn basic concepts of MSSQL Server database architecture. The tutorial provides 16 lessons which cover such...
    SQL Down Under
    SQL Down UnderSQL Down Under is a podcast (audio show) for MS SQL Server professionals. In each show, Greg Low interviews a well-known identity from the Microsoft SQL Server community. Each...
    Integration solutions - XML and Dynamics GP SSIS Toolkit
    Integration solutions - XML and Dynamics GP SSIS ToolkitVendor that provides several addon SSIS components for taking any data source and converting it to XML. Additionally there are components to send business data such as sales...
    MS SQL Server free download
    MS SQL Server free downloadThe Microsoft SQL server free trial download site provides the following products for evaluation: SQL Server 2005 Trial Software (download or order a DVD) Download a...
    SQL Server 2005 Indexed Views
    SQL Server 2005 Indexed ViewsThis tutorial describes how to use indexed views capability of Microsoft SQL Server Enterprise Edition. Indexed views are explained in detail and the document shows specific...
    MS SQL Server Reporting services guide
    MS SQL Server Reporting services guideA step by step technical tutorial with screenshots on how to create BI reports with Microsoft SQL server Reporting Services. The guide describes how to install Reporting Services,...