Was deze pagina nuttig?
Uw feedback over deze inhoud is belangrijk. Laat ons weten wat u denkt.
Aanvullende feedback?
1500 tekens resterend
Exporteren (0) Afdrukken
Alles uitvouwen
Deze inhoud is niet beschikbaar in uw taal, maar wel in het Engels.

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