SQL Etc.
What Is Your Definition of Database Workload?
:
Providing a definition for database workload can be a daunting task...unfortunately, it depends on what you’re trying to accomplish.
Successful Database Migration
:
One of the issues that companies are facing in their operations is database migration to new hardware, or a different operating system platform, or even a new database vendor. This article describes the overall process.
Free Hands-on Oracle E-Business Suite Training
:
Join Steve Callan as he shares several ways to get your hands on E-Business Suite.
DBA Call to Action: How You Do What You Do
:
Problem solving is high on the skill set that all DBAs should have. A DBA doesn't necessarily need to know how to solve everything but they should have the ability to define a problem, research solutions, and ultimately take action. Read on to learn more...
Remote DBA Services
:
Remote database administration (DBA) is one of hottest trends in the market these days. Interviews with our respondents have shown that there are many aspects to utilizing remote DBA services. Read on to learn more...
Oracle, MySQL and PostgreSQL feature comparison – Part 2
:
In the last piece of our database comparison, we hit upon
various areas such as triggers, views, and stored procedures. This time around, we'll discuss some areas where the platforms differ
more significantly, most importantly in their handling of complex SQL and optimizing choices.
Transportable Tablespaces: Why the Platform Matters
:
Steve Callan discusses why the platform matters when using transportable tablespaces.
Oracle, MySQL and PostgreSQL feature comparison – Part 1
:
Oracle, MySQL and PostgreSQL obviously have a lot of features, and different solutions for the same problems.
This article looks at the major features, such as stored procedures, views, snapshots, table datatypes, transactions,
and so on, to discover which ones do what you need.
Learning Oracle by the Numbers
:
It's hard enough mastering Oracle 10g, let alone trying to devote time to learning the nuances of an older version. Steven Callan offers advice on how to overcome a step or two backwards with respect to Oracle.
Open-source Technologies for Oracle DBAs and Developers – Part 2
:
The open-source community around databases, and Oracle specifically, has
literally exploded in the last couple of years. The final installment of this two -part article covers open-source administration, security, benchmarking and monitoring tools.
Open-source Technologies for Oracle DBAs and Developers
:
The open-source community around databases, and Oracle specifically, has literally exploded in the last couple of years. Sean Hull presents some of the biggest projects in this two part series.
DBA
Interview Questions : There are nearly an infinite number and
combination of questions one can pose to a DBA candidate in an interview. These
questions lean towards the conceptional, rather than the rote, as questions of
this kind emphasize your foundation, and thorough understanding.
Linux Tips
and Tricks for Oracle : Sreeram Surapaneni discusses some of his
favorite Linux commands and tricks for Oracle.
The
Role of the DBA Related to Insider Threats and Regulatory Compliance : This article deals specifically with insider threats to IT
describing how IT professionals are implementing the necessary products,
policies, and procedures to reduce insider threats and provide the necessary
reporting for regulatory compliance.
Hackers
in your Database : How would you know if there was a mole in your
database? A mole refers to a malicious user who has hacked Oracle objects to
cover his tracks, and stays hidden from view while causing damage to the system
(or other users).
How
Advances in Storage Technology Create a New Security Challenge : Simply
restricting access to your database is no longer enough. The portable and
removable storage devices, not to mention the new PMR hard drive with 160GB
storage capacity, present a security challenge organizations must address.
Oracle
after Hours: Gathering Statistics : Do you know what your database is
doing after dark and on the weekends? Would you be surprised to know that
Oracle, by default, schedules a job to gather optimizer statistics upon
creation of a database?
Understanding
Logical Standby Databases : This article discusses the concept and
setup of the logical standby database.
Oracle
10g: A Self Managed Database? : A DBA's worst nightmare, or the answer
to a prayer? Learn how Oracle's Automatic Manageability Features may affect
you.
Interview
Tips for Aspiring Junior DBAs : Armed with your fresh, just out of
school knowledge of Oracle (and combined with virtually no workplace or on the
job experience), what can you do to improve your odds of being hired? Read on
to learn how to conquer the 'no experience-no job, no job-no experience' cycle.
Tips and
Tricks for Oracle in a UNIX World : The title says it all. Join Steve Callan
as he shares some of his personal favorite Oracle tips.
DBA
from Crisis to Confidence : This article describes some of the steps
that a DBA in crisis can take for a thorough post-mortem.
OC4J
– The "Other" Oracle Application Server : This article is the
first of a multi-part series focusing on Oracle's more Web-like version of
Application Server, J2EE applications, and XML. Being able to differentiate the
versions of Application Server , basic administration , performing a new type
of installation, and acquiring an XML editing tool are some of the topics that
will be covered.
Where
Did Oracle Come From? : Often times, we take for granted the functions
an RDBMS performs. But where, exactly, did the concept of the relational model
come from? Read on to learn the origins of the RDBMS model in general and where
and how Oracle came into being.
Database
Benchmarking : Steve Callan introduces you to what the benchmark tests
are, who controls or regulates them, and shows how Oracle compares to other
database systems.
Describing
Oracle Syntax : Steve Callan offers a brief history on Oracle's syntax.
DBA
Call to Action: Get up and GO : If you aren't moving you will never go
anywhere. It is time to dust off your DBA shoes, and start thinking about your
future.
If you have an interesting
column / article / short note etc., that you would
like to share with the rest of the DBA world, please
send it to webmaster@dbasupport.com.
Back to DBAsupport.com
