The Properties window the properties of an object. You use this window to view and change the properties of objects, such as packages, that are open in editors and designers Toolbox Window The Toolbox window always displays the General tab, and may also display tabs such as Control Flow Items, Maintenance Tasks, Data Flow Sources, or Report Items. Some designers and editors do not use items from the Toolbox. In that case the Toolbox contains only the General tab. Designer Window The Designer window is the tool window in you create or modify business intelligence objects. The designer provides both a code view and a design view of an object. When you open an object in a project, the object opens within a specialized designer in this window. For example, if you open a data source view in any of the business intelligence projects, the designer window opens using the Data Source View designer. Working with Solutions and Projects: When you create a new solution, Business Intelligence Development Studio adds a Solution folder to Solution Explorer and creates files that have the extensions .sln and .suo. · The *.sln file contains information about solution configuration and lists the projects in the solution. · The *.suo file contains information your preferences for working with the solution. SSRS Stands for SQL Server Reporting Services SSRS Databases ReportServer • Stores all the reporting services assets Reports Datasources Security Snapshots & Histories Schedules & Subscriptions ReportServerTempDB • Stores temporary Reports” “Intermediate Sizes of the DBs depends on • Number of Reports Execution Properties What is a Report? A report is a combination of kinds of information: Data or information about how to obtain the data (queries) as well as the structure of the data.
The Properties window the properties of an object. You use this window to view and change the properties of objects, such as packages, that are open in editors and designers Toolbox Window The Toolbox window always displays the General tab, and may also display tabs such as Control Flow Items, Maintenance Tasks, Data Flow Sources, or Report Items. Some designers and editors do not use items from the Toolbox. In that case the Toolbox contains only the General tab. Designer Window The Designer window is the tool window in you create or modify business intelligence objects. The designer provides both a code view and a design view of an object. When you open an object in a project, the object opens within a specialized designer in this window. For example, if you open a data source view in any of the business intelligence projects, the designer window opens using the Data Source View designer. Working with Solutions and Projects: When you create a new solution, Business Intelligence Development Studio adds a Solution folder to Solution Explorer and creates files that have the extensions .sln and .suo. · The *.sln file contains information about solution configuration and lists the projects in the solution. · The *.suo file contains information your preferences for working with the solution. SSRS Stands for SQL Server Reporting Services SSRS Databases • ReportServer Stores all the reporting services assets Reports Datasources Security Snapshots & Histories Schedules & Subscriptions • ReportServerTempDB Stores temporary “Intermediate Reports” • Sizes of the DBs depends on Number of Reports Execution Properties What is a Report? A report is a combination of kinds of information: Data or information about how to obtain the data (queries) as well as the structure of the data.
1.%20SSRS.docx