(Christine Law and Shakeb Shere) There are numerous advantages to using stored procedures for your database applications. Some of the benefits include reduced network usage, improved performance, and reduced development cost. Java stored procedures have always been one of the most popular routines s
Other News
Generics FAQ: Best Practices
(Juval Lowy) The main reason not to use generics is cross-targeting—if you build the same code for both .NET 1.1 and .NET 2.0, then you cannot take advantage of generics, since they are only supported on .NET 2.0.
Character Set Migration in Oracle
(Vijay Kumar) In some cases, you may wish to change the existing database character set. For instance, you may find that the number of languages that need to be supported in your database have increased. In most cases, you will need to do a full export/import to properly convert all data to the
Set up file locations for optimal SQL performance
(Arthur Fuller) By default, SQL Server locates all its files on the same drive as the server. In addition, it places the log file for each database on the same drive. All that disk access can cost you a significant amount of performance. When installing SQL Server, you can specify the default drive
Bringing BI to More Users, Faster with MIS Plain and Microsoft SQL Server Reporting Services
Access to the right information, in the right format, at the right time is critical. This whitepaper explains how enterprises can achieve these goals by leveraging MIS Plain and Microsoft SQL Server Reporting Services in a best-of-breed software solution. (R)
Display Hierarchical Data with TreeView in ASP.NET 2.0
(Teemu Keiski) Now that ASP.NET 2.0 is about to be released to manufacturing, we ASP.NET developers have very interesting times ahead of us. Along with the new Framework, we have a major set of new controls to use and to ease our development work. One of the new controls, also my favorite, is the Tr
U.S. Census Bureau Counts on MySQL
Most Americans are aware that every 10 years, the United States Census Bureau conducts a massive Census of the 105 million U.S. households to collect updated national demographic information. The Census data determines critical population information such as size, growth and geographic densities, as
How to Use Scalable Vector Graphics (SVG) to Create Graphics?
Scalable Vector Graphics (SVG) is a format of graphic that can be generated on the fly by using the data extracted from XML files or a database. Creating images on the fly in the other formats like GIF, JPEG, and BMP are not easy since they cannot be created dynamically by extracting data from the d
Oracle Cracks the Whip with Enterprise Manager 10g R2
(Lisa Vaas) Oracle plans to release an update to Enterprise Manager that slaps at two pain points in grid computing: getting IT services available to meet agreed-upon service levels, and being able to measure whether IT is helping the business out or dragging it down.
Tearing Apart an XML Document
(Shahab Fatemi) You have an XML document that needs to be broken apart into its constituent parts. Each part can then be sent to a different destination (possibly a web service) to be processed individually. This solution is useful when you have a large document, such as a phonebook , an invoice and