SQLXML

1 of 601 | Testing strings for equality counting trailing spaces - The SQL standard requires that string comparisons, effectively, pad the shorter string with space characters. This leads to the surprising result that N'' ? N' ' (the empty string equals a string of one or more space characters) and more generally any string equals another string if they differ only by trailing spaces. This can be a problem in some contexts. Unicode combining marks further complicate the issue because for many collations two distinct byte strings should compare as equal. For example, \u212b (Å) should be equal to \u0041 (A) + \u030a (combining ring above). There are a number of approaches to the problem that people have suggested but they all have flaws: 1.  &nb......

2 of 601 | TECH PASSION 1- Events with strong Microsoft student partners - Time Day 1: Fri, 20/02/2009 Day 2: Mon, 23/02/2009 Day 3: Wed, 25/02/2009 Day 4: Fri, 28/02/2009 02:00PM Welcome Welcome Welcome Welcome ......

3 of 601 | Updategram with multiple tables with foreign keys - Updategram Overview Since SQL Server 2000, updategrams along with OPENXML have been available to insert, update, or delete data using XML documents. An updategram works against the XML views that are provided by the annotated XSD schema that contains...(read more)...

4 of 601 | Building RESTful Services with XQuery and XRX - I've been banging on the RESTful services/XRX bandwagon for a while now, and the good folks at O'Reilly have kindly consented to let me get out the entire trap drum set for an O'Reilly Webinar entitled "Building RESTful Services with XQuery and XRX". ...

5 of 601 | Is It Time for an EXQuery.org? - For the most part, new EXQuery functions would simply represent wrappers around existing XQuery extension functionality in order to provide a consistent interface between databases. It would also set a bar that determines the minimal expectation of such databases and data systems and provides a way for new entrants into the field to be able to XQuery scripts without having to refactor code. ...

6 of 601 | Analysis 2009: XForms and XML-enabled clients gain traction with XQuery databases - I'm beginning to despair about XForms, which is perhaps a good sign. XForms is perhaps the oldest of the W3C technologies that has yet to either die completely or really dramatically take off, and for all that it has... ...

7 of 601 | Building RESTful Services with XQuery and XRX - I've been banging on the RESTful services/XRX bandwagon for a while now, and the good folks at O'Reilly have kindly consented to let me get out the entire trap drum set for an O'Reilly Webinar entitled "Building RESTful Services with XQuery and XRX". ...

8 of 601 | ?? ??? ?? ?? ?? ??? … - ?????, ??? ??? ???. ?? ??? ???? 2008? ??? ??? ??? ?? ???. ?? ???? ????? VS? ???? ? ? ??? ?? ??? ?? ???. ?? ?? C# IDE ???? C# IDE? ????? ????? ???. ?? ?? ?? ??? VS ??? WPF? ?????. ?? ?? ??? ?? VS? ??? ??? ?? ????, ??? ?? editor?? ?? shell, menu, toolbar ?? ? WPF? ??????. WPF? ???? ?? ??? ???? ?? ???? ?? ?? ?? ??? ???? data? visualize ??? ???? ??. ?? WPF ??? ?? ?? ?? ? ? ?? ???? ????? ?? ?? ? ??? ???? ???? ?? ??? ??? ?? ???. ? ?? ?? ???? ??. ?? ? ???? ?? ? ??? WPF ?? clear type ? zoom? ?? ?? ?????   ?? ?? C# IDE ? ??? ??? ???, ?? ?? C# 4.0? ? ???? COM interop ? dynamic ???. C# 1.0? C# ?? ??? ?????? ????? ? ??? 2.0? generics? ? ?? 3.0? Linq ??. ?? 4.0? ??? COM interop ? dynamic ? ????......

9 of 601 | Is It Time for an EXQuery.org? - For the most part, new EXQuery functions would simply represent wrappers around existing XQuery extension functionality in order to provide a consistent interface between databases. It would also set a bar that determines the minimal expectation of such databases and data systems and provides a way for new entrants into the field to be able to XQuery scripts without having to refactor code. ...

10 of 601 | Analysis 2009: XForms and XML-enabled clients gain traction with XQuery databases - I'm beginning to despair about XForms, which is perhaps a good sign. XForms is perhaps the oldest of the W3C technologies that has yet to either die completely or really dramatically take off, and for all that it has... ...

