Azure Data Factory: SSIS in the Cloud

Today’s landscape for data warehousing is a rapidly evolving space and most of that evolution is happening in the cloud. The cloud has long offered ways to scale analytic workloads for data warehousing with services like Azure SQL Data Warehouse. However, this only solves one part of the data warehousing workload and as the complexity... » read more

Azure Storage SDK

Visual Studio Nuget Manager PM>Install-Package WindowsAzure.Storage Samples: https://azure.microsoft.com/en-us/resources/samples/storage-blobs-dotnet-webapp/

Azure Storage Pricing

https://azure.microsoft.com/en-us/pricing/details/storage/ Blob storage is much less than file storage. Block Blobs Scalable object storage for documents, videos, pictures, and unstructured text or binary data. Choose from Hot, Cool, or Archive tiers. Prices for locally redundant storage (LRS) Archive Block Blob start from:$0.001/GB per month See Pricing Azure Data Lake Storage Combines the power of a... » read more

Add More Disk Space to VM

Expanding disk space is a common task for a Virtual Machine. This article describes the process of expanding an existing Azure Virtual Machines Disk. Please note prior to the steps described in this guide, all processes should be shutdown as the the Virtual Machine will need to be stopped and Deallocated.  Azure Portal 1. Using... » read more

Azure WebJobs

You can schedule the execution of Windows application using Azure WebJobs. Steps Copy .exe and supporting files to a directory. Zip up the directory. Go to Azure Portal -> App Services -> UserApp01 -> WebJobs Add Name NameOfYourJob File Upload Zipped up file Type Triggered Scale Single Instance Triggered CRON Expression Expression Frequency 0 0... » read more

Properly Shutdown Azure VM to Save Money

There are 2 ways to shutdown an Azure VM, and they are certainly not equal! One way you will still get charged for the compute resources, and the other will free you from paying for the compute resources and help you reduce overall cost. The first method to shutdown an Azure VM, that sounds logical... » read more

Using AZCopy to Transfer Azure Blob Data

AzCopy is a command-line utility designed for copying data to/from Microsoft Azure Blob, File, and Table storage, using simple commands designed for optimal performance. You can copy data between a file system and a storage account, or between storage accounts. Download all blobs in a container AzCopy /Source:https://myaccount.blob.core.windows.net/mycontainer /Dest:C:\myfolder /SourceKey:key /S Download a file Download... » read more

Mapping Azure Storage File to Windows

Once you have created a “Azure Storage File” folder, you can map it to a drive on your Windows, Linux, or MaxOS computer. Windows Example: 1. Go to the following to get the command line… Azure Portal -> Storage accounts -> File service -> Files > Connect 2. Run the following in command prompt… net... » read more