powershell

10 Jul 09

26 Jun 09

SSAS: 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

agilebi.com/...-analysis-services-traces.aspx - Preview

POWERSHELL SSAS TRACE LIBRARY

25 Jun 09

SSAS: Powershell -- Multi Developer SQL Strategies

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

agilebi.com/...-with-multiple-developers.aspx - Preview

SSAS: Powershell -- Multi Developer SQL Strategies

12 Dec 08

PDC2008 Professional Developers Conference October 27-30, 2008

www.microsoftpdc.com - Preview

PDC2008 Professional Developers Conference October 27-30 2008 DEV -- C# POWERSHELL

11 Dec 08

POWERSHELL: One PowerShell Script to download them all: PDC2008 Videos, Code and PowerPoint files

29 Apr 08

Running XMLA Queries the Powershell way

geekswithblogs.net/...PowershellAndXmla.aspx - Preview

Running XMLA Queries the Powershell way DEV -- SQL 2K5 POWERSHELL

SSAS: SSIS package to process all dimensions in Analysis Services (SSAS) 2005 DB using CaptureXml (updated) | Vidas Matelis Analysis Services Blog

Microsoft.AnalysisServices.XmlaResultCollection

POWERSHELL / SSAS: Generating XMLA to process cube dimensions in parallel - referencing Objects by name

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") > $null [Microsoft.AnalysisServices.Server]$svr = new-Object([Microsoft.AnalysisServices.Server]) $svr.Connect("Localhost\sql05") $svr.CaptureXml = $true [Microsoft.AnalysisServices.Database] $db = $svr.Databases.FindbyName("Adventure Works DW") $dimAcct = $db.Dimensions.FindByName("Account") $dimCust = $db.Dimensions.FindByName("Customer") $dimAcct.Process() $dimCust.Process() $svr.CaptureLog

22 Apr 08