Demo Script

Preparing your SQL Azure Account

Lab version:1.0.0

Last updated:1/12/2019

Contents

Overview

Key Messages

Key Technologies

Time Estimates

Setup and Configuration

Demo Flow

Opening Statement

Step-by-Step Walkthrough

Click-through

Browse Portal

Summary

Overview

This document provides setup documentation, step-by-step instructions, and a written script for showing a demo of SQL Azure. This document can also serve as a tutorial or walkthrough of the technology. In this simple click-through and browser demo, you show the experience of setting up your SQL Azure account for first time usage including creating a server in a specific geo-location in addition to setting the admin username and password. For additional demos of the Windows Azure platform, please visit

Note: In order to run through this demo, you must have a SQL Azure account. To create these accounts, you will first need to sign-up for the invitation code at

Key Messages

In this demo you will see two key things:

  1. Setting up a SQL Azure account is simple.
  2. During the setup process you determine the geo-location of your account and setup a user equivalent to sa.

Key Technologies

This demo uses the following technologies:

  1. SQL Azure

Time Estimates

  • Estimated time for setting up and configuring the demo: 10 min
  • Estimated time to complete the demo: 3 min

Setup and Configuration

The setup and configuration for this demo involves the following tasks:

  • Setup your SQL Azure account
  • Login to SQL Azure portal

In order to run this demo, you need to have a SQL Azure account already configured. For more information on how to purchase an account, visit the SQL Azure Portal at

The last screen of the PPT in this demo has a hyperlink to In order for the demo to flow correctly, make sure you have already logged in to the portal before viewing the PowerPoint or you will be prompted again for credentials.

Demo Flow

The step-by-step guide in this document follows the following demo flow/outline:

Figure 1

Demo Flow

Opening Statement

In this demo, you will see how easy it is to manage your SQL Azure account in addition to creating databases and generating connection strings.

  1. First you will see how to redeam your SQL Azure Invitation Code.
  2. Second you will how to create and geo-locate your Server.
  3. Finally you will see the portal UI for generating connection strings, creating and deleting databases.

Step-by-Step Walkthrough

This demo is very simple and is based mainly on a PowerPoint deck that can be found in the Assets directory of this demo.

  1. Click-through
  2. Browse portal

Click-through

In this first segment, you will click-through a set of screenshots embedded in a PowerPoint deck. Since the Invitation Code redemption process is a one-time event a click-through is the only way to show this.

Action / Script / Screenshot
  1. Open the PowerPoint deck found in the Assets folder of this demo.
/
  • This will be a mix of a PowerPoint click-through and browsing the SQL Azure portion of the SQL Azure portal.
  • Since the Invitation Code redemption process is a one-time event we have to do this through PowerPoint.
/
  1. Advance slide
/
  • When clicking on the link to redeem your invitation code you will be prompted to login with your LiveID.
/
  1. Advance slide
/
  • Enter the code found in your invitation.
/
  1. Advance slide
/
  • Accept the Terms of Use
/
  1. Advance slide
  2. Click on the slide with mouse pointer to be taken to
/
  • Here you will create a Server which can only be done once so make sure to proceed with care.
  • Create an Administrative user who will be equivalent to sa in on-premise SQL Server. Make sure to use a strong password.
  • Select the Location of your SQL Azure Server. This will determine the region where your server is located. Ensure this is the same region as your Windows Azure projects if you want compute and database to be close.
/

Browse Portal

In this segment, you will walk through a few simple features of the SQL Azure section of the portal.

Action / Script / Screenshot
  1. Click on the slide
/
  • Here is a list of SQL Azure projects. Currently you can only have one.
/
  1. Click onSDS-only CTP Project link.
/
  • From this screen, we see the Server Name that was generated for us.
  • We can generate connection strings for the server or for a specific database.
  • We can Create and Drop databases as well.
/
  1. Click Create Database
/
  • Although we can create databases through this portal, we expect most people will create databases through T-SQL.
  • We can select which SQL Azure Database edition (Web or Business) is created during the database provisioning process. This is surfacedboth in the SQL Azure Portal and in the T-SQL Create Database statement.
/
  1. Click Firewall Settings
  2. Click Add Rule
  3. Add a firewall rule for your IP address.
/
  • The new firewall features allows a customer to specify an allow list of IP address that can access their SQL Azure Server. Security is a concern for companies looking at storing data in the cloud and with this new feature; you can rest assured that only hosts you specify will be allowed to connect. Please be aware that your firewall will deny all connections by default, so please configure your allow list so that existing clients can continue to connect.
  • Firewall rules may take up to 5 minutes before they come into effect.
/

Summary

In this demo, you saw how easy it is to redeem SQL Azure Invitation Codes, create a Server and use the portal to create/delete your databases.