Minimize
Blogger List

Johannes Ahrends
Toad and Oracle

Ben Boise
Toad SC Discussions

Kevin Dalton
Benchmark Factory

Steven Feuerstein
PL/SQL Obsession

Devin Gallagher
Toad SC discussions

Stuart Hodgins
JProbe Discussions

  Henrik "Mauritz" Johnson
Toad Tips & Tricks on the "other" Toads
  Mark Kurtz
Toad SC discussions
  Michael Lumbard
Toad SC discussions
Daniel Norwood
Toad for Data Analysts,
Toad Extension for Visual Studio
Debbie Peabody
Toad for Data Analysts
Gary Piper
Toad Reports Manager
John Pocknell
Toad for Oracle, JProbe
Kuljit Sangha
Toad SC discussions
Bert Scalzo Indicates Oracle ACE status
Toad for Oracle, Data Modeling, Benchmarking
Jeff Smith
Toad product family
Richard To
SQL Optimization
Jim Wankowski
DB2 - LUW and z/OS
John Weathington
  Toad Data Modeler Opens in a new window
Data Modeling
 
  Real Automated Code Testing for Oracle
Quest Code Tester blog
 
Minimize
Blog Tags
toad for oracle (122)
oracle (62)
plsql (46)
sql optimization (37)
toad for data analysts (28)
code tester (19)
toad for ibm db2 (13)
automation (11)
batch optimizer (10)
virtualization (10)
schema browser (9)
toad for sql server (9)
data grid (8)
sql (8)
sql editor (8)
toad data modeler (8)
benchmark factory (7)
excel (7)
query builder (7)
report manager (7)
toad extension (7)
visual studio (7)
11g (6)
configuration (6)
freeware (6)
health check (6)
vmware (6)
connect (5)
dba module (5)
er diagrammer (5)
F4 (5)
linux (5)
refactoring (5)
spotlight (5)
unicode (5)
compare (4)
debugger (4)
export (4)
formatter (4)
make code (4)
rman (4)
strip code (4)
benchmark (3)
bfscript (3)
bulk collect (3)
code templates (3)
code xpert (3)
database browser (3)
db2 (3)
notebook (3)
oem (3)
RAC (3)
session browser (3)
speed (3)
sql optimizer (3)
toad for mysql (3)
tpc-c (3)
9.7 (2)
alert log (2)
app designer (2)
awr (2)
code insight (2)
code snippets (2)
collection (2)
compare and sync (2)
compliance (2)
data generator (2)
data warehouse (2)
database explorer (2)
database monitor (2)
explain (2)
forall (2)
ftp (2)
group execute (2)
handbook (2)
installation (2)
job scheduler (2)
multi-task (2)
nested table (2)
os command (2)
profiler (2)
recovery (2)
release history (2)
save as (2)
schema compare (2)
sql recall (2)
stats pack (2)
subversion (2)
team coding (2)
trace file browser (2)
while loop (2)
10g (1)
64 bit (1)
7zip (1)
action (1)
addm (1)
alter (1)
ansi join (1)
array (1)
ccleaner (1)
code coverage (1)
code road map (1)
CRON (1)
cursor for loop (1)
data browser (1)
data subset (1)
database probe (1)
dbms_flashback (1)
dbms_profiler (1)
ddl (1)
feuerstein (1)
filezilla (1)
flash drive (1)
flow control (1)
for loop (1)
group policy manager (1)
hints (1)
import (1)
index (1)
inheritance (1)
invoker rights (1)
ipad (1)
java (1)
latency (1)
log switch (1)
logical model (1)
ltrim (1)
master-detail browser (1)
monitor (1)
multi-select (1)
naming standards (1)
network (1)
object explorer (1)
OEBS (1)
package (1)
parser (1)
partitioning (1)
performance (1)
pragma (1)
project manager (1)
RAT (1)
revo (1)
REXEC (1)
schema report (1)
script manager (1)
search (1)
set operator (1)
sga (1)
slow (1)
sonarsource (1)
source control (1)
space projection (1)
sql monitor (1)
sql navigator (1)
sql script (1)
sql tracker (1)
sql*plus (1)
standards (1)
statistics (1)
stored procedure (1)
string parser (1)
sub-model (1)
sub-type (1)
synch (1)
synchback (1)
TELNET (1)
toad (1)
trace (1)
unit test (1)
unix (1)
usb (1)
utility (1)
v10 (1)
v9.5 (1)
version control (1)
waits (1)
workload replay (1)
workspace (1)
xml (1)
 
WELCOME, GUEST
 
 

Blogs
Toad and Database Commentaries

Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies.  Have some views of your own to share?  Post your comments!  Note:  Comments are restricted to registered Toad World users.

Do you have a topic that you'd like discussed?  We'd love to hear from you.  Send us your idea for a blog topic.


Jun 3

Written by: JohnWeathington
Tuesday, June 03, 2008  RssIcon

Last week, I threw my back out. I don’t even have to try anymore.

