SQLXML

51 of 577 | XQJ Tutorial: Understanding the XQuery API for Java - The XQuery API for Java (<a href="http://www.xquery.com/tutorials/xqj_tutorial/">XQJ</a>), is currently under development through the Java Community ...

52 of 577 | The DBIS Group at University of Konstanz has released BaseX 4.0, an open source native XML database with a GUI frontend that supports most of XQuery 1.0 and some of XQuery Full-Text. - The DBIS Group at University of Konstanz has released BaseX 4.0, an open source native XML database with a GUI frontend that supports most of XQuery 1.0 and some of XQuery Full-Text. It seems to be written in java so one presumes its platform independent....

53 of 577 | On the last day of the year, IBM developerWorks has published my look back at 2007 in the world of XML: XML 2007 Year in review. - On the last day of the year, IBM developerWorks has published my look back at 2007 in the world of XML: XML 2007 Year in review. Between XQuery, Atom, OpenDoc, and OOXML, 2007 was actually probably the most exciting year we've had since the dot bomb. I think we're finally heading up the second bump of a classic double bump adoption curve....

54 of 577 | SQL Server Unattended Install Script - Here is a SQL Server Unattended Install Script I wrote last week... was nice to get it working finally!!!   ;the PIDKEY will show up in greyed out text boxes during a MANUAL Install... use this for the PIDKEY Parameter IF NECESSARY (probably not necessary) http://msdn2.microsoft.com/en-us/library/ms144259.aspx#pidkey;create a directory c:\binaries;create a directory c:\data;run the silent install from your install directory (here the d drive):  ;V:\>Setup.exe /settings C:/setup.ini /qb  ; /qn is quiet mode, no GUI is displayed.; /qb is quiet mode, basic GUI information is displayed, no user interaction is required. Use /qb ;check for install errors: C:\Program Files\Micr......

55 of 577 | Dynamically Getting Namespaces in an XML - I have a utility that process XML files, ideally, I would like to be able to feed XQueries into the application, the problem was, the xml files have namespaces. So far, all examples on how to use XQuery with XmlNamespaceManager requires hard coded namespace, that means I need to know the URI and the prefix. Well, I would like to be able to dynamically get the namespaces. I came up with this solution, this method will return an instance of XmlNamespaceManager with a specified XmlNameTable. Unfortunately, XPath 1.0 does not support default namespace, the default namespace will have 'default' prefix. using System.Xml; using System.Xml.XPath; /// <summary> /// Returns an instance o......

56 of 577 | Version 2.0 of XQilla, an open source XQuery 1.0 and XPath 2.0 library and command line utility written in C++, has been released. - Version 2.0 of XQilla, an open source XQuery 1.0 and XPath 2.0 library and command line utility written in C++, has been released. Xqilla is implemented on top of Xerces-C++ and derives from Pathan. Version 2.0 implements the DOM 3 XPath API, and conforms to the both the XQuery and XPath 2.0 recommendations. It is now published under an Apache 2.0 licence....

57 of 577 | Handy SQL Delimited string to XML - I came across this simple yet great way of translating a delimited string to XML using SQL 2005. http://www.sqlservercentral.com/articles/XML/61618/   /* Here is the string that we need to split */ DECLARE @str VARCHAR(100) SET @str = '0001,0002,0003,0004,0005' /* I am converting the string to an XML structure by inserting XML tags. */ DECLARE @x XML SET @x = '<i>' + REPLACE(@str, ',', '</i><i>') + '</i>' /* Now we can apply XQuery to return a resultset */ SELECT x.i.value('.', 'VARCHAR(4)') AS Item  FROM @x.nodes('//i') x(i) /* Item ---- 0001 0002 0003 0004 0005 (5 row(s) affected) */ _qacct="p-03-ZsKAm7O3lI";quantserve(); ...

58 of 577 | Wrap the Result of an XQuery Query into an XML Document - Wrapping the result of an XQuery query into an XML document is very useful if you're working with atomic values....

59 of 577 | ETH Zurich has posted MXQuery 0.4.1, an open source (Apache 2.0) XQuery engine written in Java. - ETH Zurich has posted MXQuery 0.4.1, an open source (Apache 2.0) XQuery engine written in Java. It supports XQuery 1.0 (though typeless), XQueryP, FORSEQ, and XQuery Update. Version 0.4.1 fixes bugs, adds more functions and operators, and can now pass about 95% of the test suite....

