Database Management & Programming News, Articles & Tutorials for Database Administrators

Upgrading Data Tier Applications in SQL Server 2008 R2 12/02
Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take?

Single Client Access Name (SCAN) for Oracle Database 11g RAC 12/01
One of the maintenance challenges with RAC is maintaining all of the client connection files (TNSNAMES.ora) every time a change is made to a cluster database configuration. A new feature of Oracle Database 11g RAC databases, and a primary benefit, is the Single Client Access Name (SCAN). Read on to learn more...

14 Useful DBA Tasks for Solving Database Performance Problems 12/01
A checklist of DBA tasks involved with keeping an Oracle Database running smoothly can be quite handy. This 14 point checklist, while not actual performance tuning activities are tasks that a DBA needs to know and they will often be part of a solution to remedy a database performance problem.

Collecting Performance Metrics Using SQL Server DMV 11/30
If you cannot afford a third-party tool that can capture database performance metrics or don't want to roll your own solution, then using T-SQL to collect some performance metrics for SQL Server may be your solution.

Let's Do the Time Warp: Temporal Data Comes To IBM DB2 11/29
A couple of months ago, I included DB2's new temporal data capabilities as one of my "Top 10 IBM Data Management Trends for 2010". As DB2 10 for z/OS is now Generally Available, we're going to dig into this popular new feature in a little more detail in this month's column.

dbForge Data Compare Express for Oracle (Devart)
Free tool for data comparison and sincronization in Oracle databases.

DbWrench Database Design and Synchronization (Nizana Systems)
Entity relation diagramming, automatic synchronizing between your database design and your server, reverse engineering, custom data editing forms and more in a single program.