It’s allergy season over in this part of California ( East San Francisco Bay Area ), and the prominent allergic symptom that I’ve been dealing with for a number of years now, is an annoying cough.  So, allergies struck over the Memorial Day weekend, which left me with that nasty cough for the week. Thursday morning I was in the shower, coughing my brains out, when one good, deep-diaphragm cough, put just enough strain on my lower back to yield that oh so familiar clench, which almost brought me to my knees.

Here we go again.

By this time, I knew the drill. Fortunately, my wife was in shouting distance, so she rushed in , and escorted me to the bed, where I quickly assumed the horizontal position I would stay in for the next four days. In under a minute, I had two pillows under my knees, an ice pack around my entire lower back, a call into my doctor for a muscle relaxer, and the Food Network channel on the TV. I then proceeded down the frustrating and disappointing route of cancelling all my appointments and commitments for the rest of the week.

This is the drill.

Fortunately, it’s Tuesday now, and I seem to be recovering well. There’s still some pain, and I carry around my back brace just in case, however I can get around without it now.

My doctor explains that I will probably have to deal with this for the rest of my life. In his words, “Once a patient of back pain, always a patient of back pain.” My chiropractor, a Palmer graduate and excellent practitioner, seems to have a different point of view. She says that since my core muscles ( abdomen and surrounding muscles ) are not developed, my lower back has to support all of my weight. There are a number of problems with this:

1)      Nobody’s lower back should be responsible for supporting the entire weight of their body. The lower back muscles aren’t built for that.

2)      My lower back has already been compromised, so it’s in an even worse position to support my body weight.

3)      At 220 lbs, I’m overweight. Even more work for my lower back to do.

As an optimist, and generally positive thinker, I tend to believe my chiropractor. So, this experience has given me a renewed interest in keeping up with my chiropractor, and her methods for strengthening my core muscles.

Of course, any organization – your organization – can fall prey to the same situation. You company can develop a chronic weakness, or “weak spot” when it comes to compliance. This could be in data privacy, network security, segregation of duties … any number of areas.

I’m not necessarily talking about gaps that are identified, and then remedied. I’m talking about violations that are known, that your company is trying to rectify, but they just can’t seem to get their arms around. In fact, in spite of all the money and other resources thrown at the problem, it might just be getting worse! This your company’s Achilles Heel.

So what can you do? How do you deal with your company’s compliance weaknesses?

Well, with the role you probably play, chances are you cannot solve your company’s problem. You do however play a very important role. This is where your company needs you the most, because information is power, and you are the gatekeeper to the information. These are my recommendations for your company, and what you can do to support it.

Step # 1 : Clearly Characterize the Weakness

The more objective data you have about the weakness, the better.  Collect as much data as you can about the weakness. Resist the urge to solve anything at this point, as you will probably jump to spurious conclusions. Collect data in time-series to see if there are any trends you should be aware of. If there are no trends, collect data at random to see if you can characterize the distribution shape, location, and spread. Use your knowledge of data collection and analysis to bring objective, indisputable statistics around your situation.

Step #2 : Encourage Management to Disclose the Situation and Communicate in Precise Terms

It’s dangerous at this point to downplay or exaggerate your problem.  Once you know exactly what you’re dealing with, open and honest communication with everyone involved is the best course of action. Disclosure to management, auditors, and any stakeholders or shareholders is a must. If this weakness is “uncovered” in an audit, without your prior disclosure, things will be 10 times worse. Use your data analysis to keep people honest.

Step #3 : Understand Where You Must Be, and Where You Want To Be

This is your tolerance for non-compliance. When you ask most people what their tolerance for non-compliance is, they will pound their chest and tell you, “Zero Tolerance!” In most cases this is unrealistic, and such bravado, although admirable, should be immediately excused. There’s nothing I can do to get my back to 100% efficiency, and if your company has a chronic weakness, you won’t get to zero tolerance overnight. Your management needs to agree on two metrics; where your company must be ( i.e. absolute minimum number of violations), and where your company would like to be (once again, zero tolerance is not probable, therefore not acceptable).

Step #4 : Accept, Improve, or Explode

If the problem can be accepted for what it is – do that. Do not waste resources on something that just “bothers” you. Accept it, and move on.

If there is a relatively small distance from where you are, to where you need to be, organize an improvement project. You will need to do some more analysis to validate root causes, and then come up with a plan for improvement based on your findings.

If you are a far distance from where you are to where you need to be, you need to blow up the whole process, and design a new one. Sorry, that’s the only answer.

Discovering chronic weaknesses in your company are no fun, and dealing with them is even more enervating. With your help however, your company can hopefully get the situation under control. By clearly understanding the nature of the problem, then communicating the weakness with an attitude of openness and honesty, you’re taking the right first steps. Finally find out where you need to be, then either accept it, improve it, or explode it.

The good news is, organizations are more flexible than humans. Although I will never get my back working like it did when I was 20 years old, your company has hope. That hope, coupled with this information, is your key to total compliance. My hope is that you recognize it, and use it.

Tags:
Categories:
Search Blog Entries