Skip Navigation LinksHome Page > SQL Azure Information Center > SQL Azure and Access Links

Links for Access, SQL Azure, and SQL Server

Microsoft has changed the name of SQL Azure to Windows Azure SQL Database, Azure SQL Database, or SQL Database.


Benefits of Using SQL Azure

The Advantages of SQL Azure and Microsoft Access
Why Access and SQL Azure make an excellent combination.

The pros of Windows Azure SQL Database
The advantages to using SQL Azure, as opposed to setting up your own SQL Server instance.

Windows Azure SQL Database Content Index
This page provides a centralized listing of all technical content pertaining to SQL Database. Content on this page is organized into two groupings; by topic (scenario,) and by feature. Topics are broken down into broad scenarios such as getting started, administration, or troubleshooting, while features are broken down by product features such as SQL Database, SQL Data Sync, and Windows Azure SQL Reporting.

Why you should think twice about Windows Azure SQL Database
A follow up to the article "The pros of Windows Azure SQL Database". An Azure SQL Database is not the best choice for all scenarios. This article discusses disadvantages to consider when determining whether or not to use an Azure SQL Database.

The Cloud is good for your career
People that work with Microsoft Azure Cloud Technologies make more money.

Microsoft Azure and Cloud Computing...What it Means to Me and Information Workers
An article by Luke Chung, President of FMS.

As Microsoft’s SQL Azure gains altitude, industry eyes chances of reign
An article about the growing use of SQL Azure by businesses and non-profit organizations.

Seven things that may surprise you about the Windows Azure Platform

Introducing SQL Azure Database
The Key Benefits of Microsoft SQL Azure.

Cloud Computing: An Introduction to SQL Azure
With SQL Azure, you can realize the benefits of a familiar relational database platform, plus the benefits of cloud computing.

The Advantages of SQL Azure and Microsoft Access
Learn What SQL Azure and Microsoft Access Can Do for You. Learn about lower costs, no expensive hardware to purchase and maintain, faster developement time, safe access to your data 24/7, and more.

The Advantages of SQL Azure and Microsoft Access
Learn What SQL Azure and Microsoft Access Can Do for You. Learn about lower costs, no expensive hardware to purchase and maintain, faster developement time, safe access to your data 24/7, and more.

Compare SQL Server with SQL Azure
SQL Azure is compared to SQL Server with a helpful chart of features.

Moving to Multi-Tenant Database Model Made Easy with SQL Azure Federations
The benefits of scaling out using SQL Azure federations.



Microsoft Access and SQL Azure

Access 2013, Web Apps, SQL Server, and SQL Azure
An article by Russell Sinclair from the The Microsoft Office Blog.

Access 2010 and SQL Azure
An article by Russell Sinclair from the The Microsoft Office Blog.

Microsoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server Tables in the Cloud)
An article by Luke Chung, President of FMS.

Deploying Microsoft Databases Linked to a SQL Azure Database to Users without SQL Server Installed on their Machine
An article by Luke Chung, President of FMS.

Connecting Microsoft Access to SQL Azure
A Walkthrough demonstrating step-by-step how to use Access to link to tables in a SQL Azure database using a DSN (Data Source Name) file by MVP Dhananjay Kumar.

Optimizing Microsoft Office Access Applications Linked to SQL Server
Even though this article is about SQL Server, most of the article can be applied to SQL Azure.

Handling Transactions in SQL Azure
Learn about using Transactions in SQL Azure.

Building Safer SQL Azure Cloud Applications with Microsoft Access
Examines the security risks of using DSNs, Linked Tables, and saved Pass-through queries and demonstrates how to safely get data from SQL Azure using Access.

How To's for Access, SQL Azure, and SQL Server
Come to this page for the latest How To's, tips, and code.



Azure SQL Database Overviews

SQL Database documentation
Learn how to configure, monitor, and scale your SQL databases in Azure. Documentation, tutorials and more.

Sign up for a Free Trial.
You can sign up for free trial and check out Azure SQL Databases for one month free!

Get Started with Azure SQL Database
Microsoft Azure SQL Database is a relational database-as-a-service that makes tier-1 capabilities easily accessible.

Azure SQL Database - create DBs in seconds
This is a brief intro video for Azure SQL Database, and shows how developers and DBAs can create a SQL Database.

Create your first Azure SQL Database
This article shows you how to create a sample Azure SQL Database in under five minutes. You learn how to:

  • Provision a logical server by using the Azure portal.
  • Create a database populated with sample data.
  • Set a firewall rule for the database to configure which IP addresses can access your database.

This tutorial assumes that you have an Azure Subscription. If you do not, you can sign up for a free trial.

Windows Azure SQL Database Architecture
How Windows Azure SQL Databases are designed and the various technologies with which they work.

Overview of Azure SQL Database
Azure SQL Database is a cloud database service from Microsoft. SQL Database provides web-facing database functionality as a utility service where you pay only for what you use. Cloud-based database solutions such as SQL Database can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead. This paper provides an architectural overview of SQL Database, and describes how you can use SQL Database to augment your existing on-premises data infrastructure or as your complete database solution.

Service Updates for Azure SQL Databases
One place to see all updates for Azure SQL Databases.

What's new in SQL Database V12
This topic describes the many advantages that the new V12 version of Azure SQL Database has over version V11. We continue to add features to V12. So we encourage you to visit our Service Updates webpage for Azure, and to use its filters:

  • Filtered to the SQL Database service.
  • Filtered to General Availability (GA) announcements for SQL Database features.
The latest information about resource limits for SQL Database is documented at Azure SQL Database Resource Limits.

Introduction to Windows Azure SQL Database Services (Part 1)
An overview of the architecture of Windows Azure SQL database plus a demonstration of how to create a Windows Azure SQL Database.

Transact-SQL Support for Windows Azure SQL Databases
Supported, Partially Supported, and Unsupported T-SQL Features in Windows Azure SQL Databases.

Windows Azure SQL Database Provisioning Model
The Microsoft SQL Database provisioning process prepares and configures the hardware and software required to maintain your data at a Microsoft data center. The SQL Database provisioning model describes the logical hierarchy of your Windows Azure platform account, SQL Database servers, and databases; it enables you to provision your data storage rapidly.

Azure SQL Database Data Access
General examples of how your database application can access data in Windows Azure SQL Database. .




SQL Azure Pricing and Data Transfer Costs

SQL Database Pricing Details
Azure SQL Databases pricing details for the new service tiers.

Windows Azure Pricing Calculator--Data Management.
Quickly see the cost for the Azure SQL Database size and the bandwith of data going out from an Azure SQL Database.

Azure SQL Database Accounts and Billing
Learn about the SQL Azure Editions, billing, buying an Azure SQL Database subscription, Bandwidth usage, limiting the size of databases, Database Federations, and how to view your bill and usage charges.

MSDN Subscribers Receive Up to $3,700 in Annual Windows Azure Benefits
If you are an existing Visual Studio Professional, Premium or Ultimate with MSDN subscriber, you get free access to Windows Azure each month, and up to $3,700.00 in annual Windows Azure benefits at no charge.

Get started with Azure using monthly credits included with your MSDN subscription
Get started with Azure now using monthly credits included with your MSDN subscription (up to $150/month). Quickly create a dev/test sandbox using Azure Virtual Machines and your MSDN software.

Azure SQL Database Accounts and Billing--MSDN web page
Learn about the SQL Azure Editions, billing, buying an Azure SQL Database subscription, Bandwidth usage, limiting the size of databases, and viewing your bill and usage charges.

sys.database_usage (Azure SQL Database)
The sys.database_usage view lists the number, type, and duration of databases on the SQL Database server. It returns one row for each day of your subscription.

sys.bandwidth_usage (SQL Database)
Returns information about the network bandwidth used by each database in a Azure SQL Database logical server. Each row returned for a given database summarizes a single direction and class of usage over a one-hour period.

Windows Azure SQL Database Billing Numbers Directly From Transact-SQL
How to use two Azure SQL Dynamic Managed Views called sys.database_usage and sys.bandwidth_usage to see the activity for your account. This helps explain account usage from a billing perspective. A TechNet Wiki article.

March Madness-SQL Azure-sys.database_usage
Determine what your SQL Azure Databases are costing you based upon the size of the database by using the sys.database_usage View.

March Madness-SQL Azure-sys.bandwidth_usage
How to use the sys.bandwidth_usage View to determine the exact cost of bandwith usage per database, per day for moving data in and out of your databases.

Getting started with SQL Azure - Part 3: Provisioning and Billing Model of SQL Azure << Paras Doshi
Understanding SQL Azure provisioning and pricing.

