(Zhaohui Tang, Jamie Maclennan and Peter Pyungchul Kim) A data mining component is included in Microsoft SQL Server 2000 and SQL Server 2005, one of the most popular DBMSs. This gives a push for data mining technologies to move from a niche towards the mainstream. Apart from a few algorithms, t

(Bob Beauchemin) Use the relational query engine in SQL Server 2005 to make a single query plan for the SQL and XQuery parts of your queries, and make the implementation of XML queries fast and easy to predict and tune.

(Elliotte Harold) Unicode is a superset of every other significant computerized character set on earth today. UTF-8 is the proper binary encoding of the Unicode character set. This article makes the case that all XML documents should be generated exclusively in UTF-8. The result is a more robust, mo

(Jeffrey Juday) Have you ever wanted flexibility in your SQL Server database without having to add additional tables? Do you store XML in your SQL Server 2000 database and yearn for an easier way to validate it against a XML Schema definition? If you’re planning on upgrading to SQL Server 2005, you’

(Ramdas S) The Unicode standard provides a universal way of encoding all the characters of all the world’s language scripts. This article introduces Unicode and discusses how it can be used with XML.

(Uche Ogbuji) XML is SGML on the Web, and it is a rare XML project that doesn’t find a connection to the Web in one way or another. A little while ago in this column, I wrote “Querying WordNet as XML,” which examined WordNet 2.0 and how it can be used with XML and RDF technology. If you haven’t read

(Maxim Alekseikin) Finite state automaton is useful in a couple situation for example: parsing protocols, tracing user input etc. But it has a big lack: automaton’s source code is a very big. It contains a lot of lines and it is hard to create and support it. This article is about how you can reliev

(Micah Dubinko) August brings a change in my day job responsibilities; along with it comes with a certain amount of disruption, including a stretch of time away from reading the mailing lists. Judging by the popularity of columns like XML-Deviant, many readers are in similar straits. Even high-quali

(Jeffrey Juday) Have you ever wanted flexibility in your SQL Server database without having to add additional tables? Do you store XML in your SQL Server 2000 database and yearn for an easier way to validate it against a XML Schema definition? If you’re planning on upgrading to SQL Server 2005, you’

(DJ Walker-Morgan) XML may be human readable but it can be a tedious chore writing code to read and manipulate it. For the lazily efficient coder, tedious chores are not for them, and thanks to XmlBeans and E4X, a lot of those chores can be eliminated.