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
Author: SSWUG Research
Oracle disputes database rankings
By Margaret Kane – Oracle is challenging a research report that says the software maker has lost ground to IBM in the database market.The report, released by Gartner Dataquest, said Oracle had slipped to second place, with about 32 percent market share in the overall database market.
Changing The SQL Server Sa Account If The Password Is Unknown
This article serves as a quick reference as well as provide you with some background information on the Microsoft SQL server’s Sa account and how to change the password even if the currently set password is unknown.
Multi-Interface Web Services Made Easy
by Kip Hampton – There is little doubt that the hype associated with web services has reached astronomical proportions. Notably missing from the current flood of information, however, is a nuts-and-bolts examination of how to build applications which provide both browser-based access for human users
More on XML and compression
In an earlier installment of this column, David examined techniques by which XML documents can be reversibly restructured to improve compression. For large XML documents and embedded processes, however, restructuring an entire source prior to a compression pass might be impractical. In this installm
XML Standards for Global Customer Information Management
By Ram Kumar – The data needed to support real-time e-business lives in legacy, back- office systems. Comprehensive customer management solutions are required to access data in a variety of disparate systems to achieve a complete picture of the customers and their relationships.
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 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
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.
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.