SQL Azure: Is there a "per transaction" cost for Windows Azue SQL Database?
Is there a “per transaction” cost for Windows Azue SQL Database (SQL Azure)?

Pricing comparision between SQL Server in Azure VM and Azure SQL Database
Price comparison of SQL Server hosted in virtual machine as an IAAS solution and SQL Azure Database as a PAAS solution.

Data Series: SQL Server in Windows Azure Virtual Machine vs. SQL Database
The introduction of new IaaS capabilities for Windows Azure leads to an important question: when should I choose Windows Azure SQL Database, and when should I choose SQL Server running in a Windows Azure VM when deploying a database to the cloud?



Get the Recomended ODBC Driver

A SQL Server Driver must be installed!

An ODBC driver is required for all computers that use Microsoft Access and Azure SQL Databases. The recomended drivers are the Microsoft® ODBC Driver 11 for SQL Server® for Windows or the Microsoft® SQL Server® 2012 Native Client. Microsoft no longer includes the necessary drivers with Windows. They are only included if you have installed SQL Server 2012 or 2014 on your computer.

Instructions for Using the Microsoft ODBC Driver 11 for SQL Server for Windows:
1. First download and install the Microsoft ODBC Driver 11 for SQL Server for Windows. Instructions are below.
2. Then change the Driver section of your Connection String to DRIVER=ODBC Driver 11 for SQL Server;.

--Supported Operating Systems: Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012, Windows Vista Service Pack 2.
--Supports Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012, SQL Server 2014 and Windows Azure SQL Database.

Install Instructions for Microsoft ODBC Driver 11 for SQL Server for Windows
1) Click the "Download" button on .
2) Select the download file to match your computer's Windows Operating System.
        For 64 bit (x64) Operating Systems select the 1033\x64\msodbcsql.msi file.
        For 32 bit (x86) Operating Systems select the 1033\x86\msodbcsql.msi file.

The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Windows Azure SQL Database. It contains new features as well as all the features that shipped with ODBC in SQL Server 2012 Native Client.

Introducing the new Microsoft ODBC Drivers for SQL Server
Welcome to the Microsoft ODBC Driver 11 for SQL Server on Windows
Driver-Aware Connection Pooling in the ODBC Driver for SQL Server


Instructions for Using the Microsoft SQL Server 2012 Native Client:
1. First Download the Microsoft® SQL Server® 2012 Native Client from the Microsoft® SQL Server® 2012 Feature Pack Download page Instructions on how to do this are below.
2. Then change the Driver section of your Connection String to DRIVER={SQL Server Native Client 11.0};.

--Supported Operating Systems: Windows 8, Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2.
--Supports Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012 and Windows Azure SQL Database.

Install Instructions for the Microsoft SQL Server 2012 Native Client
1) Click the "Install Instructions" button on the Microsoft® SQL Server® 2012 Feature Pack Download page.
2) Scroll down the page until you see "Microsoft® SQL Server® 2012 Native Client".
3) Select the download file to match your computer's Windows Operating System.
        For 64 bit (x64) Windows Operating Systems select the X64 Package (sqlncli.msi).
        For 32 bit (x86) Windows Operating Systems select the X86 Package (sqlncli.msi).

More Information:
Learning SQL Server Native Client
Using Connection String Keywords with SQL Server Native Client
Updating an Application to SQL Server Native Client from MDAC
Building Applications with SQL Server Native Client
System Requirements, Installation, and Driver Files
SQL Server Native Client Programming




Getting Started with SQL Azure

Sign up for a Free Trial.
You can sign up for free trial and check out Azure SQL Databases for one month free!

SQL Database documentation
Learn how to configure, monitor, and scale your SQL databases in Azure. Documentation, tutorials and more.

Azure SQL Database - Create DBs in Seconds
This is a brief intro video, 1 minute, 36 seconds, for Azure SQL Database, and shows how developers and DBAs can create a SQL Database.

Get Started with Azure SQL Database
Microsoft Azure SQL Database is a relational database-as-a-service that makes tier-1 capabilities easily accessible.

Azure SQL Database - create DBs in seconds
This is a brief intro video for Azure SQL Database, and shows how developers and DBAs can create a SQL Database.

Create your first Azure SQL Database
This article shows you how to create a sample Azure SQL Database in under five minutes. You learn how to:

  • Provision a logical server by using the Azure portal.
  • Create a database populated with sample data.
  • Set a firewall rule for the database to configure which IP addresses can access your database.

This tutorial assumes that you have an Azure Subscription. If you do not, you can sign up for a free trial.

Windows Azure SQL Database: How to create Windows Azure SQL Database
This article covers different methods of Windows Azure SQL Database creation.
    1. Create a Windows Azure SQL Database using Windows Azure Management Portal
    2. Create a Windows Azure SQL Database using SQL Commands or programmatically
    3. Create a Windows Azure SQL Database using Microsoft SQL Server Management Studio or Visual Studio
    4. Create a Windows Azure SQL Database using PowerShell

Getting Started with Windows Azure SQL Database Using the Windows Azure Platform Management Portal
A very beneficial TechNet Wiki article by Wesley McSwain and Selcin Turkarslan with plenty of screenshots that walks you through the process of creating a Windows Azure Platform Subscription for SQL Azure, creating a SQL Azure Server for your database, setting up the Firewall rules, and creating a new database.

Azure SQL Database Tutorials and Hands-on Labs
Tutorials and lab guides help you learn how to use specific features of Microsoft Azure SQL Database.

Windows Azure SQL Database Content Index
This page provides a centralized listing of all technical content pertaining to SQL Database. Content on this page is organized into two groupings; by topic (scenario,) and by feature. Topics are broken down into broad scenarios such as getting started, administration, or troubleshooting, while features are broken down by product features such as SQL Database, SQL Data Sync, and Windows Azure SQL Reporting.

Managing Databases and Logins in Azure SQL Database
In Microsoft Azure SQL Database, when you sign up for the service, the provisioning process creates an Azure SQL Database server, a database named master, and a login that is the server-level principal of your Azure SQL Database server. That login is similar to the server-level principal, sa, for an instance of SQL Server on your premises.

Security Center for SQL Server Database Engine and Azure SQL Database
This page provides links to help you locate the information that you need about security and protection in the SQL Server Database Engine and Azure SQL Database.

Getting Started with SQL Azure - Part 1: What is SQL Azure?
An introduction to Azure SQL Databases by Paras Doshi.

Getting Getting started with SQL Azure - Part 2: Creating Azure account and a SQL Azure Database
In this article shows how to open a Windows Azure account. Then it shows how to create a SQL Azure Database. Finally, it shows how to connect to the SQL Azure Database using the SQL Server Management Studio. By Paras Doshi.

Getting Started with SQL Azure - Part 3: Provisioning and Billing Model of SQL Azure
This article covers the SQL Azure Provisioning Model and the SQL Azure Billing Model. By Paras Doshi.

Getting Started with SQL Azure - Part 4: SQL Azure's Architecture
This article covers the SQL Azure Architecture what happens inside SQL Azure. By Paras Doshi.

Getting Started with SQL Azure - Part 5: SQL Azure's Security Model
This article discusses SQL Azure Firewalls, Authentication (Logins and Users), Authorization (User access to Database Objects), and Encryption and SQL Azure. By Paras Doshi.

Getting Started with SQL Azure - Part 6: Migrating Databases to SQL Azure
This article shows how you can migrate your SQL Server database to SQL Azure. By Paras Doshi.

Getting Started with SQL Azure - Part 7: SQL Azure administration - I
This article covers Improving SQL Azure Performance and, backing up and restoring strategies. By Paras Doshi.

Getting Started with SQL Azure - Part 8: SQL Azure administration - II
This article covers Managing Firewall rules, SQL Azure Servers, Databases and Logins, troubleshooting connection issues, monitoring database size and costs, monitoring SQL Azure availability, and Migrating to SQL Azure. By Paras Doshi.

Getting Started with SQL Azure - Part 9: Developing SQL Azure Applications
This article covers Developing SQL Azure Applications including the differences between SQL Azure and SQL Server. By Paras Doshi.

Getting Started with SQL Azure - Part 10 A: SQL Azure Data SYNC and SQL Azure Reporting
This article covers SQL Azure Reporting and SQL Azure Data SYNC. By Paras Doshi.

Getting Started with SQL Azure - Part 10 B: Conclusion
This article summarizes the previous articles in this series. By Paras Doshi.

How to Create a Windows Azure SQL Database Server
How to use the Windows Azure Platform Management Portal to Create a Windows Azure SQL Database Server.

How to Create a SQL Azure Database
A Walkthrough showing you how to create an Azure SQL Database.

