3 Replies Latest reply on Mar 8, 2010 5:44 AM by njoylif

    Need advice from SQL guru's

    neilmborilla

      Hi,

      Need your recommedations on what module of Microsoft SQL 2005 training would I take inorder for me to understand and manage effectively Orion and its modules?

      Here are the training module

      • Writing Queries Using Microsoft® SQL Server™ 2005 Transact-SQL
      • Maintaining a Microsoft® SQL Server™ 2005 Database
      • Implementing a Microsoft® SQL Server™ 2005 Database
      • Tuning and Optimizing Queries Using Microsoft® SQL Server™ 2005
      • Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
      • Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
      • Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
      • Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005
      • Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
      • Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
      • Updating Your Microsoft SQL Server 2005 Skills to SQL Server 2008 

      Highly appreciate any response

        • Re: Need advice from SQL guru's
          KenKasmar

          If you have little/no experience running MS SQL servers and you are going to be the one responsible for its care and feeding (a good base level of understanding is better than looking at it as a black box/magic):

          • Maintaining a Microsoft® SQL Server™ 2005 Database
          • Implementing a Microsoft® SQL Server™ 2005 Database

          If you're implementing APM and will need to write/support SQL queries for APM components (and/or are using MS SQL Reporting Services):

          • Writing Queries Using Microsoft® SQL Server™ 2005 Transact-SQL
          • Tuning and Optimizing Queries Using Microsoft® SQL Server™ 2005

          If you are planning on augmenting Orion graphs and reports with MS SQL Reporting Services:

          • Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

          Maybe if/when you plan on upgrading the database that you're running Orion on from MS SQL 2005 --> MS SQL 2008

          • Updating Your Microsoft SQL Server 2005 Skills to SQL Server 2008