(Brian Kelley) One of the biggest performance gains built into SQL Server is the stored procedure. SQL Server has the ability to cache the execution plan for re-use at a later time. While SQL Server 2000 has improved tremendously in caching execution plans for ad-hoc SQL queries, it still hand
Other News
Update of the MySQL Certification Exams
On February 1st, 2005, the MySQL Certification Exams will be updated to reflect the changes that have taken place with the release of MySQL Server version 4.1.
Introduction to Tables
In the previous lesson, we saw that a table provides a good technique of organizing a list of items and to store the list in a database file. To create a table, you can type the expression CREATE TABLE followed by the name of the table.
Exchanging XML with SQL Server 2000 and Reporting Services through the Web and Web Services
(Venkat Prasad) This article discusses some programming techniques for saving XML data from Microsoft SQL Servers, Web Servers, XML Web Services, and Microsoft SQL Reporting Servers. Topics include a comparison of traditional techniques used for saving XML streams, using ASP/ASPX and COM, with n
DB2 Universal Database for iSeries
Business Intelligence (BI) is a popular and powerful concept of applying a set of technologies to turn data into meaningful information. With Business Intelligence Applications, large amounts of data originating in many different formats (spreadsheets, relational databases, web logs) can be consolid
An Introduction to Service-Oriented Architecture from a Java Developer Perspective
(Debu Panda) The use of heterogeneous technologies and applications in corporations is a reality. At a time when resources are scarce, IT shops cannot just throw away their existing applications; rather, they must leverage their existing investments. Service-oriented architecture (SOA) is popula
Oracle 10g Availability Enhancements, Part 3: FLASHBACK Enhancements
(Jim Czuprynski) Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article – part three of a series – concentrates on the expanded capabilities of the logical Flashback comma
Tip: Packaging XSLT lookup tables as EXSLT functions
(Uche Ogbuji) This tip shows you how to use the functions module from EXSLT, the community standard in XSLT extensions, and how this technique further improves lookup tables by packaging code into easily reusable functions.
Comparing performance of SMALLINT, INTEGER, and DECIMAL
(Craig Mullins) I have to increase my data field from SMAllINT. Can anyone tell me whether I should go for SMAllINT to INTEGER or SMALLINT to DECIMAL? Which is better in terms of performance? (R)
Worm hijacks open source database
(Dan Ilett) Security experts have warned that thousands of MySQL servers around the world could be press-ganged into launching a denial-of-service attack that could bring down the Web site of a company the size of Microsoft.