During a presentation of mine, there was a discussion going on, about what partitioning strategy to use when partitioning cubes. Most frequently it seems people are partitioning by some form of period, e.g. by Years, Months or Weeks. Rationally it may seem like a good idea, at the time. But wouldn’t it be a more fact based approach […]
Tag: Powershell
Using PowerShell to get current Data/Log/Temp and Backup Directories from SSAS
In a blog post from October 2015 I ranted about not being able to get the Data, Log, Temp and Backup directories from the AMO API. Back then, the I was tasked with mapping all of the possible locations for SSAS related files on a number of servers. Obviously, a single attribute per location wouldn’t cut […]
Using PowerShell to Discover Temp/Log/Backup and Data Directories of SSAS
Objective: Locate all folders related to SQL Server Analysis Services (SSAS) on disclosed servers. During a massive cleanup on some of our environments, I was asked to point out all the possible locations of SSAS related files on a list of 10+ servers. The main reason for this not being a trivial task done with blindfold is […]
Extracting SSAS Database(s) XMLA w/ PowerShell
For some time, we have been trying to get Informatica’s Metadata Manager to extract information from our SSIS, SSRS and SSAS instances in production. However, we were facing issues with credentials and service account clashes that lead us to just extract the Metadata and deploy it on a server where we had full control. The […]
Did someone restart the server over night?
Sometimes, when you are running lenghty integration jobs over night, you get in the office the next morning, and may be surprised that nothing has completed. And actually nothing is running anymore. Today was such a Day for me. Last night I started the execution of a package via remote desktop and DTSExec Util. This morning, […]