Welcome to Salvo(z)

Yesterday, October 9th marked my one year anniversary for flying, and it just so happened that I got to go up flying, although I didn’t realize the significance of the day at the time. In the last year I have obtained my Private Pilot’s license and logged 68.9 hours of total flight time, including 34.8 hours of Pilot in Command (PIC) and 21.6 hours of Cross Country.

With the advances coming in the Visual Studio 2011 tooling around Intellitrace, we decided it was time to start publishing symbols as part of our automated build process. A symbol server is nothing more then a windows share that contains a folder called 000Admin and folders for your symbols. The folders are all created for you once you get the publishing enabled.

Several options are available to deploy SSAS objects, two common options are deploying directly from BIDS and using the Deployment Wizard.  Both options are useful in different deployment scenarios. 

To view the MDX code for a dimension or cube in Business Intelligence Development Studio (BIDS):

The steps to create an XMLA script to process a SQL Server Analysis Services (SSAS) database within SQL Server Management Studio (SSMS) are listed below.