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.

Shannon Lowder

My feedback

  1. 32 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  ·  SQL Data Sync  ·  Flag idea as inappropriate…  ·  Admin →
    Shannon Lowder supported this idea  · 
    An error occurred while saving the comment
    Shannon Lowder commented  · 

    I'd also like to add GEOGRAPHY to this list. I can't sync my database due to the following error:
    Database provisioning failed with the exception "Column 'GeographyDefinition' in table 'dbo.GPSData' is of a type that is invalid for use as a key column in an index or statistics.
    Inner exception: SqlException Error Code: -2146232060 - SqlError Number:1978, Message: Column 'GeographyDefinition' in table 'dbo.GPSData' is of a type that is invalid for use as a key column in an index or statistics.
    "

    For more information, provide tracing id ‘f89f858b-ae87-4053-ba69-13174c88e20b’ to customer support.

  2. 36 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  3 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Shannon Lowder commented  · 

    Right now I have to run an on-prem sql server with SSIS to perform the data loads. I'd like an option to host this in Azure.

    Shannon Lowder supported this idea  · 
  3. 41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Data Sync  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Shirley Wang responded

    Given that most Windows Azure SQL Database customers are now advised to use with custom sharding pattern for scale-out, we are re-evaluating when you would want to use sync for a sharded environment – is it syncing from on-prem SQL Server to multiple shards in the cloud, synchronizing between the shards in the cloud, or syncing from multiple shards down to on-prem SQL Server? We’d appreciate your input on this.

    Shannon Lowder supported this idea  · 
    An error occurred while saving the comment
    Shannon Lowder commented  · 

    I'd also like to see data sync between two federated database instances. That way I can set up a multi-region availabiltiy group.

  4. 21 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  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Shannon Lowder supported this idea  · 

Feedback and Knowledge Base