60 of 577 | Michael Kay has released version 9.0.0.2 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. - Michael Kay has released version 9.0.0.2 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. This is a bug fix release. According to Kay, "Although Saxon 9.0.0.1 is proving very reliable, this maintenance release was necessary because Saxon-SA 9.0.0.1 was inadvertently compiled using JDK 1.5 and will not run under JDK 1.4." More......

61 of 577 | XPath – the hidden language of BizTalk? - For those of you who are unaware, XPath is a powerful query language for XML (ignoring XQuery for now). In my experience I've worked with a lot of BizTalk developers who have come from a C# (and usually VB before that) background, and so haven't...(read more)...

62 of 577 | Mark Logic has published an XQuery based site for interacting with email archives. - Mark Logic has published an XQuery based site for interacting with email archives. According to Jason Hunter, "Each email is stored internally as an XML document and accessed using XQuery. All searches, faceted navigation, analytic calculations, and HTML page renderings are performed on a single MarkLogic Server machine." They're currently indexing 500 or so Apache mailing lists, jdom-interest, and xml-dev, among others....

63 of 577 | Chris Lovett Interview - Chris Lovett was interviewed by book author Michael van Otegem recently and he asked some very interesting questions: Please tell us who you are and what you do.I’m an architect on the Data Programmability Tools team in SQL Server, and I work on XML tools that ship in Visual Studio.  As an architect I do lots of different things including: product development on the XML editor in Visual Studio 2008; cross-group collaboration to make sure all our tools work together; playing with other concepts like XML Notepad; and thinking about and communicating our strategy and future directions for our technologies. How long have you worked for Microsoft and what did you do before your c......

64 of 577 | SQL XML Documentation - How to create and compile SQL XML Documentation comments....

65 of 577 | Michael Kay has released version 9.0 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. - Michael Kay has released version 9.0 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. This is a bug fix release. According to Kay, More......

66 of 577 | SyncroSoft has released 9.0, $345 payware XML editor written in Java. - SyncroSoft has released 9.0, $345 payware XML editor written in Java. Oxygen supports XML, XSL, DTDs, XQuery, SVG, Relax NG, Schematron, and the W3C XML Schema Language. According to the announcement, "The main feature of version 9.0 is a CSS-based visual XML editor allowing WYSIWYG-like editing of XML documents. With an innovative approach to XML authoring allows you to work with XML frameworks (DocBook, DITA, TEI, XHTML, etc) easier than ever before. Version 9 adds a new concept called Document Type that allows you to provide ready-to-use support for a framework or an XML language and share it with other users. This version also brings improved error reporting for validation against Rel......

67 of 577 | The Modis Team has released Sedna 2.2, an open source native XML database for Windows and Linux written in C++ and Scheme and published under the Apache License 2.0. - The Modis Team has released Sedna 2.2, an open source native XML database for Windows and Linux written in C++ and Scheme and published under the Apache License 2.0. Sedna supports XQuery and its own declarative update language. This release fixes bugs, adds XQuery triggers, and no longer requires root privileges to run on Linux. More......

68 of 577 | I've posted the notes from last night's Native XML Databases presentation at the New York PHP User's Group monthly meeting. - I've posted the notes from last night's Native XML Databases presentation at the New York PHP User's Group monthly meeting. It was an active and inquiring audience, which is always fun; so we only got through the first 30 or so slides. I didn't really have time to go into the details of XQuery. There was also a tangent on REST and proper URL and web application design, we couldn't really explore fully. Maybe next time. More......

69 of 577 | Update on SQL PASS 2007 Presentations - I am giving 3 presentations at SQL PASS 2007 in Denver: Wednesday, September 19th, 9:45am to 11am, room 709: DBA-317-M The Next Release of Microsoft SQL Server: Beyond Relational (co-presenting with Kevin Farlee) Main focus will be the new features in the areas of unstructured and semistructured data management in SQL Server 2008. Wednesday, September 19th, 1:30pm to 2:45pm, room 709: AD-407-M Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems & Best Practice Solutions This is the same presentation I gave at TechEd 2007, a bit shortened to fit into the timeslot. Focus is on SQL Server 2005 XQuery and XML optimizations, however they also will apply t......

70 of 577 | XQuery and Data TEST - In his most recent column Kurt Cagle explains the utility of XQuery for increased data abstraction and why XQuery is XPath plus some useful missing bits....

71 of 577 | XQuery and Data Abstraction - In his most recent column Kurt Cagle explains the utility of XQuery for increased data abstraction and why XQuery is XPath plus some useful missing bits....

72 of 577 | [Oleg Tkachenko:XInclude.NET] Using XInclude.NET and Saxon on .NET Together - Signs on the Sand: Saxon, NET and XInclude Saxon, famous XSLT 2.0 and XQuery processor, supports XInclude since version 8.9. But in Java version only! When I first heard about it I thought "I have good XInclude implementation for .NET......

73 of 577 | Saxon, NET and XInclude - Saxon, famous XSLT 2.0 and XQuery processor, supports XInclude since version 8.9. But in Java version only! When I first heard about it I thought "I have good XInclude implementation for .NET in Mvp.Xml library, let's check out if Saxon on .NET works with XInclude.NET". I did some testing only to find out that they didn't play well together.  Turned out Saxon (or JAXP port to .NET, don't remember) relies on somewhat rarely used in .NET XmlReader.GetAttribute(int) method (yes, accessing attribute by index), and XIncludingReader had a bug in this method. Finally I fixed it and so XIncludingReader from recently released Mvp.Xml library v2.3 works fine with Sa......

74 of 577 | XQuery, the Server Language - Kurt Cagle offers an interesting perspective on the future utility of XQuery as a server-side development language....

75 of 577 | SQL Server 2008 June CTP has been annouced at TechEd 2007 - At today's TechEd 2007 in Orlando, we have annouced SQL Server 2008's, formerly known as Katmai, first community tech preview (CTP). Unlike SQL Server 2005, where we took over 5 years, SQL Server 2008 will be delivered in less than 3! See here for the official scoop and register here! What does this bring for XML Support and other interesting programmability support, you may ask. Well, we are doing a bit of XML (not quiet as much as you may would have liked, but we need to also invest in other areas ;-) ), added a new MERGE statement, finally added some more usable date and time datatypes, work on adding support for spatial datatypes and indexing and a slew of other interesting, cool featu......

76 of 577 | SQL Server 2008 June CTP has been annouced at TechEd 2007. - At today's TechEd 2007 in Orlando, we have annouced SQL Server 2008's, formerly known as Katmai, first community tech preview (CTP). Unlike SQL Server 2005, where we took over 5 years, SQL Server 2008 will be delivered in less than 3! See here for the official scoop and register here!. What does this bring for XML Support and other interesting programmability support, you may ask. Well, we are doing a bit of XML (not quiet as much as you may would have liked, but we need to also invest in other areas ;-) ), added a new MERGE statement, finally added some more usable date and time datatypes, work on adding support for spatial datatypes and indexing and a slew of other interes......

77 of 577 | SQL Server 2008 June CTP has been annouced at TechEd 2007. - At today's TechEd 2007 in Orlando, we have annouced SQL Server 2008's, formerly known as Katmai, first community tech preview (CTP). Unlike SQL Server 2005, where we took over 5 years, SQL Server 2008 will be delivered in less than 3! See here for the official scoop and register here!. What does this bring for XML Support and other interesting programmability support, you may ask. Well, we are doing a bit of XML (not quiet as much as you may would have liked, but we need to also invest in other areas ;-) ), added a new MERGE statement, finally added some more usable date and time datatypes, work on adding support for spatial datatypes and indexing and a slew of other interes......

78 of 577 | Erik Meijer on LINQ, XML, and the future at XTech 2007 - Erik Meijer gave a talk at the XTech 2007 conference on LINQ, XML, and his vision for "LINQ 2.0". The presentation covers the formal underpinnings of LINQ to XML, the additional XML features in VB9, and some thoughts about the next steps. To summarize, LINQ 1.0 provided the necessary (but not sufficient) technology for radically simplifying distributed data-intensive applications. With LINQ 2.0 we use will take things to the next level by stretching the standard .NET programming model to cover the Cloud. Jeni Tennison has an interested-but-skeptical review.  She definitely understands the most fundamental point of LINQ: "A big distinction between previous attempts to work acro......

79 of 577 | Elsevier has released xqdoc, an open source "automated documentation tool for XQuery". - Elsevier has released xqdoc, an open source "automated documentation tool for XQuery". Supported engines include MarkLogic, eXist, and Saxon. xqdoc is published under the Apache 2.0 license. Java 1.4 or later is required....

