SSRS Best Practice documentation
Posted on 2010-11-17
We have recently split out some of the people in our reporting department and have to do some documentaion. In our DW group, amonng other things, we control the reporting servers and all encompassing administration. In several of departments (ie. Finance, HR, etc.) they each are now assigned a report developer that will be considered the subject matter expert in that area. These individuals jobs are to work within their respective departments and either create a report, or have the DW group create it if it's a bit more complex. The developers have limited permissions and will no longer be able to create objects on the servers.
Now to the question ... One of the first items on the adjenda is to create a Best Practice doc on the seperation of responsibility between the DW team and the developers (ie. Admins create objects, developer use embedded SQL, etc.). In your travels over the internet, have you seen any documentation that others have created that would relate to this.
I hate having to create it from scratch and have started that way, but as always, there will always be things left out that hopefully someone else has thought of and posted.