|
|
In this Issue |
|
|
From the Editor: |
|
by Tim DiChiara, Site Editor
I know you appreciate the free benefits SearchDatabase.com has to
offer -- now is your chance to make our site even better. We are
currently seeking database professionals to help with our year-end
survey. The results of this survey will guide the editorial team
toward the topics, tips and news that interest you the most. Don't pass on this opportunity to
play a key role in influencing SearchDatabase.com content.
We would like to know:
- What database-related projects will you be involved in next year?
- Is your data management budget going to be cut next year?
- Where do you plan to spend your database budget in 2003?
These important questions will help us focus on the topics you need
to know about the most. Next year is predicted to be a recovery year for database management and the IT industry, and we want to make sure you
are prepared. Click here to take this very short survey
It will only take a
couple minutes to complete. The information you provide will help
influence the site for next year and beyond.
On behalf of the SearchDatabase.com team, I would like to thank you
for your assistance with this. Thanks, and have a great week, Tim
|
|
Featured Topic: |
|
Stored procedure development
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 Ian Abramson,
CTO, IAS Inc.
Category: Data warehousing
Ian is the founder of IAS, Inc, which has built a fourteen year reputation for delivering high quality Data Warehouse and Oracle systems to clients around the world. Ian is also the co-author of several Oracle books, is currently the Director of Education Programming for the International Oracle User Group, and is well-known for his seminars and technical training classes. Ask Ian your tough data warehousing questions!
View all Ian's answers
|
This Week: In the forums
|
>> |
CLOB from Perl
Member "Mery G" is still wondering how to execute a procedure from a Perl script. Anybody out there with experience? Go to our "Database-Web connectivity" forum if you can offer any advice. |
>> |
Lookup tables
Member "Badone" is looking for a good reference about lookup tables in order to create a faster way to search through 1000 character descriptions in a database. Go to our "DBA Water Cooler" forum if you have any other ideas for "Badone." |
Tip of the Week: |
The main usage of this tip is to help clarify by example the use of Oracle's virtual private database by an application server account. Most examples and documentation by Oracle show how VPDs can restrict access to data based on your user account when you login to the Oracle database. The problem with app servers is that you login to the app server with your login but the app server accesses the database as the app server account so all users would appear to login to the database as the app server account and the VPD cannot differentiate individual app users. The tip shows how to pass a session ID from the App to the database allowing the use of VPD. |
>> |
Using Oracle virtual private databases with application servers |
|
Site Highlights |
|
|
|
Get an Oracle update |
Visit our comprehensive page of coverage from OracleWorld 2002. Read attention-grabbing news stories, and learn about the latest product announcements -- all in one place. |
Read more today
|
|
AD Newsletter |
Subscribe to SearchWin2000.com's Active Directory Administration Tips and get AD tips that will help you with the planning, administration and maintenance of AD services. |
Subscribe now
|
|
SQL Server Tips |
Receive helpful SQL Server Tips directly to your inbox. Why spend time looking for a tip? Subscribe today and save time.
|
Subscribe Today
|
|
|
|