Madeira Data Solutions
  • Home

  • About Us

    • Our Team
    • Customers
    • Join Us
  • Managed Services

  • Professional Services

  • Training Services

  • Content Hub

    • Blog
    • Webinars
    • Podcast- SQL SERVER RADIO
  • More

    Use tab to navigate through the menu items.

    Contact Us

    • All Posts
    • SQL Server
    • Podcasts
    • PASS
    • SQL Server 2012
    • Big Data
    • Cloud
    • Scripts
    • Blog
    • DMV's
    • Learning
    • Performance
    • SQL Server 2012
    • Conferences
    • Cursors
    • Plan Cache
    • SQL Agent
    • SQL Azure
    • High Availability
    • Productivity
    • Downloads
    • SQL Server 2014
    • SQL Server 2016
    • Webcasts
    • Videos
    • Troubleshooting
    • SQL Server 2017
    • Tools
    • SQLServerPedia Syndication
    • Storage
    • TempDB
    Search
    Madeira Team
    • Sep 8, 2016
    • 1 min

    Recap of My 24HOP Session – From XML to JSON

    0
    Madeira Team
    • Sep 4, 2016
    • 5 min

    Why Would I Want to Use JSON in SQL Server?

    0
    Madeira Team
    • Feb 28, 2016
    • 1 min

    From XML to JSON – script

    0
    Madeira Team
    • Aug 1, 2012
    • 7 min

    Dynamic Search Queries versus SQL Injection

    0
    Madeira Team
    • Aug 5, 2010
    • 1 min

    Thirty Things You Didn’t Know About SQL Server

    0
    Madeira Team
    • Jan 31, 2010
    • 3 min

    Querying XML Using the Edge Table Format

    Recently I was asked by one of our customers about querying XML in a relational format. “Sure”, I answered, “you can use OPENXML to retrieve a relational representation of the XML”. For example, if the XML looks like this: XHTML <Customers>   <Customer Id="1" Name="Mickey Mouse">     <Order Number="12345" Date="2010-01-17"/>     <Order Number="23456" Date="2010-01-19"/>   </Customer>   <Customer Id="2" Name="Donald Duck">     <Order Number="34567" Date="2010-01-12"/>     <Ord

    0

    keep in Touch!

    JOIN OUR MAILING LIST

    CONTACT US

    4 Itzhak Ben Zvi, Hod-Ha'sharon, Israel 4537302

     +972-9-7400101

    info@madeiradata.com

    About Us
    Solutions
    Data Architecture Review
    DBSMART
    Database Health Check
    SQL Server Upgrade
    Join Us

    Privacy Policy

    • Google+ - White Circle
    • Facebook - White Circle
    • Twitter - White Circle
    • LinkedIn - White Circle