New to Business Intelligence Development Studio

All replies

• 

  

  2

  Sign in to vote

  Hi Billy,

  If you havn't already; - purchase a copy of the developer's edition to put on your personal laptop; - SQL Server 2008, Developer Edition; -

  http://www.amazon.com/SQL-Server-2008-Developer-Edition/dp/B001B8EZR4/ref=sr_1_1?ie=UTF8&s=software&qid=1277577956&sr=1-1

  Install AdventureWorks 2008R2 RTM; - http://msftdbprodsamples.codeplex.com/releases/view/45907

  A client-side tool is Business Intelligence Develoment Studio (BIDS) as you have already mentioned. If you have already access to a SQL Server 2008 server, I still recommend purchasing the developer's license because having a local server instance is very useful.

  If not, you can load the client tools; - BIDS and SQL Server Managment Studio (SSMS) onto your PC by accessing the DVD which was used to create the SQL Server 2008 server installation. You can install only the client tools on your PC by running the setup.exe program, clicking next until you reach the dialog box with the header "Components to Install", then just check the option "Workstation components, Books Online and development tools."

  I also recommend this book as a source of reference; - MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008-Business Intelligence Development and Maintenance: MCTS Exam 70-448 (Self-Paced Training Kits)

  Please also check a related question(s); -

  http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/4524cc4f-9fdf-4c86-80f7-e1c722f4d813

  http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/405cf183-4d7c-482e-91c8-c57f5d6fcf32

  http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/fb259210-f2ee-4111-91ce-186e37ff64ad

   

  I hope this helps,

  Kind Regards,

  Kieran.

  ---

  If you have found any of my posts helpful then please vote them as helpful. Kieran Wood PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds

  • Proposed as answer by Kieran Patrick Wood Saturday, August 14, 2010 1:18 PM
  • Marked as answer by Tom Li - MSFT Sunday, August 22, 2010 10:58 AM

  Friday, August 13, 2010 5:38 PM
• 

  

  0

  Sign in to vote

  Hi Billy,

  Business Intelligence Development Studio (BIDS) is a feature of SQL Server, which is used to develop SQL Server BI solutions and included in SQL Server 2008 Enterprise/Developer/Standard/Web/Workgroup/Express with Advanced Services editions.

  You can install BIDS feature from any of above mentioned editions by running the setup of the SQL Server 2008 on your development computer. Since BIDS use the same setup process of SQL Server 2008, in order to install BIDS successfully please make sure the system meet the installation requirements of SQL Server 2008. For more information, see http://msdn.microsoft.com/en-us/library/ms143506(SQl.100).aspx.

  If you have more queries, please let me know.

  Thanks,
  Chunsong

  ---

  Please remember to mark the replies as answers if they help and unmark them if they provide no help.
  

  • Marked as answer by Tom Li - MSFT Sunday, August 22, 2010 10:58 AM

  Monday, August 16, 2010 6:30 AM
• 

  

  0

  Sign in to vote

  Check this link: http://blogs.technet.com/b/james/archive/2006/04/06/424394.aspx

  Friday, January 27, 2012 8:36 AM