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.

Anonymous

My feedback

  1. 7 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

    1 comment  ·  Azure Synapse Analytics » SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Anonymous commented  · 

    This is a big opportunity to design more efficiently in Synapse, if you are designing a traditional data warehouse with surrogate keys (via Identity columns) you are extremely limited in design. Ideally you would distribute on something like a PRODUCT_SKEY but if this is an identity you can’t so this only works with natural keys or composite keys.

    Anonymous supported this idea  · 
  2. 10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
  3. 121 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 Synapse Analytics » SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Anonymous commented  · 

    I agree that what is being requested doesn't work with MPP architecture. It sounds like MSFT is working on the feature to have a multi column HASH distribution which will not actually solve what is being requested. If you have a multi column HASH, data from other tables will only co-locate when their hash key is the same set of columns,

  4. 705 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    We are very excited to announce the public preview of Azure Data Factory Managed Virtual Network.

    With this new feature, you can provision the Azure Integration Runtime in Managed Virtual Network and leverage Private Endpoints to securely connect to supported data stores. Your data traffic between Azure Data Factory Managed Virtual Network and data stores goes through Azure Private Link which provides secured connectivity and eliminate your data exposure to the public internet. With the Managed Virtual Network along with Private Endpoints, you can also offload the burden of managing virtual network to Azure Data Factory and protect against the data exfiltration.

    To learn more about Azure Data Factory Managed Virtual Network, see https://azure.microsoft.com/blog/azure-data-factory-managed-virtual-network/

  5. 66 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

    under review  ·  5 comments  ·  Azure Synapse Analytics » SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  6. 108 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

    under review  ·  6 comments  ·  Azure Synapse Analytics » SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  7. 505 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

    36 comments  ·  Azure Synapse Analytics » SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  8. 725 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Anonymous commented  · 

    although the workaround may work for ms sql, the lookup task does not work with Oracle if you want to add a something like an ALTER USER. I want to

    Anonymous supported this idea  · 
  9. 3 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 Key Vault » Managing application secrets  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared this idea  · 
  10. 175 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

    under review  ·  9 comments  ·  Azure Synapse Analytics » SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  11. 5 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/Management  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared this idea  · 
  12. 172 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

    8 comments  ·  Azure Synapse Analytics » SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  13. 134 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

    under review  ·  6 comments  ·  Azure Synapse Analytics » SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
    An error occurred while saving the comment
    Anonymous commented  · 

    this is a problem... need @@ROWCOUNT

  14. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared this idea  · 
  15. 378 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  16. 272 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  4 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  17. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared this idea  · 
  18. 1 vote

    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  ·  Data Catalog » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared this idea  · 
  19. 161 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

    planned  ·  2 comments  ·  Data Catalog » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  20. 400 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

    under review  ·  22 comments  ·  Data Catalog » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

Feedback and Knowledge Base