THIS WEEK: Pat's database design tips

[SearchDatabase.com]

Title: TechTarget

January 20, 2003 >> Receive this email as text  >> About this email   In this Issue >> From the editor: Jim's Oracle tips >> Featured Topic: Pat's database design tips >> Expert Technical Advice: New expert advice, forum posts, and tips >> Site Highlights: * Webcast: Server consolidation * Free offers at our new partner page * Download a new white paper  From the Editor: by Tim DiChiara, Site Editor I am happy to announce that Jim Giordano's Oracle tips and advice will now be featured on SearchDatabase.com. Our sister site SearchHP.com is merging with us this week, so now there will be even more great Oracle expertise available on SearchDatabase.com. Jim is a senior Oracle DBA with over 10 years of Oracle experience on UNIX. He works for Symmetry Consulting where he is is a Senior Principal Consultant. Based out of Albany, NY, Jim travels around the U.S. providing DBA support to ERP implementations. On our site, he will specialize in questions about Oracle implementations on HP platforms. Here is a sampling of his "Ask the Expert" work: How do I copy a database from one server to another? View Jim's eight-step process here. Pop quiz: What is the command for finding the size of a shared pool? Jim answers that question and nine others here. What are the kernel parameters that should be modified for Oracle on HP-UX? Jim answers dozens more Oracle and HP questions here. Thanks, and have a great week, Tim  Featured Topic: Pat's database design tips by Tim DiChiara, Site Editor Taking the time to design stable, fast and secure databases is critical for avoiding future administration headaches. To help you in this endeavor, guru Pat Phelan presents a collection of tips about effective design inside... Read more about this topic  Expert Technical Advice: Featured Expert Mike Hotek, Director of Database Operations, AdOutlet Categories: SQL Server Mike has extensive experience with replication going back to Sybase System 11 and SQL Server 6.5 through SQL Server 2000 with over 50 replication installations currently in production with some being the largest in existence in the world. Mr. Hotek also has extensive disaster recovery experience in performing over 150 recoveries of live, production environments. Mr. Hotek became a SQL Server MVP in 2000 for all of the work he does in newsgroups, mailing lists and discussion forums. He's co-author of "SQL Server System Administration," contributing author of "Special Edition Using Microsoft SQL Server 7.0," and creator of mssqlserver.com and certfaq.com. View all Mike's answers This Week: In the forums >> How to save a new record in an Access subform? Member "orpheus" has a form that should save a record in a subform when undergoing an ONINSERT action but is having problems. Go to our "DBA Water Cooler" forum if you can offer any advice. >> Oracle - Toad connection problems Member "Dee" is still waiting for an answer! He is having trouble connecting 9i to Toad, getting an "ORA-12154" error. Go to our "Database-web connectivity" forum if you can offer any advice. Tip of the Week: In the second part of a series, Greg Robidoux presents guidelines that can be used for selecting the appropriate backup and recovery model as well as some important considerations and tips. >> SQL Server backup and restore, part II: Best practices  Site Highlights Server consolidation webcast A key component of a network upgrade is server consolidation View this webcast with Laura DiDio of the Yankee Group to learn about total cost of ownership, ROI, challenges and more! Free offers at our new partner page Take a look at this new page -- featuring special offers for SearchDatabase.com members Check it out for relevant information... or contact us if you have a valuable offer to share with other members. Download this new white paper Are your centralized business applications stuck in a time warp? Read "Distributing Business Applications & Databases; an Analysis of Enterprise Replication Options" to: * Explore the limitations of business application architectures * Learn about new distribution, replication, and synchronization technologies * Discover how to distribute applications across remote sites and user devices FREE EMAIL SERVICES! Select newsletters you would like to receive from the list below. Oracle Tips Ask the Database Experts DB2 Tips Email:     Not a member? We'll activate your membership with your subscription. Premier BI&DW Event! TDWI World Conference, New Orleans, 2/9 - 2/14/03 Intensive, unbiased training for business intelligence and data warehousing professionals at every level. Register Now and Save. Learn more Register and WIN Time is running out to attend CRM Decisions FREE. Join Seybold, Peppers and top industry experts. Register today to win a Treo PDA. Plus, final week for hotel room savings! Find out more News for IT Managers Click here for four reasons you should be receiving the SearchSecurity.com Daily News. Subscribe today and stay one step ahead of future viruses and security threats. Subscribe now A B O U T   T H I S   N E W S L E T T E R Created by TechTarget TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. To unsubscribe from Updates on new site content: >> Simply Reply to this Email with REMOVE within the Body or Subject -OR- >> Go to: http://searchDatabase.techtarget.com/register    - Log in to edit your profile.    - Click on the link to Edit email subscriptions.    - Uncheck the box next to the newsletter you wish to unsubscribe from.    - When finished, click "Save Changes to My Profile".