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.

Jason Horner

My feedback

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

    11 comments  ·  Azure Synapse Analytics » SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
    Jason Horner supported this idea  · 
    An error occurred while saving the comment
    Jason Horner commented  · 

    COPY INTO Should support this behavior as well it would be super useful or at least return this as output in a resultset

  2. 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  ·  Azure Synapse Analytics » Workspace/Other  ·  Flag idea as inappropriate…  ·  Admin →
    Jason Horner shared this idea  · 
  3. 41 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  ·  0 comments  ·  Azure Synapse Analytics » SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
    Jason Horner supported this idea  · 
  4. 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

    7 comments  ·  Azure Synapse Analytics » Workspace/Spark  ·  Flag idea as inappropriate…  ·  Admin →
    Jason Horner shared this idea  · 
  5. 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

    1 comment  ·  Azure Synapse Analytics » Workspace/Spark  ·  Flag idea as inappropriate…  ·  Admin →
    Jason Horner shared this idea  · 
  6. 199 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  ·  Flag idea as inappropriate…  ·  Admin →
    Jason Horner supported this idea  · 
  7. 181 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 →
    Jason Horner supported this idea  · 
  8. 681 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

    30 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 72

    <=-=Mar 10 2016 11:26AM=-=>

    It’s a shame that this was submitted as just a “suggestion”. It should actually be listed as a “bug” because there’s only a comparatively small set of use cases where enumeration of the result set of elements is not important.

    <=-=Mar 11 2016 12:47PM=-=>

    I agree that an order column is required; one example use case is where two lists are passed in, and ordinal positions in one list correspond to positions in the other.

    <=-=Mar 11 2016 3:12PM=-=>

    Please see the related suggestion: STRING_SPLIT needs “RemoveEmptyEntries” option, like String.Split in .NET ( https://connect.microsoft.com/SQLServer/feedback/details/2462002/ ).

    <=-=Mar 12 2016 12:02PM=-=>

    This kind of function is primarily needed for de-serializing previously serialized arrays of values of any type format-able as text.
    I therefore recommend to have the result set of this function work excellent with this use-case.

    With de-serialized arrays there is a need to…

    An error occurred while saving the comment
    Jason Horner commented  · 

    Another point and perhaps the larger issue here is that with the removal of CLR support for Azure SQL DB, Users no longer have the means to custom implement this type of functionality via CLR routines.

    The SQL Server feature surface area is sadly lacking several features common in other platforms. by not providing developers viable options to extend functionality within Azure SQL DB:

    Advanced JSON Parsing and manipulation
    POSIX Regular expresion support
    Advanced spatial operations

    Databases like PostgreSQL and Oracle are light years ahead of SQL Server in these areas and to be honest the other engines have had these features for several years. It's time for the SQL Server team to get serious about improving the developer experience with effcient operators for these types of workloads.

    Jason Horner supported this idea  · 
  9. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    Ideally, this would be implemented as an option to include parent resource definition.

    Jason Horner supported this idea  · 
  10. 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 →
    Jason Horner shared this idea  · 
  11. 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  ·  Azure Resource Manager » Azure Deployment Manager  ·  Flag idea as inappropriate…  ·  Admin →
    Jason Horner shared this idea  · 

Feedback and Knowledge Base