Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Simon D'Morias

My feedback

  1. 12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure Synapse Analytics » Workspace/Pipelines  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias shared this idea  · 
  2. 36 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Azure Synapse Analytics » SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for the feedback folks. For now, you can use Alter Index reorganize as the online operation when rebuilding your CCI . We will reach out when this is on our roadmap. Please describe your scenario for this capability below and continue to vote. Thanks for your patience.

    An error occurred while saving the comment
    Simon D'Morias commented  · 

    With very wide tables Synapse is painfully slow (unusable) if the CCI is not in perfect condition.
    I would really like to be able to do (assuming RCSI enabled):

    BEGIN TRANSACTION
    DELETE SOMEDATA
    INSERT SOMEDATA
    ALTER TABLE X REBUILD ALL PARTITION Y
    COMMIT TRANSACTION

    This way I'm 100% online. MS tend to push the CTAS/Partition Swap route - but two issues. One this requires a schema lock - when using DQ from PowerBI this is none starter. Two it is painfully slow for reloading smaller chunks of data in large partitions

    Simon D'Morias supported this idea  · 
  3. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure Synapse Analytics » SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias supported this idea  · 
  4. 153 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Azure Synapse Analytics » SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Simon D'Morias commented  · 

    A local emulator would be very nice for basic coding.

  5. 6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias supported this idea  · 
  6. 38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Networking » Virtual Network  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias supported this idea  · 
  7. 68 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Azure Databricks  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Simon D'Morias commented  · 

    Use VSCode and Databricks Connect to do this. https://docs.azuredatabricks.net/user-guide/dev-tools/db-connect.html Technically should work in fulll Visual Studio as well using a Python project.

  8. 132 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Azure Databricks  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Simon D'Morias commented  · 

    This is already possible using Databricks Connect. https://docs.azuredatabricks.net/user-guide/dev-tools/db-connect.html

    An error occurred while saving the comment
    Simon D'Morias commented  · 

    I'd like to be able to debug pyspark from VSCode against a databricks cluster.
    I know with IntelliJ you debug scala against HDInsight/Spark clusters - can we bring this sort of interaction to VSCode for Databricks?

    Simon D'Morias supported this idea  · 
  9. 564 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    14 comments  ·  Security and Compliance  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Anonymous responded

    Thank you for this suggestion! It has been escalated to the Windows Azure engineering team for further evaluation. We will post here to gather additional information as-appropriate.

    Simon D'Morias supported this idea  · 
  10. 1,988 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    91 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →

    Great news – static IP range for Azure Integration Runtime is now available in all ADF regions! You can whitelist specific IP ranges for ADF as part of firewall rules. The IPs are documented here: https://docs.microsoft.com/en-us/azure/data-factory/azure-integration-runtime-ip-addresses#azure-integration-runtime-ip-addresses-specific-regions. Static IP ranges for gov cloud and China cloud will be published soon!

    Please refer to this blog post on how you can use various mechanisms including trusted Azure service and static IP to secure data access through ADF:
    https://techcommunity.microsoft.com/t5/azure-data-factory/azure-data-factory-now-supports-static-ip-address-ranges/ba-p/1117508

    Service tag support will be made available in next few weeks. Please stay tuned!

    If your network security requirement calls for ADF support for VNet and cannot be met using Trusted Azure service (released in Oct 2019), static IP range (released in Jan 2020), or service tag (upcoming), please vote for VNet feature here: https://feedback.azure.com/forums/270578-data-factory/suggestions/37105363-data-factory-should-be-able-to-use-vnet-without-re

  11. 26 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Azure Databricks  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias supported this idea  · 
  12. 33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias shared this idea  · 
  13. 1,528 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    57 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias supported this idea  · 
  14. 201 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  Azure Databricks  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias supported this idea  · 
  15. 28 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
    Simon D'Morias supported this idea  · 
  16. 1,282 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    46 comments  ·  HDInsight » Platform  ·  Flag idea as inappropriate…  ·  Admin →

    [Update] Thanks for your continued feedback on this capability! Rest assured that we are tracking this request closely along with several other platform capabilities our customers have requested. In the meanwhile, you can leverage cluster scaling capability to adjust HDInsight cluster size according to your varying compute needs. Azure Data Factory is another option you can explore for scheduling jobs with automatic creation and deletion of clusters: https://azure.microsoft.com/en-us/documentation/articles/data-factory-data-transformation-activities/

    Adnan Ijaz
    Program Manager
    Microsoft Azure HDInsight

    Simon D'Morias supported this idea  · 

Feedback and Knowledge Base