80 of 577 | Request for Feedback: Usage of xs:date and xs:dateTime and negative dates in SQL Server XML Schema Collections - Hi all SQL Server and XML enthusiasts!As part of the next version of SQL Server, we have to stop supporting negative years in the two types xs:dateTime and xs:date in the XML data type for reasons I currently cannot go into details. The SQL Server product team would like your help in deciding on what upgrade experience is acceptable. We would appreciate if you could do the following if you are storing XML in your database that is constrained with an XML schema collection (if you have customers, we would love to hear from their databases, but please ask them first whether you can run the script): Consider the three upgrade options: Database upgrade without size of data upgrade, aff......

81 of 577 | Request for Feedback: Usage of xs:date and xs:dateTime and negative dates in SQL Server XML Schema Collections - Hi all SQL Server and XML enthusiasts!As part of the next version of SQL Server, we have to stop supporting negative years in the two types xs:dateTime and xs:date in the XML data type for reasons I currently cannot go into details. The SQL Server product team would like your help in deciding on what upgrade experience is acceptable. We would appreciate if you could do the following if you are storing XML in your database that is constrained with an XML schema collection (if you have customers, we would love to hear from their databases, but please ask them first whether you can run the script): Consider the three upgrade options: Database upgrade without size of data upgrade, aff......

82 of 577 | Accelerating Evolution: LINQ News from Mix 2007 - There is a lot of interesting (and once confidential) stuff that came out of the Mix conference this week. Jon Udell's  "Watching Anders Hejlsberg reinvent the relationship between programs and data" ... offers an enthusiastic summary: A lot of the time, when we use the web, we’re effectively performing joins among data sources. You visit one site to look up some data, then you grab some of it and plug it into another site. If you’re lucky, somebody will have built a mashup, on a third site, to facilitate that join. But what if your browser had the data manipulation chops to help you do that mashup directly? I’m hoping that technologies like Silverlight and LINQ will enable thing......

83 of 577 | XSLT 2.0, XPath 2.0, XQuery and WSDL Support in XMLSpy 2007 - I've always been a fan of Altova's XMLSpy and have used it since it was first released.  Their release of XMLSpy 2007 doesn't disappoint as it adds support for several things that are of particular interest to me such as XSLT 2.0 and XPath 2.0, XQuery and enhanced WSDL editing.  It of course adds many more features which you can learn about at http://www.altova.com/products/xmlspy/xml_editor.html.The intergrated XQuery editor simplifies writing queries since it offers intellisense, access to different XQuery language keywords, a debugger, plus more.  Here's an example some of the intellisense you get while working with XQuery queries: The XSLT 2.0 ed......

84 of 577 | 13 Apr 2007 - North Carolina — I've got meetings next week hosted by Red Hat in Raleigh. A participant in the W3C XML Query Working Group recently changed affiliations, and I'm hoping that we'll see Red Hat get a little more involved in some of the "enterprise-level" XML stuff that's going on. There are a number of open source XQuery implementations that are pretty good, by the way. Maybe I'll also get a chance to take some photos. Any student willing to have his ankles photographed, let me know :-) loui, I always liked Pat Lashley's MonaEyes program on NeWS -- it was the Mona Lisa painting, but the eyes followed the screen pointer. But you're right, the motor-driven xeyes is e......

85 of 577 | Declare the Coolest XQuery Variables - This tip shows how to declare some important variables in XQuery. ...

86 of 577 | Notes: XML Query Requirements and Use Cases - 2007-03-23: The XML Query Working Group published two Working Group Notes, XML Query (XQuery) Requirements and XML Query Use Cases. The documents are a record of the development of XQuery and its associated specifications. Part of the XML family, the Recommendations are used for data mining, document transformation, and enterprise computing. Visit the XML home page. (Permalink)...

87 of 577 | XQuery Scripting Extension and Version 1.1 Requirements: Working Drafts - 2007-03-23: Responding to requests from Working Group participants and the wider community, the XML Query Working Group released two First Public Working Drafts. XQuery Scripting Extension 1.0 Requirements describes goals and requirements for making XQuery 1.0 functional as a scripting language. XML Query (XQuery) 1.1 Requirements describes compatibility and functionality requirements for extending XML Query 1.0. Visit the XML home page. (Permalink)...

