Creating an Azure Blob Storage Account.

Azure Blob storage accounts can be used to store just about anything, Files, Photos, Virtual Machines etc. To create an Azure Storage Account login to your Azure Subscription and select Storage Click on new in the lower left corner of the screen. Select Storage and Quick Create You will need to select a name for…


Easily Backup SQL Databases to Azure

Microsoft has released a tool that will easily backup SQL Databases to Azure by simply installing a tool on the fileserver where you store your backups. The tool is called the Microsoft SQL Server Backup to Microsoft Azure Tool. You install the tool on a Server where you store database backups and you point the…

2

Getting Started with Azure Automation Services

Azure Automation Services allows you to automate tasks you would do in Azure.  You could write Power Shell scripts to run on premises and connect to Azure, but Automation services hosts those scripts in Azure and you can schedule them to run on a regular basis all in Azure. There no dependencies on a machine…


MAP 9.2 Hangs while configuring Host – Work Around

MAP 9.2 will hang when trying to configure Host information for a Server Consolidation Analysis. I have come up with a work around for this problem, by modifying one of the Sample hosts to contain host information you choose. I have reported this problem to the MAP product group and hopefully it will be resolved…


How to use the MAP tool to perform a Server Consolidation Analysis

The MAP tool does a very good job of Inventorying and assessing environments.  MAP also does a great job at collect performance data on servers and make consolidation recommendations. Step 1. Choose the Machines to collect performance data and begin the data collection In the MAP tool select a database and go to the Server…


I have just run the MAP tool to inventory SQL and the report shows some SQL Servers with Unknown Edition

You have just inventoried your SQL Server Environment with the MAP Tool  http://blogs.msdn.com/b/markm/archive/2015/02/17/inventorying-sql-servers-with-the-microsoft-assessment-and-planning-toolkit-map.aspx and the MAP tool reports several SQL Servers have an “Unknown” edition. The MAP tool uses WMI to collect the information about SQL and there are times especially on older Operating Systems when WMI does not return the SQL Server Edition. You could manually…


Inventorying SQL Servers with the Microsoft Assessment and Planning Toolkit (MAP)

How many SQL Servers do you have in your environment?  Do you know? Do you really know?  I recently had a customer ask me if there isa way to programmatically find SQL Servers in their environment – even the onesthey don’t know about. This customer had a catastrophic failure of a SQL serverinstalled by a department…


How to connect to your Azure Account using a Management Certificate in PowerShell

In my last blog post http://blogs.msdn.com/b/markm/archive/2014/12/15/getting-started-using-powershell-for-azure.aspx I showed you how to connect to Azure using the add-azureaccount command which brought up an interactive sign in screen. In this blog post I will show you how to connect to azure using a management certificate allowing you to execute your PowerShell jobs with no user dialog. The first…

1

Getting Started using PowerShell for Azure

You have set up your Azure Subscription, you have created a few Virtual Machines or SQL Databases and now you would like to start managing your resources using PowerShell This Blog Post will get you started by showing you how to download the Azure cmdlets and get connected to your azure account. Downloading and installing…

2