This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Need advice from SQL guru's

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 MicrosoftRegistered SQL ServerTm 2005 Transact-SQL
  • Maintaining a MicrosoftRegistered SQL ServerTm 2005 Database
  • Implementing a MicrosoftRegistered SQL ServerTm 2005 Database
  • Tuning and Optimizing Queries Using MicrosoftRegistered SQL ServerTm 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

  • 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 MicrosoftRegistered SQL ServerTm 2005 Database
    • Implementing a MicrosoftRegistered SQL ServerTm 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 MicrosoftRegistered SQL ServerTm 2005 Transact-SQL
    • Tuning and Optimizing Queries Using MicrosoftRegistered SQL ServerTm 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 
  • Makes sense. But it appears that I need to take all of the module :(

  • like mentioned before, depends on what you are tasked with/trying to accomplish as well as what your background is...

    if you've had prior programming and underestand SQL basic concepts you'd probably be bests served by taking the "writing queries using T-SQL"

    good luck