SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » XML (RSS)

Browse by Tags

  • SQL Azure Federations and Semantic Search by the SQL product team in London tonight (Monday)

    Don’t forget that tonight we have Michael Rys from the SQL Server Product Team presenting on the Federation support coming to SQL Azure and the Semantic search coming in SQL Server Denali. This is a must attend evening for anyone that is serious about scaling SQL or doing search in SQL Server. Michael...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jun 13 2011
  • Working with large XML files in Management Studio

    Have you ever tried to generate a large XML file using FOR XML and then found Management Studio die when you try and look at the whole XML document (probably so you can save it). Well the issue is that normally ALL elements and attributes are generated on ONE line. This means that if you generate a moderately...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, May 5 2011
  • Performance problems loading XML with SSIS, an alternative way!

    I recently needed to load several thousand XML files into a SQL database, I created an SSIS package which was created as followed: Using a foreach container to loop through a directory and load each file path into a variable, the “Import XML” dataflow would then load each XML file into a SQL table. Running...
    Posted to Atul Thakor (Weblog) by AtulThakor on Wed, Feb 2 2011
  • Using XML Schemas

    A few weeks ago someone asked how to load XML schemas from a file. I thought I’d previously blogged about this, but upon checking the only place I found it was in a presentations I gave when SQL 2005 was released… so I thought it was about time I posted something! First lets get an example of an XML...
    Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Mon, Nov 8 2010
  • SSIS - XML Source Script

    The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 11 2010
  • Generating surrogate keys with xquery

    Saving a hierarchy of data from an XML document into a set of tables is a problem when the only relationship between nodes in the hierarchy is the position of the node. SQL doesn't like implied things like this. It likes things to be explicit. This means that when you save the child nodes you are...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Feb 25 2010
  • formatting xml files in visual studio

    This is not strictly a sql post, but it is to do with xml which is used in sql server. xml files do not need to have any formatting in them. That means that when viewing an xml file produced by an application, all the data can be one line. Although this is valid xml and can be processed by sql server...
    Posted to Anthony Brown (Weblog) by antxxxx on Tue, Feb 23 2010
  • XML Validation in SQL Server Intergration Services

    I've been workig with XML in SQL Server Integration services this week and to say the XML task in SQL Server Integration services sucks is an understatement. Its buggy, the documentation is woefully inadequate in some cases wrong. I believe this was one of the first components written back for SQL...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jan 20 2010
  • XML Schema Collection in Database Professional Project

    If you are wanting to use schemas in your database using database professional then it is not that obvious. You can add XML SCHEMA COLLECTIONs but where do they do to. They are tuck away in the programability node under types, not the most obvious location. Secondly if you create schemas using the ADD...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jan 14 2010
  • "unable to switch the encoding" when deploying XML Schemas using Database Professional

    I've just blogeed about how to use XML Schema Collections in Visual Studio Database Professional Project I mentioned there is one gotcha about. The gotcha is if you have UTF-8 encoded schemas then they fail to be deployed. This is because they get deployed using CREATE XML SCHEMA COLLECTION [dbo...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jan 14 2010
Page 1 of 2 (20 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems