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.


Mar 27

Written by: JohnWeathington
Thursday, March 27, 2008  RssIcon

Hi Everybody!

Welcome to my inaugural blog entry. I’m excited to join the team of experts at Quest Software, and I am looking forward to sharing my observations, issues, tips, tricks, and solutions on compliance with you.

I’m John Weathington, President and CEO of Excellent Management Systems, Inc.,  a management consultancy that helps companies improve their regulatory and contractual compliance. My clients have included Hogan and Hartson, Sun Microsystems, Hitachi Data Systems, and Silicon Graphics just to name a few.

Although I principally work with upper management now, I have a deep technical background in database administration and development, data warehousing and business intelligence, and software development. I’ve been an Oracle DBA for a number of years now, and have used Quest tools including Toad all along the way. I recently lead the way on the new construction of a 2 TB GSA compliance data warehouse for Sun Microsystems. It was quite a ride, but well worth it. Not only were we able to fortify their $100 Million contract, but we also paved the way for an improved sales process.

In addition to being a techie, I’m also an accomplished project manager ( PMP certified ), process improvement expert ( Six Sigma Black Belt from Motorola ), and pioneer on using agile development techniques for the construction of data warehouses and business intelligence environments. With Sarbanes Oxley concerns rearing their ugly head, I was called upon to manage an identity and access management 404 control effort for a large high-tech firm. I had only 4 months to get 9 systems compliant! It was tough, but we pulled it off.

So, I decided to take my broad set of skills and tools, and help companies improve their compliance – any kind of compliance. I’m a pragmatist, so I’m not so concerned with the latest revision of the laws, and their political implications. What I’m concerned about is getting compliance done, and done right.

My clients are typically Board of Directors, CEOs, CFOs, CIOs, CCOs ( Chief Compliance Officer ), VP of Finance / IT, Controllers, or anybody else that is responsible for getting compliance done. I also help Partners of accounting firms and law firms. I recently helped Hogan and Hartson in a data-based defense against a Fortune 500 firm, in a GSA related matter.

So what does this have to do with DBAs, database developers, and IT Managers?

Actually a lot.

And it’s not just compliance. There’s a whole family of related areas of corporate interest; governance, risk, compliance, and security.

So for starters, let’s clarify some terminology in this space:

Governance: Governance is about administration and control. It’s the processes and policies that a corporation develops, to make sure it’s achieving its mission and goals. Governance is also tied to performance and return on investment ( ROI ). For instance, there is a big trend in business intelligence governance now. This simply means, understanding and directing the return on investment for your business intelligence investment, and systematically migrating it through maturity.

Risk: Risk is uncertainty. Managing risk means managing uncertainty. There’s a common misconception that risk only involves unfavorable events. This is not true. There is a concept of positive risk, which means something unexpected and fortunate happened. Mitigating risk means taking deliberate action to lessen the probability, increase the visibility, and / or reduce the impact of a risk-related event.

Compliance: Compliance is making sure that stated policy is adhered to. This is more specific and tactical than governance. Compliance usually comes in the form of regulatory ( i.e. complying with laws like Sarbanes-Oxley, HIPPA, or PCI ) or contractual ( complying with contract terms like GSA or royalties ). GSA compliance is a universal contractual concern for most companies. The GSA is the General Services Administration of the US Federal Government. If a company wants to do business with the US government, they need a GSA Schedule. This schedule is part of an overall contract, that has terms and conditions that usually concern your company’s sales policies.

Security: Security is taking deliberate actions to defend against attacks on the corporation and its data. As you are probably well aware, there is a plethora of ways that corporate data can be exposed and compromised. And the hackers are getting smarter by the second.

DBAs, database developers, and IT managers must be concerned with all of these. In talking with CFOs, Compliance Officers, and Controllers, there is one consistent liability – IT controls. Finance people, no matter how senior, do not understand how to deal with the complexity of keeping data systems secure and under control.

In addition you have the talent and skills to build data systems, that will help your organization improve their compliance. And your organization will be a better company because of it. You know how to crunch through data, and you know how to organize their data in ways they haven’t even thought of yet. Your involvement can make or break your organization’s ability to meet its corporate goals, manage risk, comply with standards, and secure its information.

My hope for this blog is to impart my wisdom and advice, so that you can help your company improve. I’d also like to engage in active discussions with you around the compliance issues you are facing, so that I can guide you to the right solution. Please comment on any and all topics that strike your interest. Also, feel free to send me a private email if there’s a topic you’d like to see discussed.

I’m honored to be invited into your community, and I look forward to sharing ideas with you.

Now, let’s start talking about compliance!

Tags:
Categories:
Search Blog Entries