(Dale Edgar) Data Sanitization is the process of making sensitive information in non-production databases safe for wider visibility. This White Paper is an overview of various techniques which can be used to sanitize sensitive production data in test and development databases. An initial discuss
Other News
Deploying cost-effective database storage
(Mark Teter) End users are looking for cost-effective database storage solutions that maximize online transactions, provide good backup-and-recovery performance, minimize overall storage costs, and provide reasonable fault tolerance. In addition, users need high-performance storage to support Oracle
Understanding and Leveraging Oracle9i Advisories
(Azeem Mohamed) Oracle has introduced many advanced features in managing memory. One of the interesting features is the advisory, which enables a DBA to dynamically resize SGA components and control the PGA memory utilization at the instance level. Oracle introduced advisories for buffer cache
URL Encoder :: (Script Library)
Category: Utilities Tags: Compatibility: SQL Server 7.x and later Description:
URL Decoder :: (Script Library)
Category: Utilities Tags: Compatibility: SQL Server 7.x and later Description:
Testing .NET applications
(Anand Narayan and Vinay Desai) This white paper shares vision and challenges in testing .NET applications. Never before, has any technology or framework tried bringing many disparate systems and languages under one roof for the benefit of enterprise applications. But with the advent of the .NET
Protecting Your Data Integrity with Transactions in ADO.NET
(Christa Carpentiere) Transactions are a key feature for maintaining data integrity when modifying data. Get an overview of transactions and their importance, then learn how to use them to protect data in your .NET applications.
Database Management for DB2 Universal Database – zOS and OS/390
SmartDBA solutions optimize performance of your DB2 UDB for z/OS and OS/390 databases by providing a comprehensive solution for monitoring and managing your environment through a single, integrated console. You can reclaim space and proactively prevent outages as well as analyze, diagnose, and tune
Object-Relational Programming with DB2 (Sample Chapter)
(Susan Lawson) Explore some of the more powerful features of DB2’s SQL language. Learn about the extended programming features, User-Defined Functions (UDFs), table functions, triggers, and user-defined data types (UDTs).
Oracle Tip: Use the correct looping control in PL/SQL
When you process an index-by table in PL/SQL, there are times when you cannot be sure of the indices that exist on the table, so you can’t use the most obvious form of the FOR loop to loop through values. (R)