2.4. SQL Server Business Intelligence Development Studio
The SQL Server Business Intelligence Development Studio is just an incredibly long-winded name for what amounts to a special version of Visual Studio. Indeed, what this tool looks like when it comes up will vary depending on whether you have Visual Studio 2005 installed on your system or not. If you do, it will mix an array of Visual Studio menus in with your SQL Server Analysis Services-related menus and templates.
Business Intelligence Development Studio is yet another tool that received a complete makeover in SQL Server 2005. Indeed, the Analysis Services tools that were there in SQL Server 2000 have been totally replaced. What exists now is far more of a true development environment rather than the relatively narrow cube builder that we had in SQL Server 2000.
From Business Intelligence Development Studio, we can design Integration Services packages (we'll touch on these next), design reports for reporting services, and, of course, work directly with Analysis Services projects. We will be looking at the various services that Business Intelligence Development Studio supports in separate chapters later in this book.
Get Professional SQL Server™ 2005 Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