Getting Started with SQL Azure Development (en-US)
A Walkthrough showing how to get started with SQL Azure.

Introduction to Windows Azure SQL Database Services (Part 1)
An overview of the architecture of Windows Azure SQL database plus a demonstration of how to create a Windows Azure SQL Database.

SQL Azure FAQ
Frequently asked questions about Azure SQL Databases.

SQL Azure TechNet Wiki Articles Index (en-US)
A list of the existing TechNet Wiki articles and article ideas on SQL Azure.

Management Portal for Azure SQL Database
The Management Portal for SQL Database is an online lightweight and easy-to-use database management tool. It allows you to conveniently manage your SQL Databases and to quickly develop, deploy, and manage your data-driven applications in the cloud.

SQL Azure Content Index
A centralized listing of all technical content pertaining to SQL Azure including articles outside the TechNet Wiki.

Develop and Deploy with Azure SQL Database
This TechNet Wiki article shows a number of ways to deploy your data to a SQL Azure Database.

Windows Azure and SQL Database Tutorials (en-US)
A Tutorial for beginners who have some .NET development experience.

Getting started with SQL Azure - Part 1: What is SQL Azure? << Paras Doshi
An introduction to getting started using SQL Azure.

Getting started with SQL Azure - Part 2: Creating Azure account and a SQL Azure Database << Paras Doshi
How to open a Windows Azure account, create a SQL Azure Database, and connect to SQL Azure server Via SQL Server Management Studio (SSMS).

Getting started with SQL Azure - Part 3: Provisioning and Billing Model of SQL Azure << Paras Doshi
Understanding SQL Azure provisioning and pricing.

Getting started with SQL Azure - Part 4: SQL Azure's Architecture << Paras Doshi
Understanding SQL Azure architecture and how SQL Azure works.

Getting started with SQL Azure - Part 5: SQL Azure's security model << Paras Doshi
How to manage the SQL Azure Firewall, Authentication, Authorization (Logins and Users), and encryption and SQL Azure.

Getting started with SQL Azure - Part 6: Migrating Databases to SQL Azure << Paras Doshi
How to migrate a SQL server 2008 R2 database to SQL Azure.

Getting started with SQL Azure - Part 7: SQL Azure administration - I << Paras Doshi
How to improve Performance and backup and restore strategies for SQL Azure.

Getting started with SQL Azure - Part 8: SQL Azure administration - II << Paras Doshi
How to manage firewall rules, SQL Azure servers, databases and Logins, troubleshoot connection issues, monitor database size and costs, monitor SQL Azure availability, and migrating to SQL Azure.

Getting started with SQL Azure - Part 9: Developing SQL Azure applications << Paras Doshi
This article includes helpful information about the differences in T-SQL supported statements in SQL Azure and SQL Server, management tools, and connecting to SQL Azure.

Getting started with SQL Azure - Part 10 A: SQL Azure Data SYNC and SQL Azure reporting << Paras Doshi
This article includes walkthroughs on how to use SQL Azure Reporting and SQL Azure Data Sync.

Getting started with SQL Azure - Part 10 B: Conclusion << Paras Doshi
The conclusion to the series and some helpful links for futher information.

Windows Azure SQL Database Guide
A TechNet Wiki article with an abundance of links to resources and information that will help you learn more about the Microsoft SQL Azure Database. The article highlights Getting Started, Architecture and Design, How To, Training, Code Samples, Videos, Community Resources.

Migrating Applications to Windows Azure
Links to resources that can help you to understand what to consider when migrating applications to Windows Azure.

Storing and Accessing Data in Windows Azure
Information about using Windows Azure Storage Services to store and access data.

SQL Azure: Survival Guide
A TechNet Wiki with quick links to key Microsoft documentation resources and other technical information you need to get started with SQL Azure.

Windows Azure Platform FAQs
Get the answers to your questions about Windows Azure and SQL Azure.

Compare SQL Server with SQL Azure
SQL Azure is compared to SQL Server with a helpful chart of features.

SQL Azure Feature Limitations
A detailed coverage of features in SQL Server not supported in Windows Azure SQL Databases.

Connecting MS Access and SQL Azure by Dave Jacob
A step by step Walkthrough showing how to get started with Access and SQL Azure.

Getting Started with SQL Azure Development
A very helpful article by Lynn Langit, SoCalDevGal, with a video included.

How to Install an Adventure works LT database on SQL Azure << Paras Doshi
A step by step guide to install an Adventure Works LT database (AWLT DB) on SQL Azure. This sample database is very helful when you want to try out SQL Azure.

Configure, monitor, and scale your SQL Databases in Windows Azure
The SQL Database Home page is loaded with helpful links for developers.

SQLAzure - My First Cloud
Eli Weinstock-Herman shares his first SQL Azure Database development experience on the LessThanDot website.

Guidelines for Connecting to Azure SQL Database Programmatically
Microsoft Azure SQL Database works with third-party applications, open source, and many familiar Microsoft applications, such as ODBC and ADO.NET. This article contains general guidelines for connecting to Azure SQL Database using these technologies.

SQL Azure Demos
A 15 video series demonstrating the basics of working with SQL Azure hosted on Microsoft Showcase. A CodePlex Project.

SQL Azure Architecture
An informative look at the architecture of SQL Azure by MVP Dhananjay Kumar.




Migrating Access to SQL Azure

Important Note:
In order for the SQL Server Migration Assistant (SSMA) to migrate Access to an Azure SQL Database you must install the Access Runtime. This has been an issue at least for the last two versions of the SSMA.
Download the Microsoft Access 2013 Runtime
Download the Microsoft Access 2010 Runtime
Download the Microsoft Access 2007 Runtime

Migrating Databases to Azure SQL Database
Various options available to migrate databases to SQL Azure.

Download the Microsoft SQL Server Migration Assistant for Access 6.0
The SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server, and then migrates data from Microsoft Access to SQL Server. SSMA for Access v5.2 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Azure.

SQL Server Migration Assistant for Access
You can use the SQL Server Migration Assistant for Access (SSMA) to migrate Access to Azure SQL Databases. This page contains a list of links on information about the SSMA for Access.

Migrating Access Databases to SQL Server/Azure SQL DB (AccessToSQL)
SQL Server Migration Assistant (SSMA) is a comprehensive environment that helps you quickly migrate Access databases to SQL Server or SQL Azure. By using SSMA, you can review Access and SQL Server or SQL Azure database objects, assess the Access database for migration, convert Access database objects, load them into SQL Server or SQL Azure, and then migrate data.

Access to SQL Server Migration: How to Use SSMA
A walkthrough showing you how to migrate an Access database to SQL Server using the Microsoft SQL Server Migration Assistant for Access (SSMA).

Access to SQL Server Migration: Understanding the Assessment Report and Error List
How the SQL Server Migration Assistant (SSMA) Assessment Report and Error List can help you to identify potential issues that you may need to deal with for migrating an Access database to SQL Server or SQL Azure.

Migrating Access Jet Databases to SQL Azure
Describes how to use the Microsoft SQL Server Migration Assistant for Access 4.2 (SSMA) to convert your Jet database for your Microsoft Access solution to SQL Azure. You can also use the SSMA to migrate your Access database to SQL Azure.

Migration to SQL Azure–Screencast
Lynn Langit, SoCalDevGal, uses videos to demonstrate the various ways to migrate databases to SQL Azure.

Migration Week Part I of II: Access Migration Video
Learn to use the free SQL Server Migration Assistant (SSMA) for Access to migrate data to SQL Azure.

Auto generate link table when migrating access database using SSMA
How to use the SQL Server Migration Assistant (SSMA) for Access to create a link table for every table it moves to SQL Azure or to SQL Server.

Microsoft SQL Server Migration Assistant (SSMA) Team Blog
Migrate your data from Access or a number of different database platforms to SQL Azure.

Access to SQL Azure Migration Wizard and more
Slidecasts and Videos: SQL Azure Migration Wizard, Access to SQL Azure Migration Wizard, SQL Server Management Studio 2008 R2-scripting, DACPAC, Business Intelligence Development Studio-SSIS, and Visual Studio 2010-DACPAC by Lynn Langit, SoCalDevGal.

Move Access Data to the Cloud
How to use the Microsoft SQL Server Migration Assistant for Access to move your Microsoft Access tables and queries to SQL Azure. A TechNet Wiki article.

Access to SQL Server Migration: Access Solutions using SQL Server, Part 1
Learn about your options for using Microsoft Access as a front end to SQL Azure or SQL Server.