11 of 601 | Top 25 most dangerous programming errors - The paper “Top 25 Most Dangerous Programming Errors” (http://cwe.mitre.org/top25) is an interesting study of the families of programming errors that lead to security issues. The paper is based on input from a wide variety of security experts and is worth reading. The complete list of errors is at http://cwe.mitre.org/data/lists/699.html. From a T-SQL perspective, however, it seems off mark but the same group has a database of all the common weaknesses. Here is a list of Common SQL specific errors I was able to extract: ·         Access Control Bypass Through User-Controlled SQL Primary Key (http://cwe.mitre.org/data/definitions/566.html). · &n......

12 of 601 | OpenLink Releases Their Virtuoso ADO.NET Entity Framework Provider -   It is my pleasure to announce that OpenLink Software has released their Virtuoso ADO.NET Entity Framework provider - an ADO.NET 3.5 data provider compatible with Visual Studio 2008 and Entity Frameworks, that provides access to native Virtuoso data (SQL, XML, and RDF) in addition to any Virtuoso Linked Tables from external ODBC and JDBC accessible data sources. Known-compatible external data sources include Oracle (versions 7.x to 11.x), Microsoft SQL Server (6.x to 2005), IBM DB2 , Sybase (4.2 to 12.x+), IBM Informix (5.x to 11.x), Ingres (6.4 to 9.x), Progress (7.x to 10.x), MySQL, PostgreSQL, and Firebird.   For more information, see the OpenLink announcement page about ......

13 of 601 | Virtuoso – Entity Framework compatible ADO.NET provider - Now this is worth a mention. Kingsley has produced a ADO.NET provider for their virtuoso product which is Entity Framework compatible. Which means in theory access to SQL, XML and RDF data via the Entity Framework. It also supports a raft of third party databases, like Oracle, Informix, Progress etc etc. Now I haven’t tried this yet myself. But this one is definitely worth watching…...

14 of 601 | What Kind of Reports are Published / Which Use Custom Report Items? - As an administrator of a report server, you may occasionally ask yourself the question of what kind of reports are published in terms of their particular feature usage.  For example:   ·         Usage of Custom Report Items (CRIs)You plan to upgrade from RS 2005 to RS 2008 and there are CRI controls installed on your current RS 2005 server (look for a <ReportItems> section in rsReportServer.config)?  You may want to know whether they are actually referenced in any currently published reports on the server, because you may have read this related blog posting and are wondering if you need to install the 2005-based CRI controls on ......

15 of 601 | Is It Time for an EXQuery.org? - For the most part, new EXQuery functions would simply represent wrappers around existing XQuery extension functionality in order to provide a consistent interface between databases. It would also set a bar that determines the minimal expectation of such databases and data systems and provides a way for new entrants into the field to be able to XQuery scripts without having to refactor code. ...

16 of 601 | Version 2.2 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.2 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. "This release adds a debugger and debugging API, partial support for XSLT 2.0, and a prototype implementation of higher order functions for XQuery....Although it is possible to run a number of complex transformations there are significant features missing from the implementation, including xsl:include, xsl:import, xsl:output, xsl:result-document, and xsl:sort. If there are any developer......

17 of 601 | Analysis 2009: XForms and XML-enabled clients gain traction with XQuery databases - I'm beginning to despair about XForms, which is perhaps a good sign. XForms is perhaps the oldest of the W3C technologies that has yet to either die completely or really dramatically take off, and for all that it has... ...

18 of 601 | January's Toolbox Column Now Online - My Toolbox column in the January 2009 issue of MSDN Magazine is available online. The January issue examines: Script# - Script# is a utility created by Nikhil Kothari that translates C# code into JavaScript code, allowing you to create ASP.NET AJAX components and behaviors and Windows Vista Sidebar gadgets writing using a strongly-typed language (C#) with compile-time error checking, familiar OOP syntax and semantics, and better design-time tool support. Blogs of Note - Eric Lippert. Eric is a Senior Software Design Engineer at Microsoft. His blog offers some of the best in-depth looks at features in C#. He's also a very witty and talented writer, and has a knack for describing and illu......

19 of 601 | Michael Kay has released versions 9.1.0.5 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. - Michael Kay has released versions 9.1.0.5 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. This is a bug fix release. More......

20 of 601 | The W3C XQuery working group has published an updated working draft of XQuery 1.1 and XQuery 1.1 Use Cases. - The W3C XQuery working group has published an updated working draft of XQuery 1.1 and XQuery 1.1 Use Cases. New features since XQuery 1.0 include: More......

21 of 601 | The W3C XQuery working group has posted a new working draft of XQuery Scripting Extension 1.0 and XQuery Scripting Extension 1.0 Use Cases. - The W3C XQuery working group has posted a new working draft of XQuery Scripting Extension 1.0 and XQuery Scripting Extension 1.0 Use Cases: More......

22 of 601 | The Call for Papers for Balisage 2009 has been posted. - The Call for Papers for Balisage 2009 has been posted. "We welcome papers about topic maps, document modeling, markup of overlapping structures, ontologies, metadata, content management, and other markup-related topics at Balisage. If you want to talk, in detail XML, XSL, SGML, LMNL, XSL-FO, XTM, RDF, XQuery, Topic Maps, SVG, MathML OWL, UBL, XSD, TexMECS, RNG, or any other markup-related topic, we urge you to participate in Balisage." Paper Submissions are due by April 24. The conference takes place August 11-14. More......

23 of 601 | Five XQuery Drafts Published - 2008-12-05: The XML Query Working Group published five Working Drafts today relating to the XQuery language for querying and processing structured information:...

24 of 601 | XMLMind has released Qizx/db 2.2, a $600 closed source, embeddable native XML database engine and/or database server written in Java that supports XQuery 1.0. - XMLMind has released Qizx/db 2.2, a $600 closed source, embeddable native XML database engine and/or database server written in Java that supports XQuery 1.0. Version 2.2 adds support for XQuery 1.1 "group by" and "for ... window" clauses in FLWOR expressions. The query interpreter part is available under an open source license....

25 of 601 | Clinical & Biomedical Computing Ltd. - Clinical & Biomedical Computing Ltd. has released XQSharp 0.9, a free-as-in-beer XQuery processor for .NET platform. It includes a command line processor that can run ad-hoc queries against multiple files. According to Oliver Hallam, "Its API has been modelled closely on the System.XML.XPath classes and operates on the IXPathNavigable interface so fits in well with the rest of the framework classes. We aim to be releasing the API for free in the next release of the product. In the longer term we aim to release a Microsoft Visual Studio plugin allowing convenient editing and running of both ad-hoc and repeated-use queries."...

26 of 601 | SyncroSoft has released 10.0, $366 payware XML editor written in Java. - SyncroSoft has released 10.0, $366 payware XML editor written in Java. Oxygen supports XML, XSL, DTDs, XQuery, SVG, Relax NG, Schematron, and the W3C XML Schema Language. This feels like a fairly minor update with lots of small improvements rather than big new features. (That happens to most products after a few years if they're any good.) According to the announcement: More......

27 of 601 | Microsoft SQLXML 4.0 SP1 Released - As announced in the Data Platform Insider, the SQL Server 2008 Feature Pack has been released. This includes SQLXML 4.0 SP1, which provides support for the new date/time data types - some of the work that my team has been doing lately, all in the spirit of XML goodness. Enjoy!...

28 of 601 | Mulberry Technologies has announced the second annual Balisage: The Markup Conference, to take place in Montreal August 11-14, 2008. - Mulberry Technologies has announced the second annual Balisage: The Markup Conference, to take place in Montreal August 11-14, 2008. "Balisage: The Markup Conference is designed for markup theoreticians and practitioners who are pushing the boundaries of the field. It's all about the markup: how to create it; what it means; hierarchies and overlap; modeling; taxonomies; transformation; query, searching, and retrieval; and performance. In short, it's a technical XML Conference; it's an XSL Conference; it's a conference about XQuery, RDF, XSD, SGML, LMNL, XSL-FO, XTM, micro-formats, SVG, MathML, OWL, TexMECS, RNG, UBL, and a lot more. Balisage welcomes papers about topic maps, document modeli......

29 of 601 | How can I define a node in Weblogic Integration? - I am practicing a sample, RequestQuote, with wli92 in workshop. After configuring business process I found there is an error in it. It says XQuery ...

30 of 601 | LINQ to XML ?? - ??????????,XML ???????????????????????? Web?????Microsoft Office Word ????????? XML ????   LINQ to XML ???? LINQ ???,???? .NET Framework ???????????? XML?   LINQ to XML ???????,???? XML ??????????????????? (DOM) ???????????,???? LINQ ???????????????????? XPath ??,?????????????,????????   ???????? (DOM),??? XML ???????????????????,??????????,????????????????,LINQ to XML ? DOM ??:?????????????????????   LINQ to XML ????????? Language-Integrated Query (LINQ) ?????????????????? XML ???????????????????LINQ to XML ???????? (???????) XPath ? Xquery ????   LINQ to XML ???????????????????????????????,LINQ to XML ????? SQL ?????,? XML ?????????????,???????????????......

31 of 601 | Navigationless Database XML: Hierarchical Data Processing - Although current databases limit XML processing to linear XPath or XQuery queries, existing hierarchical database techniques enable far more complex queries using standard SQL....

32 of 601 | XML building blocks - What are some good XML specifications to get acquainted with? Here are the ones I find myself referring people to the most. Extensible Markup Language (XML) 1.0 (Fourth Edition). Close to a must-read, although XML basics are simple enough that it's often not necessary. Great to refer back to refresh whitespace and newline handling and which characters are allowed where. Namespaces in XML 1.0 (Second Edition). A must-read these days, as namespaces proved wildly popular and show up everywhere. XML Base. Very useful, especially with documents served over the Internet. XML Schema Part 0: Primer. Grok XSD. XML Schema Part 1: Structures. How to put schemas together. XML Schema Part 2: Dat......

33 of 601 | Making XQuery Control Structures Work for You - The XQuery language is the XML analogue of SQL, designed to augment XPath 2.0 by working with sets of values, not just with single scalar values....

34 of 601 | The W3C XQuery working group has posted a new candidate recommendation of XQuery Update Facility. - The W3C XQuery working group has posted a new candidate recommendation of XQuery Update Facility. XQuery as it currently exists is basically just SELECT in SQL terms. XQuery Update adds INSERT, UPDATE, and DELETE. More specifically it is: More......

35 of 601 | W3C Invites Implementations of XQuery Update Facility 1.0 (Candidate Recommendation) - 2008-08-07: The XML Query Working Group has published the Candidate Recommendation of XQuery Update Facility 1.0. This document defines an update facility that extends the XML Query language, XQuery. The XQuery Update Facility provides expressions that can be used to make persistent changes to instances of the XQuery 1.0 and XPath 2.0 Data Model. This document incorporates changes made against the Candidate Recommendation of 14 March 2008. Learn more about the Extensible Markup Language (XML) Activity. (Permalink)...

36 of 601 | 24 Jul 2008 - Cats and Dogs It's been the rainiest July on record here - and the month isn't over yet, of course. We discovered that the swimming pool can indeed fill above the top of its liner. And during the storms, the dog, who is possessed by a daemon, becomes uncontrollable. or controllable only with difficulty. I still miss being able to have time to concentrate, to focus enough to write reasonable amounts of code, to program. Working at W3C means I get to have a vague warm fuzzy feeling about helping the world a teeny bit, but it isn't always enough compensation. In what little spare time I have, I scan pictures from old books. Soemone recently made a set of phot......

37 of 601 | Map Dataset to XML and XML to Dataset - Relational databases to XML for Biztalk (maybe?) Found A good Article by Xun Ding Check it out below! Map DataSet to XML and back Map XML to Dataset and back Published: 10 Sep 2007 By: Xun Ding This article illustrates the translation to and from an ADO .NET DataSet and XML. Introduction Since the arrival of the Internet, people have become more and more dependent on it for daily operations. The Web's (as well as computing applications') insatiable appetite for data has grown even more intense. Most websites have seen the interplay of relational database and XML. Websites rely on relational databases for storing a vast amount of data and performing fast retrieval and manipula......

38 of 601 | The W3C XQuery working groups has published the first working drafts of XQuery 1.1 and XQuery 1.1 Use Cases. - The W3C XQuery working groups has published the first working drafts of XQuery 1.1 and XQuery 1.1 Use Cases. So far there are just two significant additions listed: More......

39 of 601 | Validating Schemas During Runtime - I recently came across an interesting scenario.  In my application, we are transforming multiple incoming messages to a a canonical format.  We then take the output and place it in the MessageBox for some other downstream subscriber to process.  The Mapper did the transformation and created the output, however, based on the processing that we were doing during the mapping we found that some of the output messages we created did not always get created so that they would pass validation against the canonical schema.  Since we were doing our processing without the use of an Orchestration we did not have the ability to call a pipeline component to do the validation. &......

40 of 601 | Grouping in XQuery - One of the really convenient features introduced in XSLT 2.0 is Grouping. It is a typical second-generation change in a programming language: Not essential for the language itself (grouping can be done by hand using techniques such as the Muenchian......

41 of 601 | First Drafts of XQuery 1.1 and XQuery 1.1 Published - 2008-07-15: The XML Query Working Group has published the First Public Working Drafts of XQuery 1.1 and XQuery 1.1 Use Cases. The former describes a query language called XQuery, which is designed to be broadly applicable across many types of XML data sources. This version of XQuery extends the version of the XQuery 1.0 Recommendation published on 23 January 2007; see the list of changes. The latter document describes usage scenarios that will impact the design of XQuery 1.1. Learn more about the Extensible Markup Language (XML) Activity. (Permalink)...

42 of 601 | In Defense of XML - Jeff Atwood recently published two anti-XML rants in his blog entitled XML: The Angle Bracket Tax and Revisiting the XML Angle Bracket Tax. The source of his beef with XML and his recommendations to developers are excerpted below Everywhere I look, programmers and programming tools seem to have standardized on XML. Configuration files, build scripts, local data storage, code comments, project files, you name it -- if it's stored in a text file and needs to be retrieved and parsed, it's probably XML. I realize that we have to use something to represent reasonably human readable data stored in a text file, but XML sometimes feels an awful lot like using an enormous sledgehammer to drive ......

43 of 601 | Need help with XQuery expression with XMLBeans - Hi,<br>I have this XML document that i want to query using XQuery :<br><br><?xml version="1.0" encoding="UTF-8"?><br><parcautomobile ...

44 of 601 | Friday is the last day to submit late-breaking news for Balisage this August in Montreal. - Friday is the last day to submit late-breaking news for Balisage this August in Montreal. "Balisage is a peer-reviewed conference designed to meet the needs of markup theoreticians and practitioners who are pushing the boundaries of the field. It's all about the markup: how to create it; what it means; hierarchies and overlap; modeling; taxonomies; transformation; query, searching, and retrieval; presentation and accessibility; making systems that make markup dance (or dance faster to a different tune in a smaller space) — in short, changing the world and the web through the power of marked-up information. It's an XML Conference. It's an XSL Conference. It's a conference about XSD, XQuery, ......

45 of 601 | E4X and/or VB9 XML Users - How's it going? - I've been spending a lot of time with XML again lately. Since my last stint with XML, I know we shipped native XML suppport in VB9. I also know that there are E4X implementations out in the wild. What I'd love to know is how either of these are working out for people? What do you love? What blows? What do you wish you had? I'm also interested in hearing from XQuery users, but I'm keenly interested on how the “you got peanut butter in my chocolate” solutions are working out. Feel free to comment here or via a private mail (dbox at the usual place).  ...

46 of 601 | E4X and/or VB9 XML Users - How's it going? - I've been spending a lot of time with XML again lately. Since my last stint with XML, I know we shipped native XML suppport in VB9. I also know that there are E4X implementations out in the wild. What I'd love to know is how either of these are working out for people? What do you love? What blows? What do you wish you had? I'm also interested in hearing from XQuery users, but I'm keenly interested on how the “you got peanut butter in my chocolate” solutions are working out. Feel free to comment here or via a private mail (dbox at the usual place).  ...

47 of 601 | XQuery and Literate Programming - "One thing leads to another" might be the sub-title for the web. Last night I found myself by some circuitous route in LiteratePrograms, a wiki set up by Derrick Coetzee. The site incorporates a version of that earlier WEB. Donald......

48 of 601 | Michael Kay has released version 9.0.0.6 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. - Michael Kay has released version 9.0.0.6 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. This is a bug fix release. More......

49 of 601 | XMLMind has released Qizx/db 2.1, a $3200 closed source, embeddable native XML database engine written in Java that supports XQuery 1.0. - XMLMind has released Qizx/db 2.1, a $3200 closed source, embeddable native XML database engine written in Java that supports XQuery 1.0. Version 2.1 adds support for XQuery Update. The query interpreter part is available under an open source license....

50 of 601 | XRX: A Simple, Elegant, Disruptive - XRX is a new web development architecture that is a milestone in elegant simplicity. XRX stands for: XForms on the client REST interfaces and XQuery on the server Because XRX uses a single model for data (XML) it avoids the......