Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » Automation Tools   (RSS)

SQL Server Analysis Services ‘Project Helper’

A little while back I spent an afternoon prototyping some functionality for Analysis Services.  I’ve been working a bit on improving the collaborative development story around SSAS, and I was after Building a SQL Server Analysis Services .ASDatabase

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

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

SQL Load Generator Tool

A few weeks ago I spoke at PASS on using the Resource Governor in SQL Server 2008. For my demo, I created a little application that could fire off multiple queries against SQL Server to simulate different users/applications. This tool… gasp… creates a

Testing and Tuning an Internet Facing PerformancePoint M&A Dashboard

I've spent the past 15 months, off and on, working as the technical lead on a performance management project using PerformancePoint Server. The project was to create a SharePoint Portal where users could view the performance of a school system. The portal