Access to SQL Server Migration: Access Solutions using SQL Server, Part 2
Learn about Moving Data, Using Views, Stored procedures and triggers, Optimizing forms using client-side caching and query-by-form techniques, Optimizing reports using pass-through queries, Using SQL Server TVPs from Access, and Additional Resources and References.



Migrating SQL Server to Azure SQL Database

The Generate and Publish Scripts Wizard is used to create T-SQL scripts for SQL Server databases and/or related objects within the selected database.
You have probably used this wizard, so this article doesn’t walk through it step by step; instead, the article briefly highlights a few steps in the wizard and points out the options necessary to effectively work with SQL Azure.

How to: Generate a Script (SQL Server Management Studio)
You can create Transact-SQL scripts for multiple objects by using the Generate and Publish Scripts Wizard.. You can also generate a script for individual objects or multiple objects by using the Script as menu in Object Explorer..

Generate and Publish Scripts Wizard (Advanced Scripting Options Page)
Use this page to specify how you want this wizard to generate scripts. Many different options are available. Options are greyed out if they are not supported by the version of SQL Server or SQL Azure specified in Database engine type.

Generate and Publish Scripts Wizard F1 Help
Use this wizard to create Transact-SQL scripts based on objects from a database in either a local instance of the SQL Server Database Engine or SQL Azure. You can save the scripts to the location of your choice, and later use them to recreate the database objects and data in another instance of the Database Engine, or in SQL Azure. Create scripts for an entire database, or limit it to specific database objects and their data. You can also use the wizard to publish the selected objects to a remote Web hosting provider that has installed the SQL Server Database Publishing Services.

Migrating a Database to Azure SQL Database
Azure SQL Database V12 brings near-complete engine compatibility with SQL Server 2014. As such, it dramatically simplifies the task of migrating most databases from SQL Server to Azure SQL Database. Migration for many databases is a straightforward movement operation requiring few if any changes to the schema and little or no re-engineering of applications.

Bulk Database Migration from On-Premise SQL Server to SQL Azure - Step 1: Bulk .bacpac Export
Learn perform a bulk migration of on-premises SQL Server databases to Windows Azure SQL Database.

SQL Database Migration Wizard
SQL Database Migration Wizard (SQLAzureMW) is an open source application that has been used by thousands of people to migrate their SQL database to and from Windows Azure SQL Database. SQLAzureMW is a user interactive wizard that walks a person through the analysis / migration process. One of the main requests from the SQLAzureMW community was to take the user interactive wizard and make it command line driven interface so that it could be used in an automated backup process to back up their Windows Azure SQL Database schema / data to a data store for disaster recovery. I am excited to let you know that SQLAzureMW now has two tools that can be used from a command line: SQLAzureMWBatchBackup and SQLAzureMWBatchUpload.

Migrating TSQL file and SQL server 2005 / 2008 Database to SQL Azure using SQL Azure Migration wizard << Paras Doshi
How to use the SQL Azure Migration Wizard to migrate an on premise SQL server database to SQL Azure.

Channel 9 Video: SQL Database Migration Wizard
George Huey gives a detailed look at the SQL Database Migration Wizard, an open-source tool designed to migrate your on-premises SQL Server databases to Azure SQL Database.

Develop and Deploy with Azure SQL Database
This TechNet Wiki article shows a number of ways to deploy your data to a SQL Azure Database.

DacImportExportCli: Import / Export Data from SQL Azure to SQL Server (vice versa)
How to use the SQL Azure Database Import / Export v 2.0 is a command line interface to create DacPac for importing / exporting data from SQL Azure to SQL Server and vice versa.

Migrating a SQL Server Database to SQL Azure
In this video, Steve Yi walks through how to migrate an on-premises SQL Server database to SQL Azure.

Generate a Database Script for SQL Azure
Learn how to generate a script to build a SQL Azure database using an existing SQL Server database. From the "Journey to SQL Authority with Pinal Dave" blog.

Migrating SQL server Data to SQL Azure using BCP << Paras Doshi
How to use the Bulk Copy Program (BCP) command line utility to migrate data to SQL Azure from SQL Server.

Migration Week Part II of II: On Premises Migration Video
A step-by-step Walkthrough on how to migrate an existing on-premises SQL Server Database to SQL Azure.

SQL Azure – Different options to Migrate Existing SQL Database to Cloud
A brief overview of three options for Migrating a database from SQL Server to SQL Azure. An article by Karthikeyan Anbarasan.

SQL Azure - Migrating On-Premises SQL Server Database to SQL Azure Cloud–Option 1
How to use the SQL Server 2005 Management Studio Generate Script Wizard to migrate the Schema for a local SQL Server 2005 on-premises database to SQL Azure. A Walkthrough by Karthikeyan Anbarasan.

SQL Azure - Migrating On-Premises SQL Server Database to SQL Azure Cloud–Option 2
How to use the SQL Server Migration Wizard v3.7.1 to migrate a local SQL Server 2005 on-premises database to SQL Azure. A Walkthrough by Karthikeyan Anbarasan.

How to use SQL server Integration services (SSIS) to migrate data from SQL server to SQL Azure << Paras Doshi
How to use SSIS to migrate data from a table in a local SQL Server database to a SQL Azure database.




Security and SQL Azure

Security Center for SQL Server Database Engine and Azure SQL Database
This page provides links to help you locate the information that you need about security and protection in the SQL Server Database Engine and Azure SQL Database.

Security Guidelines and Limitations (Windows Azure SQL Database)
Download a document that provides an overview of security guidelines for Azure SQL Databases.

Security Guidelines for SQL Azure
Download a document that provides an overview of security guidelines for Azure SQL Databases.

Windows Azure SQL Database Connection Security
Security fundamentals and best practices when working with Windows Azure SQL Database.

Microsoft's Cloud SQL Database Gets Row Level Security
Microsoft's cloud-based SQL Database now supports row level security (RLS), a feature offered in a number of other databases. RLS lets administrators provide row-level access to data based on a user's identity or role.

Encrypting Connections to SQL Server
Information about SQL Server support of Secure Sockets Layer (SSL) and compatability with Internet Protocol security (IPSec).

Using Connection String Keywords with SQL Server Native Client
The following sections describe the keywords that can be used with the SQL Server Native Client OLE DB provider, the SQL Server Native Client ODBC driver, and ActiveX Data Objects (ADO) when using SQL Server Native Client as the data provider. Note: ADO is not supported for use with Azure SQL Databases.

How to Create a Management Certificate for Windows Azure
How to create a X.509 v3 Windows Azure management certificate used to authenticate an agent, such as Visual Studio Tools for Windows Azure or a client application that uses the Service Management API, acting on behalf of the subscription owner.

How to Add a Management Certificate to a Windows Azure Subscription
Two ways to upload a management certificate to your Windows Azure subscription.

Building Safer SQL Azure Cloud Applications with Microsoft Access
Examines the security risks of using DSNs, Linked Tables, and saved Pass-through queries and demonstrates how to safely manage data from SQL Azure using Access. By Patrick Wood.

How to Plug Microsoft Access accde and mde Security Leaks
This article reveals the security risks of accde and mde files and presents some ways you can greatly improve the security of your files. By Patrick Wood.

Managing Databases and Logins in Azure SQL Database
In Microsoft Azure SQL Database, when you sign up for the service, the provisioning process creates an Azure SQL Database server, a database named master, and a login that is the server-level principal of your Azure SQL Database server. That login is similar to the server-level principal, sa, for an instance of SQL Server on your premises.

How to Use Microsoft Access to Create Logins in a SQL Azure Database
Learn how to use a Pass-through query with Access code to create a Login in a SQL Azure Database. You can then use that login in your Access Database can use to manage permissions and data in SQL Azure. By Patrick Wood.

Strong Password Generator
This web page instantly creates strong Passwords you can use with SQL Azure and SQL Server. You can set the Password length and bit strength per character format to adjust the Password strength.

How to Create SQL Azure Database Users With Microsoft Access VBA
Learn how to create SQL Azure Database Users which are necessary for your Access databases to work with SQL Azure. SQL Azure Database Users make it possible for you to manage permissions for your Access databases and users. By Patrick Wood.

How to Use Microsoft Access to Manage SQL Azure Database Users and Roles
Learn how to create SQL Azure Database Roles and add Users to the Roles. This will enable you to control with precision which users have access to the objects in SQL Azure by using SQL Azure Permissions. By Patrick Wood.

How to create users with limited access in SQL Azure?
How to manage SQL Azure Logins and Database Users and limit their access to SQL Azure objects.

SQL Azure Connection Security
A comprehensive TechNet Wiki article covering SQL Azure connection security information with an abundance of helpful links.

SQL Azure Security Overview
An overview of SQL Azure Security.

How to use SQL Azure Connection Encryption (en-US) with the SQL Server Management Studio
A TechNet Wiki article showing how to encrypt connections to SQL Azure using SQL Server Management Studio (SSMS).

SQL Azure Firewall
How to use the SQL Azure Firewall to secure your SQL Azure Databases. A TechNet Wiki article.

Administration: How-to Topics (Windows Azure SQL Database)
How to perform common administrative tasks with Microsoft Windows Azure SQL Database.

How to: Configure the Server-Level Firewall Settings (Windows Azure SQL Databas
How to use the Windows Azure Platform Management Portal or master database to review and edit your firewall configuration.

How to: Configure the Database-Level Firewall Settings (Windows Azure SQL Database).
Unlike SQL Database server Firewall Rules which enable clients to access your entire SQL Database server, the new Database Firewall Rules only allows client access to the Azure SQL Database.

Overview of Security in SQL Azure
This article by Wayne Walter Berry and Selcin Turkarslan discusses the subjects of the SQL Azure Firewall, SQL Authentication for Logins and Users, connection encryption, and encryption of your data.

SQL Azure SQL Authentication
This TechNet Wiki article briefly discusses using SQL Authentication, the master database, creating logins, creating users, configuring user permissions, and deleting users and logins.

SQL Azure: Securing SQL Azure
How to create and secure a SQL Azure Database. A TechNet Magazine article.

How Do I: Configure SQL Azure Security?
A TechNet video by Max Adams introducing security within SQL Azure.

SQL Azure Security Guidelines and Limitations
Incudes information about SQL Azure Firewalls, Encryption and Certificate Validation, Authentication, Logins and Users, and Best Practices.




SQL Azure Development and Administration

SQL Database documentation
Learn how to configure, monitor, and scale your SQL databases in Azure. Documentation, tutorials and more.

Configure, monitor, and scale your Azure SQL Databases
How to manage and develop your Azure SQL Databases with links to videos, tutorials, and how to guides.

Administration: How-to Topics (SQL Azure Database)
How to perform a number of common SQL Azure Administration tasks.

Service Updates for Azure SQL Databases
One place to see all updates for Azure SQL Databases.

What's new in SQL Database V12
This topic describes the many advantages that the new V12 version of Azure SQL Database has over version V11. We continue to add features to V12. So we encourage you to visit our Service Updates webpage for Azure, and to use its filters:

  • Filtered to the SQL Database service.
  • Filtered to General Availability (GA) announcements for SQL Database features.
The latest information about resource limits for SQL Database is documented at Azure SQL Database Resource Limits.

Windows Azure SQL Database Content Index
This page provides a centralized listing of all technical content pertaining to SQL Database. Content on this page is organized into two groupings; by topic (scenario,) and by feature. Topics are broken down into broad scenarios such as getting started, administration, or troubleshooting, while features are broken down by product features such as SQL Database, SQL Data Sync, and Windows Azure SQL Reporting.

Security Center for SQL Server Database Engine and Azure SQL Database
This page provides links to help you locate the information that you need about security and protection in the SQL Server Database Engine and Azure SQL Database.

Windows Azure Storage & SQL Database Tutorials
This is a series of tutorial videos on Microsoft's Channel 9. Windows Azure offers multiple services to help manage your data in the cloud. SQL Database, formerly known as SQL Azure Database, enables organizations to rapidly create, scale and extend applications into the cloud with familiar tools and the power of Microsoft SQL Server™ technology.

Monitoring Azure SQL Database Using Dynamic Management Views
Microsoft Microsoft Azure SQL Database enables a subset of dynamic management views to diagnose the performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on. This topic provides information on how to detect common performance problems by using the dynamic management views in Microsoft Azure SQL Database..

SQL Azure Content Index
A centralized listing of all TechNet Wiki content pertaining to SQL Azure.

Microsoft's Cloud SQL Database Gets Row Level Security
Microsoft's cloud-based SQL Database now supports row level security (RLS), a feature offered in a number of other databases. RLS lets administrators provide row-level access to data based on a user's identity or role.

Getting Started with SQL Azure Development (en-US)
A Walkthrough showing how to get started with SQL Azure.

How to Create a SQL Azure Database
A Walkthrough showing you how to create an Azure SQL Database.

SQL Azure FAQ
Frequently asked questions about Azure SQL Databases.

Azure SQL Database Development
Contains Links to the following Subjects:
Azure SQL Database Development Considerations
Azure SQL Database Tools and Utilities Support
Azure SQL Database Development: How-to Topics

Azure SQL Database Development: How-to Topics
This topic provides links to information about how to perform common programming tasks with Microsoft Azure SQL Database.

SQL Azure Delivery Guide
The SQL Azure Delivery Guide provides developers with the information they need to know to get started designing and delivering applications that use the SQL Azure database.

Develop and Deploy with Azure SQL Database
This TechNet Wiki article shows a number of ways to deploy your data to a SQL Azure Database.

Azure SQL Database Tutorials and Hands-on Labs
Tutorials and lab guides help you learn how to use specific features of Microsoft Azure SQL Database.

Windows Azure SQL Database Guide
A TechNet Wiki article with an abundance of links to resources and information that will help you learn more about the Microsoft SQL Azure Database. The article highlights Getting Started, Architecture and Design, How To, Training, Code Samples, Videos, Community Resources.

Guidelines and Limitations (Windows Azure SQL Database)
Guidelines and limitations that are important to consider when using Microsoft SQL Azure Database.

General Guidelines and Limitations (Windows Azure SQL Database)
Microsoft Windows Azure SQL Database general guidelines and limitations.

Features That Are Partially Supported In SQL Database V12
Differences in supported features between Windows Azure SQL Database and SQL Server from the Azure SQL Database Transact-SQL Reference.

SQL Azure Database Backward Compatibility
Backward compatibility information for Windows Azure SQL Database components.

Administration (SQL Azure Database)
Information about administering Microsoft SQL Azure Database including Firewalls, Logins, Migrating Databases, Copying Databases, Monitoring Databases, Troubleshooting, and How-To-Topics.

Windows Azure Developer Center
Links and documentation to help develop applications for Windows Azure.

SQL Azure: Indexes are very helpful but they cost $Money$
Learn how to list the size of all SQL Azure Indexes in a database. This can help save you money because the cost of a SQL Azure database is size driven.

Inside SQL Azure
An excellent TechNet Wiki article that describes the underlying architecture of Microsoft SQL Azure that explains why SQL Azure is far more than just a hosted database on a server and shows you how to get started with SQL Azure.

Why Do I Need a Clustered Index?
This article explains why SQL Azure requires clustered indexes for replication technology.

SQL Azure Management Portal Changes–Drop SQL Azure Server
How to Drop a SQL Azure Server using the SQL Azure Management Portal.

How to create Co-Administrator for SQL Azure Server
How to add a Co-Administrator for your SQL Azure Server subscription.

Manage Accounts, Subscriptions, and Administrative Roles
An overview of the basics of Windows Azure subscriptions and describes how a technical staff can manage co-administrators, storage accounts, affinity groups, and management certificates for their own subscriptions in the Windows Azure Management Portal.

Managing Databases and Logins in Azure SQL Database
In Microsoft Azure SQL Database, when you sign up for the service, the provisioning process creates an Azure SQL Database server, a database named master, and a login that is the server-level principal of your Azure SQL Database server. That login is similar to the server-level principal, sa, for an instance of SQL Server on your premises.

Importance of Affinity Groups in Windows Azure
Affinity Groups is a way to group your Compute and Storage services together in the same data center close to one another to obtain optimal performance, increasing speed, reducing latency, and lowering your costs.

How to Create an Affinity Group in Windows Azure
How to create an affinity group, which can be used to direct Windows Azure storage accounts and hosted services to the same geographical grouping within a specified region.

Service Management REST API Reference
The Service Management API provides programmatic access to much of the functionality available through the Management Portal. The Service Management API is a REST API. All API operations are performed over SSL and mutually authenticated using X.509 v3 certificates.


T-SQL for SQL Azure, Supported and Unsupported

Supported Transact-SQL Statements (SQL Azure Database)
A list of Transact-SQL statements that are supported by Microsoft SQL Azure.

Partially Supported Transact-SQL Statements (Azure SQL Database)
A list of partially supported Transact-SQL statements, arguments and options by SQL Azure.

Unsupported Transact-SQL Statements (SQL Azure Database)
A list of the Transact-SQL statements that SQL Azure does not support.

Azure SQL Database Transact-SQL Reference
Most SQL Server 2014 Transact-SQL statements are fully supported in Microsoft Azure SQL Database. This includes the SQL Server data types, operators, and the string, arithmetic, logical, cursor functions, and the other Transact-SQL elements that most applications depend upon. Partially or unsupported functions are usually related to differences in how SQL Database manages the database (such as file, high availability, and security features) or for special purpose features such as service broker. Because SQL Database isolates many features from dependency on the master database, many server-level activities are inappropriate and unsupported. Features deprecated in SQL Server 2014 are generally not supported in SQL Database.

Monitoring Azure SQL Database Using Dynamic Management Views
Microsoft Microsoft Azure SQL Database enables a subset of dynamic management views to diagnose the performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on. This topic provides information on how to detect common performance problems by using the dynamic management views in Microsoft Azure SQL Database..

Bob Beauchemin's Blog
An excellent blog about SQL Server and SQL Azure.


SQL Azure Logins, Database Users, and Database Roles

How to create users with limited access in SQL Azure?
How to manage SQL Azure Logins and Database Users and limit their access to SQL Azure objects.

Managing Databases and Logins in SQL Azure
An introduction to SQL Azure Logins, Database Users, Database Permissions, and Security.

How to Add Users to Your SQL Azure Database
An article by Wayne Walter Berry.

How to Manage SQL Azure Databases and Logins
Creating Logins and Database Users and adding them to Server or Database Roles.

How to Create Logins in SQL Azure
How to create Logins using T-SQL or Microsoft Access Passthrough queries and VBA code.

Strong Password Generator
This web page instantly creates strong Passwords you can use with SQL Azure and SQL Server. You can set the Password length and bit strength per character format to adjust the Password strength.

How to Create Database Users in SQL Azure
How to create Database Users using T-SQL or Microsoft Access Passthrough queries and VBA code.

SQL Azure - Resetting SQL Azure Database Administrator Credentials
How to reset a SQL Azure Database Administrator password using the SQL Azure Portal. A Walkthrough by Karthikeyan Anbarasan.

How to Add a Co-Administrator to an Azure Subscriptions
You can add users as co-administrators for a subscription using their Microsoft account or organizational account. To do this, you must be a co-administrator or the Service Administrator for the subscription yourself, and you should be designated as a global administrator in the directory for the subscription. Adding co-administrators using organizational accounts is recommended. See Manage Accounts, Subscriptions, and Administrative Roles for more information.

Creating Co-administrator’s for managing SQL Azure databases and servers through Azure management portal << Paras Doshi
How to add a co-administrator that can manage a SQL Azure server and database using the Azure management portal.

How to create Co-Administrator for SQL Azure Server
How to add a SQL Azure Co-Administrator which was released in the July 2011 Service Release.


Using the SQL Azure Portal

Management Portal for SQL Database
The Management Portal for SQL Database is an online lightweight and easy-to-use database management tool. It allows you to conveniently manage your SQL Databases and to quickly develop, deploy, and manage your data-driven applications in the cloud.

Creating Co-administrator’s for managing SQL Azure databases and servers through Azure management portal << Paras Doshi
How to add a co-administrator that can manage a SQL Azure server and database using the Azure management portal.

SQL Azure - Drop a Database in SQL Azure Portal
How to use the SQL Azure Portal to Drop a Database. A Walkthrough by Karthikeyan Anbarasan.

SQL Azure - Import Scripts in Azure portal
How to use the SQL Azure Portal to Import Scripts. A Walkthrough by Karthikeyan Anbarasan.


SQL Server Management Studio (SSMS)

Managing Azure SQL Database using SQL Server Management Studio
You can use Azure SQL Database Management Portal or the SQL Server Management Studio (SSMS) client application to administer your SQL Database subscriptions and create and manage associated logical servers and databases. Thus article describes how to use Management Studio to manage SQL Database logical servers and databases.

Managing Windows Azure SQL Database using SQL Server Management Studio
How to connect to your Azure SQL Databases and manage them with SQL Server Management Studio.

How to Connect SQL Server 2008 management studio to SQL Azure
A walkthrough by MVP Dhananjay Kumar.


Optimizing SQL Azure

Troubleshooting and Optimizing Queries with SQL Azure
How to use newly available Dynamic Management Views (DMVs) to improve SQL Azure performance and troubleshoot performance issues.

Monitoring SQL Azure Using Dynamic Management Views
How to detect common performance problems by using the dynamic management views in SQL Azure Database.

Gaining Performance Insight into SQL Azure
A TechNet article showing how to get information about query performance in SQL Azure using SQL Server Management Studio.

SQL Azure Performance and Elasticity Guide
A TechNet article with an abundance of information about how to optimize performance of an application developed to use SQL Azure.


Tools and Utilities for SQL Azure

Tools and Utilities Support (SQL Azure Database)
A variety of tools and utilities can be used with Microsoft SQL Azure Database from the Windows Azure Platform site.

Azure SQL Database Tools and Utilities Support
Information about a variety of tools and utilities can be used with Microsoft Azure SQL Database.

Enzo Backup for SQL Azure
Enzo Backup enables you to backup a SQL Azure database and restore the backup to other SQL Azure databases or an on premise SQL Server databases. You can also schedule backup jobs. Developed by Herve Roggero co-author of Pro SQL Azure from APress.

SQL Server and SQL Azure Performance Testing: Enzo SQL Baseline
The Enzo SQL Baseline Tool allows you to execute performance tests against multiple databases and view the collected performance results side-by-side, within the tool or in Excel for further analysis. A CodePlex Project.

SQL Azure Agent CodePlex Project
Demonstrates how you can achieve SQL Server Agent like functionality for Sql Azure.


SQL Azure and Stored Procedures

SQL Server Stored Procedure Guide for Microsoft Access – Part 1
How to use Pass-through queries in Access to run Stored-Procedures in SQL Server which also works for Sql Azure.


SQL Azure Development Examples and Articles

Developer Connection
This site has an outstanding series on Migrating and Deploying a Simple Cloud App as well as other Azure development posts.

IT Pro Connection
This blog is associated with the Developer Connection blog and has a similar cloud series on Deploying a Simple Cloud App




SQL Azure Labs

Service Updates for Azure SQL Databases
One place to see all updates for Azure SQL Databases.

What's new in SQL Database V12
This topic describes the many advantages that the new V12 version of Azure SQL Database has over version V11. We continue to add features to V12. So we encourage you to visit our Service Updates webpage for Azure, and to use its filters:

  • Filtered to the SQL Database service.
  • Filtered to General Availability (GA) announcements for SQL Database features.
The latest information about resource limits for SQL Database is documented at Azure SQL Database Resource Limits.

Test-Drive SQL Azure Labs’ New Codename "Data Transfer" Web UI for Copying *.csv Files to SQL Azure Tables or Azure Blobs
Roger Jennings shows step-by-step how to use "Data Transfer" to move your csv Files to SQL Azure Tables or Azure Blobs.




Connections to SQL Azure

Microsoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server Tables in the Cloud)
An article by Luke Chung, President of FMS.

Connecting MS Access and SQL Azure by Dave Jacob
A step by step Walkthrough showing how to get started with Access and SQL Azure.

Connecting Microsoft Access to SQL Azure
A Walkthrough demonstrating step-by-step how to use Access to link to tables in a SQL Azure database using a DSN (Data Source Name) file by MVP Dhananjay Kumar.

Guidelines for Connecting to Azure SQL Database Programmatically
Microsoft Azure SQL Database works with third-party applications, open source, and many familiar Microsoft applications, such as ODBC and ADO.NET. This article contains general guidelines for connecting to Azure SQL Database using these technologies.

Data Access Technologies Road Map
A Road Map containing information about connecting to Azure SQL Databases now and in the future.

Connection strings for SQL Azure
ConnectionStrings.com connection strings to Azure SQL Databases.

SQL Azure Connectivity Troubleshooting Guide
Help with some common problems connecting to SQL Azure databases.

Getting started with SQL Azure - Part 2: Creating Azure account and a SQL Azure Database << Paras Doshi
How to open a Windows Azure account, create a SQL Azure Database, and connect to SQL Azure server Via SQL Server Management Studio (SSMS).

How to Connect SQL Server 2008 management studio to SQL Azure
A walkthrough by MVP Dhananjay Kumar.

SQL Azure Connection Encryption (en-US)
A TechNet Wiki article showing how to encrypt connections to SQL Azure using SQL Server Management Studio (SSMS).

SQL Azure Connection Security
A comprehensive TechNet Wiki article covering SQL Azure connection security information with an abundance of helpful links.

Overview of Security in SQL Azure
This article by Wayne Walter Berry and Selcin Turkarslan discusses the subjects of the SQL Azure Firewall, SQL Authentication for Logins and Users, connection encryption, and encryption of your data.

