(William Pearson) This article focuses on a topic that is related to an earlier group of articles we have published, all of which dealt with the use of “SQL specific” or “direct SQL” within MS Access. As many of us are aware, MS Access can play many varied roles in client / server architecture, and
Other News
Dynamic SQL Server Database Creation in .NET
(Benoyraj B.) This article explains step by step dynamic creation of a SQL Server database, tables and stored procedure using Visual Studio codename Whidbey and VB.NET. Same procedure works for C# as well.
Application Integration: Addressing the Issues
(David Linthicum) Application integration brings a combination of problems. Each organization and trading community has its own set of integration issues that must be addressed. Because of this, it is next to impossible to find a single technological solution set and/or standard that can be applied
The State of XML
(Edd Dumbill) It is four years since I first presumed to summarize the state of the world of XML, for the closing keynote of XML Europe in 2000. In preparation for this speech I read back through that earlier summary and was startled at its continuing relevancy, despite the ongoing development of th
Generate SQL Insert statements for your SQL Server 2000 Database
(daffrey) Have you ever had to deploy a SQL Server database to a customer? If you have, then you will know that it is certainly not as simple as deploying an application that uses an MS Access database.
What does ‘width’ refer to in DB2?
(Craig Mullins) In DB2 does ‘width’ refer to the number of bytes (average) in a row? (R)
Set up a SPECjAppServer2002 on DB2 UDB and WebSphere
(Tony Lau) This article provides the instructions and sample scripts for setting up SPECjAppServer2002 on DB2 UDB and WebSphere. The scripting approach can turn the setup task from a whole day of struggling to a single enjoyable learning hour.
Top 10 new data warehousing features in Oracle Database 10g
(Mark Rittman) The new data warehousing feature in Oracle Database 10g that has probably received the most attention is the SQL Model clause. The SQL Model clause allows users to embed spreadsheet-like models in a SELECT statement, in a way that was previously the domain of dedicated multidimensiona
Improving .NET Application Performance and Scalability
(J.D. Meier, Srinath Vasireddy, Ashish Babbar, and Alex Mackman) This guide provides end-to-end guidance for managing performance and scalability throughout your application life cycle to reduce risk and lower total cost of ownership. It provides a framework that organizes performance into a handful
Run Oracle Stored Procedures in Parallel—Inside the Database
(Boris Milrud) A common misconception among Oracle developers is they can run stored procedures in parallel only from outside the database. For example, many use Java-based code that spawns multiple Java threads and runs each procedure on a separate thread (using the java.sql.CallableStatement objec