Home Forums Reporting Services Reporting Services Design Question: What is the best practice for reporting on data that spans instances? RE: Design Question: What is the best practice for reporting on data that spans instances?

  • Jack Corbett (2/26/2014)


    You should search for Rodney Landrum DBA Repository as that might be the kind of template you'd want to follow.

    Thanks for the tip. I found some Rodney Landrum links which I am pasting below in case they would be helpful to anyone.

    http://sqlmag.com/sharepoint/readers-and-authors-swap-ideas (which points to the following links)

    http://sqlmag.com/sql-server-integration-services/sql-server-integration-services (goes through the creation of a DBA Repository database, which is what we are attempting to do as well)

    http://sqlmag.com/sql-server-reporting-services/sql-server-reporting-services

    http://sqlmag.com/sql-server-integration-services/use-ssrs-and-ssis-create-dba-repository

    http://sqlmag.com/sql-server/dba-repository-2010

    J