Retry Logic for Transient Failures in SQL Azure (en-US)
Lists the reasons for connection losses and provides guidelines and best coding practices on how to solve transient connection failures in Azure SQL Databases. A TechNet Wiki article.

SQL Azure Connection Management
Understanding SQL Azure connection problems and how to solve them. A TechNet Wiki article.




Access 2013 Web Apps and SQL Azure

How to 'Hybridize' your MS Access Database In Office 365 Azure Database
This article explains how you can keep your VBA code and use it with your Access Web App SQL Azure Database. Access MVP Daniel Pineault shows step-by-step how you can create an Access Database with linked tables to your Web App SQL Azure Database. You get the best of both worlds with the Hybrid database: An Access web app and your VBA code.

Roger's Access Blog: Access Web Databases: 2010 vs. 2013
An excellent introduction to Access 2013 Web Apps by Access MVP Roger Carlson. This article makes clear the important vital differences between between Access 2010 Web Databases and Access 2013 Web Apps.




SQL Azure Sharding and Federations

SQL Database Federations: Enhancing SQL to enable Data Sharding for Scalability in the Cloud
SQL Database Federations, a new specification, has been released for SQL Server and SQL Azure via the SQL Azure Federation.

Federations in SQL Azure (SQL Azure Database)
An overview of SQL Azure Federations from the MSDN Library.

Build Big-Data Apps in SQL Azure with Federation
A Visual Studio Magazine Article by Roger Jennings.

How to Shard with SQL Azure
Learn how to use SQL Database sharding to scale-out your applications. A TechNet Wiki Article.

Multi-tenant SQL Azure Federations Sample
Download a CodePlex Open Source sample application demonstrating the use of SQL Azure Federations in a multi-tenant solution named the Cloud Ninja SQL Federations Sample Preview.

Preparing for Data Federation in SQL Azure
Herve Roggero shares what he has learned from an early preview of SQL Azure Data Federations to help you prepare for an upcoming release of SQL Azure that will support Data Federation.

SQL Server and SQL Azure Shard Library CodePlex Project
A couple of SQL Shard Libraries that allow you to spread the load of database queries over multiple databases.

SQL Azure Federations: How to Build Large-Scale Database Solutions with SQL Azure
Introduction to SQL Azure Federations which enable the scaling-out of database applications.

Building Scalable Database Solution with SQL Azure - Introducing Federation in SQL Azure
Learn about the benefits of SQL Azure Federation.

SQL Azure Federations: Robust Connectivity Model for Federated Data
Learn about connectivity enhancements that come with SQL Azure Federations.

The "NoSQL" Gene in SQL Azure Federations
Learn how Federation brings the benefits of the NoSQL model into SQL Azure.

Moving to Multi-Tenant Database Model Made Easy with SQL Azure Federations.
How SQL Azure Federations uses filtering connections to enable moving from a single-tenant-per-database model to a fully dynamic multi-tenant database model.

Federation Repartitioning Operations: Database SPLIT in Action
How the SPLIT command enables your application to scale out or scale down SQL Azure databases.




SQL Azure Backups, Copies, and Data Synching

Azure SQL Database Business Continuity
Business continuity is the ability to continue business operations when a crisis or disaster occurs. The following features are discussed:

  • Point In Time Restore
  • Geo-Restore
  • Standard Geo-Replication
  • Active Geo-Replication
  • Additional business continuity features

Azure SQL Database Backup and Restore
Microsoft Azure SQL Database has built-in backups to support self-service Point in Time Restore and Geo-Restore for Basic, Standard, and Premium service tiers. Topics covered:

  • Features Supported by Service Tiers
  • Built-in Automatic Backup in Azure SQL Database
  • Point in Time Restore for Azure SQL Database
  • Restoring an Active Database to a Point in Time
  • Restoring a Deleted Database
  • Geo-Restore
  • Archiving
  • Protection against Data Loss – Beyond Backup and Restore
  • Frequently Asked Questions

SQL Databases: Support for Automated SQL Database Exports
Scott Guthrie wrote in his blog "One commonly requested feature we’ve heard has been the ability for customers to perform recurring, fully automated, exports of a SQL Database to a Storage account. Starting today this is now a built-in feature of Windows Azure. You can now export transactional-consistent copies of your SQL Databases, in an automated recurring way, to a .bacpac file in a Storage account using any schedule you wish to define."

Submit a Database Restore Request
Learn the necessary steps to making a restore request and monitoring the status of the restore request.

Current Options for Backing up Data with Windows Azure SQL Database
Backups are performed for a number of reasons including: security against hardware failure and protection against user error. Windows Azure SQL Database provides good options for handling both these scenarios. This white paper will cover the current backup operations for SQL Database.

Azure SQL Database Business Continuity: How to Prevent Loss of Vital Services and Data
Business continuity is the ability to continue business operations when a crisis or disaster occurs. Business continuity planning requires processes, procedures, and measures to ensure that business operations can continue without interruption. This topic focuses on the Azure SQL Database features that enable business continuity and disaster recovery.

How to: Use the Import and Export Service in Azure SQL Database
How to use the Windows Azure SQL Database Import and Export service. The Import and Export service provides an easy way to migrate and archive Azure SQL Databases.

How to: Use the Import and Export Service in Azure SQL Database
The Import and Export service provides an easy way to migrate and archive Azure SQL Databases.

How to: Import a Data-tier Application (SQL Azure)
You can use the DAC export and import operations to copy databases between SQL Azure servers, or to migrate databases between the SQL Server Database Engine and SQL Azure.

How to Create a Storage Account for a Windows Azure Subscription
When you Export a DAC export file (BACPAC) from SQL Azure it must be stored in the Blob service of the Windows Azure Storage Service. This article gives instructions on how to create a storage account.

Azure Storage Explorer
Azure Storage Explorer is a useful GUI tool for inspecting and altering the data in your Windows Azure Storage storage projects including the logs of your cloud-hosted applications. All 3 types of cloud storage can be viewed and edited: blobs, queues, and tables. It is a CodePlex Open Source Community Project.

Automating SQL Azure Backup Using Worker Role
A CodePlex Open Source Community Project. This tool is used for backup functionality on SQL Azure database and tables in a periodical timeline. The code can deployed as a Worker role with Azure or on-premise environment and the backup file can stored to blob storage or to file system.


Making Copies of SQL Azure Databases

How to: Use Database Copy (Azure SQL Database)
How to use Database Copy (DB Copy) to make a copy of your Microsoft Azure SQL Database. The new database that is created as a result of the copy operation is a fully functioning and independent copy of the source database. The copy operation preserves the service tier and performance level of the source database.

How to: Back Up Your Database (SQL Azure)
How to make a copy your SQL Azure database. A MSDN article.

Copying Databases in Windows Azure SQL Database
Learn the quickest and easiest way to make an exact copy your SQL Azure database to another SQL Azure Database. This is very useful for data security and safe development on a copy of the database.

Backing Up Your SQL Azure Database Using Database Copy
With the release of Service Update 4 for SQL Azure you now have the ability to make a snapshot of your running database on SQL Azure. This allows you to quickly create a backup before you implement changes to your production database, or to create a test database that resembles your production database. You can copy a database to a different Server.

Moving SQL Azure Servers Between Subscriptions
Microsoft added a new feature to the Windows Azure Management Portal to enable moving your SQL Azure servers between different subscriptions.


SQL Data Sync

Overview of SQL Data Sync
SQL Data Sync (Preview) is a service of SQL Database that enables you to synchronize the data you select across multiple SQL Server and SQL Database instances. To synchronize your data you create sync groups which define the databases, tables and columns to synchronize as well as the synchronization schedule.
The Microsoft Azure SQL Data Sync plug-in on the Microsoft Azure Silverlight portal has been decommissioned. Going forward, use the Microsoft Azure Management portal, for Azure SQL Data Sync.
You access SQL Data Sync (Preview) via the SYNC tab under SQL Database at the Microsoft Azure Management portal.
This article shows you how to Create a Sync Group and how to Modify a Sync Group.

Getting Started with Azure SQL Data Sync (Preview)
In this tutorial, you learn the fundamentals of Azure SQL Data Sync using the Azure (Preview) portal.
This tutorial assumes minimal prior experience with SQL Server and Azure SQL Database. In this tutorial, you create a hybrid (SQL Server and SQL Database instances) sync group fully configured and synchronizing on the schedule you set.

Sync Framework for Windows Azure SQL Database
Best practices guidelines on synchronizing Azure SQL Database with SQL Server.

