LECCO Technology, Inc., a global provider of performance optimization solutions for databases and software applications, February introduced Version 3.2 of its popular LECCO SQL Expert™ for Oracle. The new package provides enhanced development capabilities that allow Oracle database and application
Other News
Get your databases together
By Jon Rubin – The typical midsize-to-large enterprise today has a number of relational database management system (RDBMS) products, running on multiple platforms, with dozens of distinct instances–some of which host multiple database applications.
Provide Feedback About SQL Server Documentation
By Brian Moran – Here’s how to provide feedback to Microsoft about the code snippets in SQL Server “Books Online” (BOL) and other SQL Server documentation sources.
Testing SQL Server 2000: Inspecting Configuration Information
SQL Server installations can have differences in configuration settings and server properties, which can lead to subtle changes in code behavior. Therefore, you should inspect the configuration before beginning to code to a given SQL Server 2000 server. Ron Talmage provides tools and techniques for
Oracle embraces outsourcing
By John Cox – After 2 1/2 years of boasting and bumbling, Oracle finally might be hitting its stride with its enterprise outsourcing business.The database giant has made some wrenching internal changes in the past 18 months to make outsourcing a major source of future revenue. Customers who
Locking in SQL Server 7.0
By Alexander Chigrik – In this article, I want to tell you about general details of SQL Server 7.0 locking, about Transaction Isolation Level, what kinds of Transaction Isolation Level exist, and how you can set the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hint
Oracle fires back over Calif. contract
By Alorie Gilbert – Oracle came out swinging Tuesday, disputing claims that it sold the state of California more software than it needed–and warning that if that state cancels a $95 million contract, it could create problems for agencies already using the software.
How to archive data from my production databases?
Archiving is the process of getting rid of old data (or data that is not valid anymore) from the main production databases. There is no built-in command or tool for archiving databases. In this article I’m going to show you how to implement this process.
Generate Custom Crosstab Reports
by Roger Jennings – Designing XML Web services that return user-defined time-series crosstab reports as XML or XHTML response documents probably will be among the first challenges presented by clients or managers to Visual Studio .NET developers. This article describes what I believe to be a new app
Recruiters endorse HR-XML proposal
By Gillian Law – The six sponsors of the HR-XML (Human Resource Extensible Markup Language) Consortium have endorsed a specification it developed for information exchange between recruitment organizations and their customers.