|
Sharing the wealth (of knowledge and expertise) |
|
StevenFeuersteinTW
|
Wednesday, January 31, 2007 12:07 PM
|
|
|
|
I recently spent two days training a group of about 30 developers and DBAs out east. As with any sizeable collection of technologists, the level of expertise and the years of experience varied greatly (and don't always go hand in hand!).
|
 |
|
Comments (1)
|
Read More...
|
|
|
Tuning UNDO Segments |
|
MikeA
|
Monday, January 29, 2007 9:03 PM
|
|
|
|
Of the many databases I have examined on releases 9i and 10g, most are using the automatic undo management feature and on the whole it does a pretty good job of managing the undo segments (for you other old timers, rollback segments).
|
|
|
Read More...
|
|
|
|
|
Normalization in Non-Gobbledygook Language |
|
Bert
|
Friday, January 12, 2007 8:45 AM
|
|
|
|
Probably one of the most often discussed and hotly debated topics in both data modeling and database design is that of normalization. Many database designers, architects, DBAs and senior developers have differing positions and/or beliefs on the topic. However quite ...
|
|
|
|
Comments (5)
|
Read More...
|
|
|
Hidden Costs |
|
MikeA
|
Monday, January 08, 2007 9:40 AM
|
|
|
|
Caveat Emptor (Buyer beware) has been around since, well, since time began. Whether barter or cash, when doing a deal the buyer has to careful, this is especially true in the complex area of software licensing.
|
|
|
|
|
Read More...
|
|
|
How to control many table join |
|
RichardTo
|
Wednesday, January 03, 2007 3:42 PM
|
|
|
|
In my last blog, I use two tables join to illustrate the simple path control, now let’s use a three table join SQL statement to demonstrate a more complicated scenario. Let’s assume that A.key, B.key and C.key are all indexed.
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Tailoring Session Parameters |
|
MikeA
|
Tuesday, December 26, 2006 5:03 PM
|
|
|
|
Many times I am asked how to tailor the initialization parameters for a specific process or user. Essentially the easiest way to set custom initialization parameters for a particular session is to use the ALTER SESSION SET command in a logon trigger keyed to a specific schema or schemas. For example, say we had an application where we wanted to set ...
|
|
|
|
|
Read More...
|
|
|
An Ode to Toad |
|
StevenFeuersteinTW
|
Tuesday, December 19, 2006 3:47 PM
|
|
|
|
I thought I would take a moment out of my busy Quest Code Tester development efforts (that is, heads-down coding, writing specifications, working with developers in Chicago, Columbus, St. Louis and Russia) to give thanks to Toad.
&l ...
|
|
|
|
Comments (4)
|
Read More...
|
|