88 of 577 | [Announce] Planet.XSLTransformations.com Now Live - http://planet.xsltransformations.com/ [feed, opml] I'm still busy adding feeds from folks in whom most definitely provide value to those with interest in XSLT and/or similar technologies such as XQuery and LINQ. I was going to hold off from announcing this until......

89 of 577 | Abel Braaksma has launched X*X*X Wiki, a wiki for XSLT, XPath and XQuery. - Abel Braaksma has launched X*X*X Wiki, a wiki for XSLT, XPath and XQuery. There's very little useful content there now, but it can be added....

90 of 577 | Florent Georges has released XTS, a set of open source stylesheets that forms a unit testing framework for XSLT 2 and XQuery. - Florent Georges has released XTS, a set of open source stylesheets that forms a unit testing framework for XSLT 2 and XQuery....

91 of 577 | Oracle has released Berkeley DB XML 2.3.10, an open source "application-specific, embedded data manager for native XML data" based on Berkeley DB. - Oracle has released Berkeley DB XML 2.3.10, an open source "application-specific, embedded data manager for native XML data" based on Berkeley DB. It supports the recent proposed recommendations of XQuery 1.0 and XPath 2.0. It includes C++, Java, Perl, Python, TCL and PHP APIs. According to the announcement, This release of Berkeley DB XML fixes bugs. Berkeley DB XML is published under a custom, viral license that is compatible with most major open source licenses....

92 of 577 | Michael Kay has released version 8.9 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. - Michael Kay has released version 8.9 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. Saxon can now compile a query to Java source code. It includes a Saxon specific Ant task. This release also adds support for XInclude. More......

93 of 577 | Saxon 8.9 Now Available - via the front page of Saxonica.com, we learn, Saxon 8.9 is now available. The most exciting feature of this release is that XQuery queries can now be translated directly into Java source code, reducing execution time by anything from 25%......

94 of 577 | Request-for-Comment: Should MSFT Implement Support for XQuery 1.0 Over Stand Alone Xml Documents? - In a recent post to the MSFT XML Team Weblog, Dr. Michael Rys writes, Microsoft XML Team's WebLog : Standalone XQuery Implementation in .NET? We very much wish to hear from our user community about their requirements that could be......

95 of 577 | The XML Team is asking for feedback for XQuery in .Net - Now that the W3C XQuery recommendation has been released, the XML Team, owners of MSXML and System.XML, are asking for feedback on a standalone XQuery implementation in .Net. If you have any opinion, wishes or use cases, please head over and let them know about it....

96 of 577 | The XML Team is asking for feedback for XQuery in .Net - Now that the W3C XQuery recommendation has been released, the XML Team, owners of MSXML and System.XML, are asking for feedback on a standalone XQuery implementation in .Net. If you have any opinion, wishes or use cases, please head over and let them know about it....

97 of 577 | Standalone XQuery Implementation in .NET? - XQuery 1.0 and XPath 2.0 are now W3C Recommendations, thanks in part to the contributions of  several Microsoft employees over the years. An earlier draft of the XQuery specification is supported in SQL Server 2005 , and you can send an XQuery to the server using the ADO.NET that shipped in Visual Studio 2005.  These features are becoming widely used.    Now that the XQuery family of specifications is complete, it’s fair to ask what our implementation plans might be,  We had been working on an implementation of XQuery in the .NET Framework that operated over standalone XmlDocuments several years ago, and showed the work in progress in the first beta of what b......

98 of 577 | Generating XML entity references (&foo;) with XSLT: XSLT 2.0 to the rescue - Here is a problem: XSLT 1.0 sucks on generating XML character or entity references. I mean getting &foo; out of XSLT 1.0 is hard. The only ugly solution is disable-output-escaping hack, but it's a) optional, b)doesn't work in all scenarios (only when XSLT engine controls output serialization into bytes and c) works only on text nodes. Latter is real showstopper - you can't generate character or entity reference in attribute using XSLT 1.0. But now that we have XSLT 2.0, which is oh so better. What's XSLT 2.0 solution for the problem? In XSLT 2.0 disable-output-escaping is deprecated. New facility for the problem is called Character Maps.......

99 of 577 | Serving SQL XML through a WebService (SQL2005) - How to server XML from SQL2005 through a WebService...

100 of 577 | Per Bothner has released Qexo 1.9.1, an XQuery to Java byte code compiler. - Per Bothner has released Qexo 1.9.1, an XQuery to Java byte code compiler. Qexo is published under the X11/MIT license....