Documentation for Azure SQL is not consistent amongst various tools RRS feed

  • Question

  • Please refer to this Twitter thread:


    The list of editions for SQL DBs don't match up in these 3 docs: https://goo.gl/ARqx9J , https://goo.gl/T6ThzN  & https://goo.gl/N92Lhr  . 


    T-SQL says: Basic, Standard & Premium. No PremiumRS.
    PowerShell (New-AzureRmSqlDatabase) says: Default, None, Premium, Basic, Standard, DataWarehouse
    'az sql db list-editions' says: Free, Basic, Standard, Premium, DataWarehouse, Stretch

    • Moved by Sheethal J S Tuesday, March 27, 2018 2:59 AM Best Suited Here
    Monday, March 26, 2018 9:55 PM

All replies

  • Hello,

    SQL Azure Database has evolved over the years. Due to customer feedback some tiers no longer exist like PremiunRS. Please also note that each edition has many service objectives, for example Standard Edition has service objectives like S0, S1, S2.

    SQL Azure Data Warehouse is considered a different Azure feature/product. It has its own tiers.

    Hope this helps.


    Alberto Morillo

    Tuesday, March 27, 2018 5:20 AM
  • Thanks for your reply Alberto.

    My main issue is consistency in the documentation. For example, what you've mentioned isn't clear in the docs.

    I'd just like to be able to trust the docs and not have to piece together what's correct/incorrect.


    Friday, March 30, 2018 2:26 PM
  • I'd just make a small editorial comment that SQL Server has long been one of the best documented product Microsoft has ever had, and with the DMVs it even surfaces a lot of internal information.

    Azure in general, and Azure SQL in particular, has not even attempted to meet the same high standards.  It's inspired (apparently) by different technical cultures in which it is a mark of virtue to supply only the most minimal documentation, apparently in the hope that eager third parties will do it instead.

    I've always preferred it when product documentation comes from the organization that created, sells, and supports it, but then these support groups are really third-party mechanisms and I like these too!


    Saturday, March 31, 2018 4:39 PM