Hade du nytta av den här sidan?
Din feedback om det här innehållet är viktig. Berätta vad du tycker.
Ytterligare feedback?
1500 tecken kvar
Exportera (0) Skriv ut
Visa allt
Det här innehållet finns inte tillgängligt på ditt språk men här finns den engelska versionen,

Azure SQL Database Guidelines and Limitations

Updated: February 25, 2015

This section describes the guidelines and limitations that are important to consider when using Microsoft Azure SQL Database.

For solutions to common customer problems with Azure SQL Database, SQL Server Data Tools, and SQL Server Management Studio, see Database Lifecycle Management.

In This Section


Topic Description

Azure SQL Database General Guidelines and Limitations

Describes the general guidelines and limitations, including the following:

  • Tools and technology support

  • Visual Studio support

  • Driver, library, and protocol support

  • Data migration support

  • SQL Server Agent/Jobs

  • Transaction support

  • Row Versioning-Based Isolation Levels

  • SQL Server collation support

  • Clustered index requirements

  • Database count and size limits

  • Naming requirements

  • Connection constraints

Azure SQL Database Security Guidelines and Limitations

Describes the security-related guidelines and limitations to consider when managing security in Microsoft Azure SQL Database. The following areas are covered:

  • Firewall

  • Encryption and certificate validation

  • Authentication

  • Logins and users

  • Best practices


Topic Description

Azure SQL Database Transact-SQL Reference

Lists some of the SQL Server features and syntax not supported by Microsoft Azure SQL Database.

Federation Guidelines and Limitations

Lists limitations that are specific to federations.

The current implementation of Federations will be retired with Web and Business service tiers. Consider deploying custom sharding solutions to maximize scalability, flexibility, and performance. For more information about custom sharding, see Scaling Out Azure SQL Databases.

See Also

© 2015 Microsoft