So You Want An Azure SQL Database

Review MVA Learning Tutorial: Querying With Transact-SQL

Objective

  • Create Azure SQL DB and populate with Adverture Works Sample Data
  • Access SQL DB via local SQL Server Management Studio tools
    OR
  • Access SQL DB via Visual Studio

Steps

  • Login to the new portal: https://Portal.Azure.com
  • Select + and Data + Storage
  • Select SQL Database
  • For the ‘Blank Database’, select Adventure Works Sample DB
  • After DB created …
  • within Tools, select Open Visual Studio
  • configure Firewall to allow connection with local machine and other machines as needed

using Visual Studio …

  • select Open Visual Studio
  • login to SQL DB; enter Database Name and server credentials

using SQL Server 2014 Express Management Console to query the DB separately…

  • navigate to https://www.microsoft.com/sqlserver/
  • select top navigation of Products > SQL Server > SQL Server Editions
  • select top navigation of Express
    … review the version information available on the page
    … as we already have a SQL DB in Azure, we simply need the SQL Server Management Studio version
    … download SQL Server 2014 Express and install on local machine
downloads also available via MSDN Subscription
  • login to http://msdn.microsoft.com subscription
  • navigate to the Subscriber Downloads section
  • search on the keywords: “sql server 2014 express”
  • download / install Microsoft SQL Server 2014 Express Management Console
  • download / install. NET 3.5 Framework (as needed)
Advertisements
This entry was posted in Azure, SQL Server DB, Visual Studio. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s