Report Server Install Best Practices

I am setting up my first Report server. Should the Data Engine and two databases that are automatically created reside on the Report Server or on another SQL Server machine?

Mongo7305 pointsBadges:

Is an existing BI solution required to use the BI capabilities of SQL Server R2?

Is an existing BI solution required to use the BI capabilities of SQL Server R2?

ITKE1,152,200 pointsBadges:

Managed Self Service Approach to BI

How can the “managed self service’ approach to BI benefit my organization?

ITKE1,152,200 pointsBadges:

Do I need to remove SQL Server 2005 to install SQL Server 2008 R2?

Do I need to do a complete removal of 2005, as tried that on a new Windows Web server 2008, as wanted to put 2008 SQL Server.

ITKE1,152,200 pointsBadges:

What is the process to upgrade a database from SQL Server 2000 to SQL Server 2008 R2?

What is the process to upgrade a database from 2000 to 2008?

ITKE1,152,200 pointsBadges:

SQL Server 2008 R2 provides direct integration with Oracle Database

Does SQL server 2008 provide direct integration with the databases built-in within an oracle DB?

ITKE1,152,200 pointsBadges:

SQL Server 2008 R2 fully supported by Visual Studio Team Database 2008 or 2010?

Is R2 fully supported by Visual Studio Team Database 2008 or 2010?

ITKE1,152,200 pointsBadges:

Can you explain Master Data Services

Can you explain Master Data Services?

ITKE1,152,200 pointsBadges:

What is PowerPivot?

What is PowerPivot?

ITKE1,152,200 pointsBadges:

Help with Data Quality

Data Quality is a big issue in our firm as we have a lot of applications and inputs into our production databases.  Is Microsoft doing anything to help us with data quality, especially on existing data?

ITKE1,152,200 pointsBadges:

What sort of connections are there to SharePoint in SQL Server 2008 R2?

What sort of connections are there to SharePoint?

ITKE1,152,200 pointsBadges:

Hardware requirements for SQL Server 2008 R2

Where can I find hardware requirements, sizing guides for the new release? 

ITKE1,152,200 pointsBadges:

Advantage of SQl Server 2008 R2 vs Oracle

Can you please explain the advantage of SQL Server 2008 R2 vs. Oracle product (elevator pitch)?

ITKE1,152,200 pointsBadges:

Desiging UCP Environments in SQL Server 2008 R2

What considerations should be kept in mind when designing UCP environments? 

ITKE1,152,200 pointsBadges:

Editions of SQL Server

Can you briefly discuss the different editions of the database that are available now?

ITKE1,152,200 pointsBadges:

Visual Studio 2010 to edit DAC Packs in SQL Server 2008 R2

Will I need Visual Studio 2010 to edit DAC Packs?

ITKE1,152,200 pointsBadges:

Impact of Statature with Release of SQL Server

How has the acquisition of Stratature impacted this release of SQL Server?

ITKE1,152,200 pointsBadges:

Data Mining in SQL Server 2008 R2

Are there any investments in Data Mining in SQL Server 2008 R2?

ITKE1,152,200 pointsBadges:

Differences between SQL Server 2005 and SQL Server 2008 R2

Can you explain the key differences between SQL 2005 and the latest 2008?

ITKE1,152,200 pointsBadges:

Database Size on SQL Azure

What’s the max size database we can have on SQL Azure?

ITKE1,152,200 pointsBadges: