Skip to main content

How to Build and Manage a Business Database Application on SQL Azure

Share this:

Faced with the need to create a business database, most people think "small database" they think of Microsoft Access. They might also add SQL Server Express edition or, perhaps, SQL Server Standard edition, to an Access implementation to provide users with relational features.

What all these solutions have in common is that they run on-premises -- and therefore require a server to run on, a file location to live in, license management and a back-up and recovery strategy.

A new alternative to these approaches to the on-premises database is SQL Azure, which delivers the power of SQL Server without the on-premises costs and requirements.

Microsoft SQL Azure Database is a secure relational database service based on proven SQL Server technologies. The difference is that it is a fully managed cloud database, offered as a service, running in Microsoft datacenters around the globe. It is highly scalable, with built in high-availability and fault tolerance, giving you the ability to start small or serve a global customer base immediately.
The resources on this page will help you get an understanding of using SQL Azure as an alternative database solution to Access or SQL Express.

Security Guidelines for SQL Azure
Get a complete overview of security guidelines for SQL Azure access and development.
SQL Azure Connectivity Troubleshooting Guide
The SQL Azure Team Blog explores common connectivity error messages.
TechNet Forums on Azure Data Storage & Access
Your best resource is other IT Pros working SQL Azure databases. Join the conversation.
Creating a SQL Server Control Point to Integrate On-Premise and Cloud Databases
When using multiple SQL Server Utilities, be sure to establish one and only one control point for each.
How Do I: Configure SQL Azure Security? (Video)
Microsoft’s Max Adams introduces security in SQL Azure, covering logins, database access control and user privilege configuration.

Related Products