Sync Framework: SQL Server to Windows Azure SQL Database Synchronization
This article shows how to use the 2.1 version of the Sync Framework to write a console application to synchronize Windows Azure SQL Database with on-premises SQL Servers. The Sync Framework takes care of all the messy details for you, leaving you just tying the pieces together in very few lines of code.

SQL Azure Data Sync - Name a Sync Group
How to name a Sync Group. A synchronization group is two or more databases that are logically grouped together for the purpose of synchronizing specified tables, columns and rows common to each. SQL Azure Data Sync supports synchronization groups that are comprised exclusively of SQL Azure databases or a mix of SQL Server and SQL Azure databases. Each sync group must have a unique name.

FAQ (SQL Data Sync)
Frequently asked questions about SQL Data Sync.

What's New in SQL Data Sync
This topic covers the progression of capabilities and improvements added to SQL Data Sync (Preview)..

SQL Azure Data Sync Agent Preview Download Page
This download is for the on-premises Data Sync Agent that works in conjunction with the SQL Azure Data Sync service. It enables on-premises SQL Server data to be synchronized with SQL Azure databases. Preview: 4.0.46.0.

An introduction and demonstration of SQL Azure Data Sync
In this Microsoft Showcase video Mark Scurrell Gives a Demonstration of SQL Azure Data Sync.

Work with Sync Groups
A Sync Group is two or more databases that are logically grouped together for the purpose of synchronization.

Synchronizing Data "From On-Prem to Cloud" or "Cloud to Cloud" Using SQL Azure Data Sync
Video shows how to use SQL Azure Data Sync data synchronization for various scenarios like hybrid applications (on-prem to cloud), scale out (cloud to cloud), geo distribution (cloud to cloud across data centers). Also shows how SQL Azure Data Sync can be used with other Azure platform capabilities like Azure Reporting Services.

Microsoft Sync Framework Developer Center
Information, resources, downloads, code samples, blogs, and more about the Microsoft Sync Framework.

Microsoft Sync Framework - A TechNet Wiki Article
Links to Community Resources and Sync Framework Wiki Pages.

SQL Azure Data Sync Agent Preview
The Service Update (SU5) for SQL Data Sync introduces a new client agent (version 4.0.89.0) which can be downloaded from the client agent download site.

SQL Azure Data Sync Scenario - SQL Azure-to-SQL Azure Synchronization
Create and schedule regular synchronizations between two SQL Azure databases.

SQL Azure Data Sync Scenario - SQL Azure-to-SQL Server Synchronization
Create and schedule regular synchronizations between SQL Server and SQL Azure databases to distribute data from a SQL Azure database out to one or more SQL Server databases, such as those in field offices.

SQL Azure Data Sync - Create a Sync Group
How to create a synchronization group of two or more databases that are logically grouped together for the purpose of synchronizing specified tables, columns and rows common to each.

Sync Framework - SQL Server to SQL Azure Synchronization
How to use the 2.1 version of the Sync Framework to write a console application to synchronize SQL Azure with on-premises SQL Servers. A TechNet Wiki Article.


Enzo Backup

Enzo Cloud Backup for SQL Azure
Enzo Backup enables you to backup a SQL Azure database and restore the backup to other SQL Azure databases or an on premise SQL Server databases. You can also schedule backup jobs. Developed by Herve Roggero, co-author of Pro SQL Azure from APress.

My Experiments with "Enzo backup for SQL Azure (Beta)" – an one of it’s kind Tool for SQL Azure Backups
Paras Doshi walks us through his experience using Enzo Backup to make a backup of a SQL Azure database and restore a copy of the database from the backup.


Using Powershell to Backup and Restore SQL Azure Databases

Automating SQL Azure backup to On premise Disks using a SQL Azure management cmdlet
How to automate SQL Azure backups to an on premise location using a SQL Azure Powershell cmdlet.

SQL Azure Backup to Windows Azure blobs using Azure management cmdlet (Powershell)
How to backup a SQL Azure Database to Azure blobs.




Helpful Tools

Overview of Tools to Use with Windows Azure SQL Database
An overview of the current tools produced by Microsoft that support Windows Azure SQL Database. For more information, see Azure SQL Database Tools and Utilities Support.

Azure SQL Database Tools and Utilities Support
Information about a variety of tools and utilities can be used with Microsoft Azure SQL Database.

Management Portal for SQL Database
The Management Portal for SQL Database is an online lightweight and easy-to-use database management tool. It allows you to conveniently manage your SQL Databases and to quickly develop, deploy, and manage your data-driven applications in the cloud.

Service Updates for Azure SQL Databases
One place to see all updates for Azure SQL Databases.

What's new in SQL Database V12
This topic describes the many advantages that the new V12 version of Azure SQL Database has over version V11. We continue to add features to V12. So we encourage you to visit our Service Updates webpage for Azure, and to use its filters:

  • Filtered to the SQL Database service.
  • Filtered to General Availability (GA) announcements for SQL Database features.
The latest information about resource limits for SQL Database is documented at Azure SQL Database Resource Limits.




Helpful Links and Blogs

Windows Azure SQL Database Content Index
This page provides a centralized listing of all technical content pertaining to SQL Database. Content on this page is organized into two groupings; by topic (scenario,) and by feature. Topics are broken down into broad scenarios such as getting started, administration, or troubleshooting, while features are broken down by product features such as SQL Database, SQL Data Sync, and Windows Azure SQL Reporting.

Contagious Curiosity
An excellent blog by Lynn Langit, SoCalDevGal. She encourages girls and women to become developers and her post and videos on Migration to SQL Azure–Screencast is excellent.

Roger Jenning's Windows Azure and Cloud Computing Posts
One of the best Cloud Developer sites on the web. A compendium of Windows Azure, Windows Azure Platform Appliance, SQL Azure Database, AppFabric and other cloud-computing articles.

Software MechaniK
An blog with posts about Microsoft Access, Excel, and SQL Azure.

SQL Azure - Your Data in the Cloud
An MSDN blog by Cihan Biyikoglu.

Paras Doshi's blog on (SQL) Azure!
An award winning blog about SQL Azure.

DEBUG MODE......
An excellent blog by MVP Dhananjay Kumar with many helpufl articles about SQL Azure.

SQLXpertise
A blog about SQL Azure, SQL Server, .Net and more.

Debugging the Technology!!!
Karthikeyan Anbarasan's blog about Microsoft Technologies Articles and Tutorials covering SQL Server, SQL Azure, and Windows Azure.




SQL Server and SQL Azure

Managing Windows Azure SQL Database using SQL Server Management Studio
How to connect to your Azure SQL Databases and manage them with SQL Server Management Studio.

Compare SQL Server with SQL Azure
SQL Azure is compared to SQL Server with a helpful chart of features.

General Guidelines and Limitations (Windows Azure SQL Database)
Microsoft Windows Azure SQL Database general guidelines and limitations.

Features That Are Partially Supported In SQL Database V12
Differences in supported features between Windows Azure SQL Database and SQL Server from the Azure SQL Database Transact-SQL Reference.

SQL Azure Feature Limitations
A more detailed coverage of features in SQL Server not supported in SQL Azure.

LINQ with SQL Azure
A video by Dhananjay Kumar showing how to use LINQ with SQL Azure using the SQL Azure Portal and Microsoft Visual Studio 2010.




SQL Server

Books Online for SQL Server 2014
Books Online contains the task descriptions and reference documentation that describes how to perform data management and business intelligence work by using SQL Server.

SQL Server Developer Center
SQL Server documentation, downloads, samples and resources.

SQL Server Online Resources
MSDN SQL Server Home page for Developers contains a wealth of resources.

Support for Microsoft SQL Server 2008 R2, 2008, 2005, and 2000
Microsoft SQL Server Links for Key Resources, Downloads, Upgrade and Migration, Tools, PowerPivot and BI, Community, Support Options, and Support Lifecycle.

Access to SQL Server Migration: Access Solutions using SQL Server, Part 1
Discusses your options for continuing to use Access as a front-end client once you have migrated the data to SQL Server.

Access to SQL Server Migration: Access Solutions using SQL Server, Part 2
Continues the discussion about options for continuing to use Access as a front-end client once you have migrated the data to SQL Server.

SQL Server Magazine
A high quality online magazine.

SQLblog.com
A site with a number of great blogs.

SQLServerCentral.com
An outstanding site with many excellent articles and blogs.




SQL Server Express

Microsoft SQL Server Express WebLog
The official Microsoft SQL Server Express WebLog.

What does this Express Edition look like, anyhow?
How to install the SQL Server Express edition with SQL Server Management Studio and other tools and services.



Login Status: Not logged in.
Login      Free Registration

  Call Us for a Free Consultation

Phone:

Email:

Share

Site Navigation

Skip Navigation Links.