How to bulk copy Azure ML Experiments from a Workspace to another one or do a Backup of them in Physical Files

How to bulk copy Azure ML Experiments from a Workspace to another one or do a Backup of them in Physical Files

Hi all,

today I want to tackle the issue of bulk copying more than one Azure ML experiment at once between different workspaces.

May be you already know that you can partially solve this task by copying an experiment one at a time. But you have to access to both the workspaces with your user. If not, you can simply share a workspace in this way:

https://docs.microsoft.com/en-us/azure/machine-learning/machine-learning-create-workspace

Once you can see both the workspaces in your Azure Machine Learning Studio, you can simply select an experiment and than “Copy to workspace”:

AzureML_Copy_001

and than you can choose the destination workspace:

AzureML_Copy_002

A you can imagine… you can’t simply select more than one experiment and than copy all them:

AzureML_Copy_000

Now suppose you have dozens of experiments and simply you don’t want to waste your time coping them all manually, or moreover you can’t have access to a shared workspace for security reasons. Is there a way to bulk copy your experiments? I’ll show you how to do that using few rows of PowerShell.

(more…)

Delete Web Parts in SharePoint 2010 and 2013 with Windows PowerShell

Recently, I have had the need to remove all the web parts of the welcome page of a large number of sites. The number of sites was so big that the option of doing it manually was out. It is in these cases where we can always rely on Windows PowerShell, because the time invested in developing a script is profitable, plus we are learning along the way.

(more…)

Powershell for the DBA: Cleaning SQL Server backup files

Powershell for the DBA: Cleaning SQL Server backup files

One of the most important tasks for a database administrator is to backup all the databases for security reasons. As a Database administrator we need to make sure that in case of a disaster we will be able to recover our data from any point of time, that’s one of the reasons why every Database server should have a Backup maintenance plan. A common practice when implementing this kind of plans is to perform a backup into the server and then move the backup files to a storage server or copy the files in a tape. Once the backups have been moved or copied to the tape we need to purge the backup files that we still have in our server. It doesn’t make sense to keep all the backup files into the server when we already have moved those files to a safer place. So depending on the maintenance plan and business requirements we will want to maintain more or less historical backup files in our servers. In this post we will see how to do it easily with PowerShell. (more…)

Checking existing files with Powershell and SQL Server Agent

Checking existing files with Powershell and SQL Server Agent

Sometimes we need to check for some requirements before running a job. For instance, let’s say that we want to check that a file exists before running a job that tries to restore a database. Before running the job we want to make sure that a file named “testdb.bak” exists, otherwise we will have an error running the t-sql command. In order to check whether the file exists or not we have several options but in this post we will focus on Powershell solutions, in fact we have two ways to face it: (more…)