(Kalen Delaney) Security concerns affect almost every action of every SQL Server user, administrator, and developer. SQL Server manages multiple collections of entities that are organized hierarchically, with the server at the top. Beneath the server level is a collection of databases, and beneath t
Other News
Namespace Myths Exploded
(Ronald Bourret) The XML namespaces recommendation is tantalizingly vague about, or omits altogether, a number of apparently important points. In practice, this is not a problem—the points are not actually important and the recommendation does what it was designed to do: provide a two-part naming sy
Customizing the DB2 Universal Database Command Line Processor
(Paul C. Zikopoulos) IBM DB2 Universal Database for Linux, UNIX, and Windows (herein referred to as DB2 UDB) gives you two methods for entering commands from its command line interface. When using the DB2 UDB Command Line Processor (DB2 UDB CLP) in Interactive mode, you don’t have to prefix your DB2
Building RAD Forms and Menus in Mozilla–Sample Chapter
(Nigel McFarlane) n Rapid Application Development with Mozilla, Web, XML, and open standards expert Nigel McFarlane explores Mozilla’s revolutionary XML User interface Language (XUL) and its library of well over 1,000 pre-built objects. Using clear and concise instruction, McFarlane explains what co
Validating XML Documents Against XML Schema
(Deepak Vohra) XML documents are increasingly being used as a format of data exchange. But for an XML document to be acceptable to different developers/users, the XML document should conform to a standard structure. XML Schema is an XML-based representation of the structure of an XML document. T
Automated Real-Time Maintenance for DB2 for z/OS and OS/390
(Ulf Heinrich) This White Paper provides an insight into the real-time maintenance of DB2 for z/OS and OS/390 databases. First a description of the current standard maintenance techniques is provided and their disadvantages and problems are pointed out. In addition, the rising requirements that
Opening Open Formats with XSLT
(Bob DuCharme) This month I’m taking a break from covering XSLT 2.0 to describe how the combination of XSLT 1.0 and an application with an open XML format solved a problem for me. I solved this problem so quickly and easily that it got me thinking about how the combination of XSLT 1.0 and the increa
Using HttpUnit in Oracle JDeveloper 10g
(Olivier Le Diouris) Unit testing gained popularity with the adoption of eXtreme Programming (XP). JUnit introduced the possibility to run unit tests in Java. Several other components running on top of JUnit can be used to run unit tests concerning some specific technologies, like XML and HTTP. This
Storing Word Documents in Oracle
(James Koopmann) Have you ever wondered about storing documents into your Oracle database and just didn’t know where to start? Here is a quick introduction to the basics you need to know.
Data Mining Algorithms: Microsoft SQL Server 2000 vs. Yukon
(Alexzander Nepomnjashiy) This article describes a well-known concept, (Data Mining algorithms, built into Microsoft SQL Server 2000 Analysis Services) and what I would like to see in the final “Yukon” SQL Server release (i.e. my expectations in a field of new / improved data mining algorithms).