O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Determining the Optimal Number and Placement of Servers

When you’re planning for new servers, you have many things to consider. These can include the following:

  • Source systems. If your source systems are RDBMSs, such as an earlier version of SQL Server or some other vendor’s RDBMS (Informix, Sybase, and so on), you might want to upgrade source data systems to SQL Server 2008 to take advantage of BI-related and non-BI-related enhancements. For more information about enhancements to the relational engine of SQL Server 2008, go to http://download.microsoft.com/download/C/8/4/C8470F54-D6D2-423D-8E5B-95CA4A90149A/SQLServer2008_OLTP_Datasheet.pdf.

  • Analysis Services. Where will you install this core service for BI? We find that for smaller BI projects, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required