Skip to content

Latest commit

 

History

History
76 lines (67 loc) · 4.44 KB

README.md

File metadata and controls

76 lines (67 loc) · 4.44 KB

Web Jobs and Azure SQL Database

This is a hands-on lab for using Web Jobs with an advanced lab for using Azure SQL Database for those that finish early.

This is based on the blog post by Scott Hanselman. See also the Getting Started with the Web Jobs SDK post.

  1. Create a new console application in Visual Studio
  2. Add a reference to System.Drawing 4.0.0.0
  3. Install-Package nquant
  4. Install-Package Microsoft.WindowsAzure.Jobs.Host -pre
  5. Change Program.cs to include this: 
    using Microsoft.WindowsAzure.Jobs;
using nQuant;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            JobHost host = new JobHost();
            host.RunAndBlock();
        }

        public static void SquishNewlyUploadedPNGs(
            [BlobInput("input/{name}")] Stream input,
            [BlobOutput("output/{name}")] Stream output)
        {
            var quantizer = new WuQuantizer();
            using (var bitmap = new Bitmap(input))
            {
                using (var quantized = quantizer.QuantizeImage(bitmap))
                {
                    quantized.Save(output, ImageFormat.Png);
                }
            }

        }
    }
}
  6. Build the solution
  7. Go to bin\Debug and zip up all the files up
  8. Go to the WebJobs tab for a Web Site in the Windows Azure portal
  9. Click New to create a new web job by uploading the zip file Web Job configuration
  10. Create a Windows Azure Storage Account if you haven't already
  11. Construct a connection string for your storage account
    • DefaultEndpointsProtocol=https;AccountName=<storage_account_name>;AccountKey=<storage_account_access_key>
  12. Go to the Configure tab for your Web Site in the Windows Azure portal and add the storage account connection string for the AzureJobsRuntime and AzureJobsData connection strings Connection string configuration
  13. Look at the status of the web job in the WebJobs tab of your Web Site and ensure it's set to Running Web Job status
  14. Look at the logs and dashboard for your Web Job to monitor what happens when it's invoked
  15. Open up the storage account that you are using for the web job inside of Visual Studio View > Server Explorer > Windows Azure > Storage (or any other tool of choice)
  16. Drop in sample.png to the input blob container
  17. Wait for the file to get processed into the output directory
    • It should be smaller and the Web Jobs dashboard and log should show that it successfully processed Web Job success

Advanced: Azure SQL Database

One of the things you need to deal with when using Azure SQL Database is dealing with transient errors - to that end Rob Moore has created some demo code to illustrate the effects of transient errors. This lab involves playing around with that code to see how easy it is to connect to an Azure SQL Database (but keeping in mind the fact you have to use transient fault protection) and if you have the time then to actually exercise the transient errors. The codebase also demonstrates Azure Storage connectivity.

  1. Navigate to the demo site and follow the instructions to exercise the demo
  2. Initially, only deploy the site to one Windows Azure instance and study the code locally to try and understand how it works
  3. If you have time then do the full demo to try and see the transient errors happen (as explained in the demo site)