;) |
|
|
In this Issue |
|
| >> |
From the editor:
DBA vs. developer: Can't we all get along? |
| >> |
Featured Topic:
Spotlight on Stored Procedures |
| >> |
Expert Technical Advice:
* Featured Expert: Karen Morton
* Oracle standby database
* Your integrity, normalization, and relational |
| >> |
Site Highlights:
* Web Services: Data Management Options
* Have you taken our "Database Basics" quiz?
* Bill Inmon: Live Expert Q&A Thursday |
|
|
From the Editor: |
|
by Tim DiChiara, Site Editor
Our Featured Topic this week on stored procedure
development (below) raises the
perennial issue of the conflict between application
developers and database
administrators. We're preparing an article on this very
subject, so I'd love to hear your
thoughts on questions such as:
- Who designs, debugs, implements, and maintains stored
procedures, triggers, and user-defined functions in your
organization: the DBA, the developer or both?
- Is there increasing overlap between the job duties of
the DBA and the developer?
- How do you perceive the hierarchy of the two groups: Is
the DBA in charge, mentoring the hapless developer? Or does
the DBA *think* he/she's in charge, when actually the
developer is the brains of the outfit?
- What are the main points of contention: Performance
tuning? Security? Design? Lack of a clear project
scope?
- Do these issues cause friction between the two groups,
or is your IT department just one big, happy family?
Let me know your thoughts in our DBA Water Cooler forum or e-mail me
personally at [EMAIL PROTECTED]. Thanks!
Till next time, Tim DiChiara, Editor
|
|
|
Featured Topic: |
|
Spotlight on Stored Procedures
by Tim DiChiara, Site Editor
Stored procedures increase the performance,
flexibility, and security of your DBMS. Here is a selection
of our best tips and expert advice about coding effective
Oracle, SQL Server, and DB2 stored procedures and triggers.
Read more about this topic
|
|
|
Expert Technical Advice: |
|
Featured Expert Karen Morton, Owner, Morton Consulting, Inc.
Category: Oracle
Karen is an OCP with over 15 years IT
experience and 10 years Oracle experience. She has
co-authored several Oracle training coursebooks and taught
hundreds of individuals in skills ranging from introductory
Oracle to advanced DBA topics. Ask Karen your toughest
Oracle questions!
View all of Karen's answers
|
|
This Week: In the forums
|
| >> |
Oracle standby database
Member "Karen" wants to create a password file
for a standby database through the oradim utility on Windows
NT, but it's giving a "cannot open parameter file" error.
If you can help, go to our "DBA Water Cooler" forum. |
| >> |
Datawarehousing design with internationalization
Member "Mike" is wondering how to design a star
schema with internationalization support? If you know, go to our
"Data warehousing and data analysis" forum.
|
| Tip of the Week: |
| In this month's column, Fabian Pascal tackles
some thorny questions asked during his "Live Expert Q&A" on
SearchDatabase last December. Read his typically irascible
responses and forceful arguments on topics such as: The
difference between logical and business models;
denormalization and performance; the lack of full
normalization technology among database vendors; integrity
constraints and SQL DBMS's; normalization and data warehouses; and Fabian's favorite RDBMS! |
| >> |
Your integrity, normalization, and relational |
|
|
Site Highlights |
|
|
|
| DW & BI Education |
| TDWI World Conference, San Diego, CA, 5/12 - 5/17. Maximize your training budget with intensive full-day DATA WAREHOUSING and BUSINESS INTELLIGENCE education. Register now and save! |
|
Register Today
|
|
| Oracle 8i PL/SQL |
| Free CDROM training. You pay the shipping, we send the disk. |
|
Details Here
|
|
| Got Cert Questions? |
| If you need info on Win2000-related Certification, find all the answers from searchWin2000's Certification Expert Ed Tittel. Sign up now for his bi-weekly newsletter. |
|
Get the Answers
|
|
|
|
