(Tarry Singh) Starting with this article, we will begin a discussion on administering our RAC database. Administration can mean many things; think of all that you do as an Oracle DBA–backup, restore, export, import, tuning, benchmark and even some PL/SQL work (It is not just for programmers you kno
Author: SSWUG Research
Unit Tests in Visual Studio 2005
(Satheesh Kumar) VSTS comes with many tools integrated in it for the developers & testers and also for architects and managers. The unit testing tool that comes with the Visual Studio 2005 enables the developers to generate the test classes and methods. Team Test does not provide tools only for deve
Do People Really Understand Data Warehousing?
(Rick Sherman) It’s been 20 years since the term “data warehousing” was first coined. Since then, it has evolved into a mainstream activity for Fortune 1000 companies, with many undertaking one or more data warehousing projects over the last decade. However, even after 20 years in the marketplace, i
Real-world Reflection in .NET
(Andrew Troelsen) The .NET platform supports a number of seemingly esoteric programming techniques, such as reflection, dynamic loading, late binding, and custom attributes. At first glance these topics may appear to be of little more than academic interest, having little use in the “real world.” Ho
DB2 packages: Concepts, examples, and common problems
(John Chun and Paolo Cirone) Packages in DB2 are control-structure database objects that contain executable forms of SQL statements or placement holders for executable forms. In DB2 for Linux, UNIX, and Windows, packages may also be referred to as access plans. Packages are stored in the database sy
XML application migration from DB2 8.x to DB2 Viper, Part 3: Sample XML application migration scenario
(Hardeep Singh) In this article you go through an XML application migration process using an example scenario. The scenario goes through the steps of creating a sample application using DB2 UDB Version 8.x functionality for XML. This application then is migrated using DB2 Viper XML capabilities. As
Checking All CheckBoxes in a GridView Using Client-Side Script and a Check All CheckBox
(Scott Mitchell) Last week I authored an article titled Checking All CheckBoxes in a GridView that illustrated how to add functionality to check all CheckBoxes in a GridView at the click of a button. Specifically, the article examined how to accomplish this using both server-side code and client-sid
IBM expands the reach of business intelligence with new search and discovery solution
IBM has announced a solution that combines enterprise search and unstructured information discovery software with advanced reporting and analytics to help clients more quickly find, access and gain insight from business information.
Security and More in MySQL Databases
(Paul Dubois) Starting from MySQL 4.0.3, we provide better access to a lot of system and connection variables. Many variables can be changed dynamically while the server is running. This allows you to modify server operation without having to stop and restart it.
Get More from Your Oracle Database: Best Practice Performance Management for Real Results
DBAs are constantly challenged to increase database performance while keeping costs down. This short paper discusses Resource Mapping Methodology (RMM) which defines a systematic process for performing Wait-Event analysis to optimize database performance. It includes a brief overview of Ignite for O