Perform Analysis Services database backups using Powershell

I was recently looking into performing SQL Server Analysis Services database backups using Powershell within an automated task, with the following requirements:  Perform a backup of all databases for running instances of Analysis Services. If the target location does not exist, create the directory. Firstly we need to load the Microsoft SQL Server Analysis Services … More Perform Analysis Services database backups using Powershell

Preparing a virtual machine template with Microsoft SQL Server 2012

A recent requirement was to create a template within VMware to deploy a configured virtual machine with a named Database Engine instance of SQL Server 2012 installed. Previous versions of SQL Server did not allow for a clean sysprep image, in SQL Server 2012 this has changed with the introduction of the concept image preparation … More Preparing a virtual machine template with Microsoft SQL Server 2012