Welcome to Agile BI Community Sign in | Join | Help

May 2009 - Posts

Sunday, May 31, 2009 7:40 PM

Building a SQL Server Analysis Services .ASDatabase file from a Visual Studio SSAS Project

There are several methods available for deploying Analysis Services databases once you’ve build your solution, including direct connections, generating XMLA to deploy, and using the Deployment Wizard with answer files.  Still, building and deploying
Posted by ddarden42 | 1 Comments
Thursday, May 28, 2009 10:13 PM

Using PowerShell to Manipulate SQL Server Analysis Services Traces

I recently started using SSAS Server Traces a lot with SQL Server Analysis Services. This type of trace is basically the same trace you can create with SQL Server Profiler, but it runs without Profiler, uses less resources, and can be persisted across
Posted by ddarden42 | 1 Comments
Monday, May 25, 2009 8:58 PM

SQL Server Analysis Services Projects with Multiple Developers

A topic that often comes up when discussing enterprise level development with SSAS is how to have multiple developers work on the same project at the same time. This issue doesn’t come up for many installations… a lot of teams get away with just having
Posted by ddarden42 | 11 Comments
Tuesday, May 19, 2009 1:28 AM

SQL Database Tuning Advisor Output Renamer

I’ve uploaded the ‘Database Tuning Advisor Output Renamer’ at http://DtaOutputRenamer.codeplex.com/ . OK… so Friday marked the first day I’ve ever gotten sunburned while coding. I had a little bit of free time while at an outdoor event, and whipped up
Posted by ddarden42 | 1 Comments