Yitzhak

My feedback

  1. 189 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    32 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Yitzhak commented  · 

    Here is one of the prominent examples what we are facing from the www.stackoverflow.com:

    Convert nested XML via XQuery to flat xml
    https://stackoverflow.com/questions/58080659/convert-nested-xml-via-xquery-to-flat-xml

    An error occurred while saving the comment
    Yitzhak commented  · 

    Just relational is not enough today.
    Many applications today need both relational and not relational data model/functionality in the same application.

    An error occurred while saving the comment
    Yitzhak commented  · 

    The situation is even worse than I initially thought.
    SQL Server is stuck at the 2004 (15 years old) preliminary draft version of the XQuery 1.0 standard.

    Here is an excerpt from the XQuery Language Reference (SQL Server).

    "...Transact-SQL supports a subset of the XQuery language that is used for querying the
    xml data type. This XQuery implementation is aligned with the July 2004 Working Draft
    of XQuery. The language is under development by the World Wide Web Consortium
    (W3C), with the participation of all major database vendors and also Microsoft. Because
    the W3C specifications may undergo future revisions before becoming a W3C
    recommendation, this implementation may be different from the final recommendation..."

    Yitzhak supported this idea  · 
    Yitzhak shared this idea  · 
  2. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Logic Apps » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Yitzhak supported this idea  · 
  3. 524 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  21 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Yitzhak commented  · 

    ADF is badly missing SSIS Source Adapter functionality, non-existent SSIS Destination (Sink in ADF parlance), as well as XML Task functionality for XSLT transformation and XSD validation.

    Validate XML with the XML Task:
    https://docs.microsoft.com/en-us/sql/integration-services/control-flow/validate-xml-with-the-xml-task

    Yitzhak supported this idea  · 

Feedback and Knowledge Base