Title: DBA Tips
![]() |
![]() |
![]() |
Issue Sponsored By:
![]() IDERA - Tools for SQL Server Professionals
![]()
IN THIS ISSUE:
![]() DB2: How to create Web database apps with WDSC and VDM
![]() DB2: Generating XML from SQL data
![]() Oracle: Using Oracle flashback querying for DDL audits
![]() SQL Server: Guidelines for creating indexes
![]() DB2 v8 certification: Everything you need to know
![]() SQL Server: Vertical partitioning of large databases
![]() Newbie tips and advice
![]()
![]() |
![]() |
![]() |
![]() |
Free 30-Day Trial of Idera's Web-Based SQL Server Management Tool - SQLtool
Powerful, with over 350 functions, SQLtool allows you to manage and administer any SQL Server anywhere in the world from your browser. Highly scalable, with battle-proven performance on large SQL Server installations, SQLtool is easy-to-use and deploys in minutes.
Download Now! |
![]() |
![]() |
![]() |
![Advice]()
![]()
DB2: How to create Web database apps with WDSC and VDM
[Jim Mason]
An overview of the author's "Visual development method" that seeks to raise productivity and shorten the learning curve for DB2 iSeries/RPG developers who want to build Java Web applications.
MORE INFO:
![]() Featured Topic: Spotlight on DB2
DB2: Generating XML from SQL data
[SearchDatabase.com]
You are an RPG programmer. You could use the XML parser APIs on the iSeries to learn how to do DOM or SAX parsing to generate XML documents. Good idea? No! Learn how to easily generate XML from SQL without coding using WDSC in DB2/400.
Oracle: Using Oracle flashback querying for DDL audits
[Printaporn Sangdara]
In this tip, the author extends Oracle's useful flashback querying feature to auditing data dictionary changes issued on the entire database.
SQL Server: Guidelines for creating indexes
[Barrie Sosinsky]
A well-performing database minimizes index creation while emphasizing the creation of the "right" mix of indexing. Here are some rules to guide you in your table designs when you are trying to decide what to index.
DB2 v8 certification: Everything you need to know
[Howard Fosdick]
The whats, whys, and hows of DB2 certification are presented in this detailed article.
SQL Server: Vertical partitioning of large databases
[Barrie Sosinsky]
To increase performance, you can partition your tables using either vertical or horizontal partitioning depending upon the nature of your data. Here is an overview of the former.
![Also on SearchDatabase.com]()
![]()
ASK THE EXPERTS: SQL Server: Trigger to update table with no foreign keys to original
Our SQL Server expert Mike Hotek answers a question about creating a trigger on a table that has no primary key that is a foreign key in the position table.
TOPICS: Newbie tips and advice
To newbies, the modern DBMS seems impossibly complex. They're right, of course! Inside is a wealth of resources for those just starting out: tips, webcasts, advice, and much more.
![]() |
![]() |
Contact Us
Sales
For sales inquiries, please contact us at:
[EMAIL PROTECTED]
Editorial
For feedback about any of our articles or to send us your article ideas, please contact us at:
[EMAIL PROTECTED]
|
|
![]() |
![]() |
|
![]() |
|
![]() |
|
