Business Intelligence

Configuration Files in Reporting Services 2008

SQL Server Reporting Services 2008 has a number of useful configuration files. These are listed here. For clarity, I've missed the '.config' extension from the following files information:Configuration FileFile DescriptionRSReportServerMain configuration file for Report Server web part and Report Manager.RSSrvPolicyPolicy Settings for the Report Server web serviceRsMgrPolicyPolicy Settings for Report Manager applicationRSPreviewPolicyPolicy settings for server… Continue reading Configuration Files in Reporting Services 2008

Business Intelligence

Command Line Utilities in SSRS 2008

Although, in SSRS 2008, the Report Server configuration Manager configures the majority of settings, it is also possible to use command-line utilities. This can be useful for configuring SSRS 2008 scale-out deployments, sharing encryption keys and so on. The three main command lines are listed here, and this is then followed by details of the… Continue reading Command Line Utilities in SSRS 2008

Business Intelligence

Item Level Role permissions in SSRS 2008

SSRS 2008 provides a number of default item-level roles, listed here:Browser May view folders, reports and subscribe to reports.Content Manager May manage content in the Report Server. This includes folders, reports and resources.My Reports May publish reports and linked reports; manage folders, reports and resources in a users 'My Reports' folder.Publisher May publish reports and… Continue reading Item Level Role permissions in SSRS 2008

Business Intelligence

SSIS 2008 Default Role Security Summary Table

I sometimes have trouble remembering the details of the individual default roles in SSIS 2008. These can be found in the msdb database of SQL Server 2008, and are summarised in this table, which will hopefully help a bit:SSIS 2008 msdb Role NameView All PackagesExportExecute All PackagesExecute All in SQL AgentWrite Featuresdb_ssisadminYesYesYesYesDelete/Change all packagesImport Packagesdb_ssisoperatorYesYesYesYesNonedb_ssisltduserOwn… Continue reading SSIS 2008 Default Role Security Summary Table

Business Intelligence

Improving Data Flow Performance in SSIS 2008

This information on improving Data Flow originally came from the Microsoft site, but it is intended here to distill the main points to make the Data Flow review more easy to conduct. There are two main ways of improving performance in Data Flows; one is amending the Data Flow property itself, and the other is… Continue reading Improving Data Flow Performance in SSIS 2008

Business Intelligence

A Table Summary of Key SSIS 2008 Data Transformations

Data Transformations change data between data sources input and data destination output. In SSIS 2008, there are quite a few to choose from, so the choice of transformation is not always immediately clear. Further, the presence or absence of an error output may affect the choice of transformation. Here, some of the key transformations are… Continue reading A Table Summary of Key SSIS 2008 Data Transformations