Large XML documents present a problem when they need to be transformed using XSLT or filtered using the XmlDocument class. Because the DOM works by loading the entire XML document into memory, transformations can perform poorly. Fortunately, the .NET platform provides a robust set of classes in the
Author: SSWUG Research
Design an Effective Data-Access Architecture
.NET offers new options for accessing your data, forcing you to decide two things when you design the interface that exposes this content. With the release of Visual Studio .NET (VS.NET) and the .NET Framework, a good number of organizations have begun architecting and implementing .NET
Can XML Be The Same After W3C XML Schema?
by Eric van der Vlist – The “observation” of a XML document made by a schema processor changes the document, and schemas bias our perception of XML documents. This prompted me to ask the question: can XML be the same after W3C XML Schema?
Where is the XML in the database?
By Charlie Garry – META Trend: By 2005/06, Intel-based servers will dominate at the DBMS tier. Scale-out database configurations will grow in popularity as management virtualization improves, but remain primarily a high-availability option. By 2004, XML-based content storage and rendering will becom
OASIS Creates Controlled Trade Committee
By Clint Boulton – CTML will invoke features of other XML business vocabularies and provide an interface to supporting specifications. The CTML committee will align its work with other OASIS libraries and frameworks, such as ebXML, Universal Business Language (UBL), Business Transactions Protocol (B
How to query using special characters in Oracle
by AMIT PRASHANT – Here is how to query an Oracle database with special characters. First, create this test table:
Oracle cuts rewards for last-minute deals
By Alorie Gilbert – Known for its aggressive, high-pressure sales practices, Oracle decided last year to discontinue certain incentives, including steep end-of-quarter discounts and higher fourth-quarter commissions, that encouraged customers and salespeople to cram deal-making into the final days o
David Litchfield and Co. Continue to Pound Microsoft – No Patches in Sight for Existing Holes
From SQLSecurity – NGSSoftware releases yet another SQL Server 2000 buffer overflow with exploit code written in T-SQL (not too shabby). The hole affects the OPENDATASOURCE function when invoking the Jet data access provider. Microsoft’s solution – download the latest Jet version. Does this strike a
The FROM Clause
I was digging through Books Online the other day and I ended up on the FROM clause. I was expecting a simple little entry but that wasn’t quite what I found …
Handle the difficult questions
These questions are similar to what you can expect during a real interview. Being prepared will enable you to think on your feet. The suggested replies aren’t intended to give you one correct answer. Rather, the answers should reflect your personal frame of reference, based on your motives, goals, w