![sql server management studio icon sql server management studio icon](https://dataedo.com/asset/img/blog/ssms_descriptions_table_properties.png)
![sql server management studio icon sql server management studio icon](https://blogs.sap.com/wp-content/uploads/2019/11/123-7.png)
When you install SSAS, several tools are installed with the SSAS engine and data storage mechanisms. SQL Server 2008 does not install SSAS by default. We share this information so that you can choose the tools that best fit your style, background, and expectations. Before we list our inventory, we’ll talk a bit about the target audience-that is, who Microsoft thinks will use these tools. We mention these because we’ve found them to be useful for production work.
#SQL SERVER MANAGEMENT STUDIO ICON FOR FREE#
Later in this chapter, we’ll look at useful utilities and other tools you can get for free or at low cost that are not included with SQL Server 2008. That is, we’ll first list all the tools that are part of SQL Server 2008. We’ll begin this discussion of the tools you’ll use to design, create, populate, secure, and manage OLAP cubes by taking an inventory. Core Tools in SQL Server Analysis Services If you’re wondering when we’re going to get around to discussing BIDS, we’ll start that in Chapter 7. We aim to provide valuable information in this chapter for all SSAS developers-from those of you who are new to the tools to those who have some experience. After reading this chapter, you’ll be an expert in not only SQL Server Profiler but also SQL Server Management Studio (SSMS) and other tools that will make your work in SSAS very productive. In this chapter, we’ll explore the ins and outs of some tools you’ll use when working with Microsoft SQL Server Analysis Services (SSAS) objects. Before you start, though, we have one more chapter’s worth of information. By now, we’re sure you’re quite ready to roll up your sleeves and get to work in the Business Intelligence Development Studio (BIDS) interface.
![sql server management studio icon sql server management studio icon](https://www.esoftner.com/wp-content/uploads/2019/12/SQL-Server-Management-Studio-Logo.png)
We covered quite a bit of ground in the preceding five chapters-everything from the key concepts of business intelligence to concepts, languages, processes, and modeling methodologies.