THIS WEEK: Rudy Limeback's SQL tips

[SearchDatabase.com]

Title: TechTarget

December 09, 2002 >> Receive this email as text  >> About this email   In this Issue >> From the editor: The future of the data center >> Featured Topic: Rudy Limeback's SQL tips >> Expert Technical Advice: New expert advice, forum posts, and tips >> Site Highlights: * Webcast: Oracle expert tuning secrets * Subscribe to Oracle Tips today * Webcast series: Managing IT Heterogeneity  From the Editor: by Tim DiChiara, Site Editor I'm happy to announce a new information resource for data center managers: Data Center Futures. This twice-a-month newsletter focuses on the future of the enterprise data center, including mainframe technology, data management, integration, emerging technologies and new management strategies. Our writers present, in a fun and futuristic light, what industry analysts, IT managers and experts see coming in the next five years in general and the next year or two in particular. Recent stories have included: Multi-platform integration Linux and server consolidation The future of Web services More affordable disaster recovery tools Remember, a subscription to Data Center Futures is free -- to start receiving it, just log in to your SearchDatabase.com account and check of the appropriate box under "Edit Email Subscriptions." Also, be sure to let me know what topics you'd like us to cover: email me at [EMAIL PROTECTED] with your suggestions. Thanks, and have a great week, Tim  Featured Topic: Rudy Limeback's SQL tips by Tim DiChiara, Site Editor Rudy has been in the database field for 25 years and he knows his SQL. Browse his 200+ answers to your tough SQL questions. Read more about this topic  Expert Technical Advice: Featured Expert Mike Lampa, CEO, BAG, Inc. Category: Data warehousing Mike is co-founder and CEO of BAG, a business intelligence consultancy. He has over 21 years experience in strategic planning, program management, and designing, building and supporting data warehouse and operational data store implementations. Intricately involved in the daily activities of BAG, Mr. Lampa can often be found building data and process models to aid in improved operations efficiency and decision support automation for clients. View all Mike's answers This Week: In the forums >> Open two databases on the same ASP page Member "Pietro67" is woindering if it is possible to open two different Access 2002 databases on the same ASP page in order to update one with records from the other. Go to our "Database-web connectivity forum" forum if you can offer any advice. >> INSERT statement troubles Member "Max" is trying to find some rules for choosing between a hash join and a nested loop. Go to our "Data warehousing and data analysis" forum if you have an idea for "Max." Tip of the Week: The author needed to access data in a Progress database from within an Oracle stored procedure. To do so, he utilized Oracle's Java Stored Procedure functionality to make this possible. Here are the steps that can work with any DBMS. >> Accessing non-Oracle databases using stored procedures and JDBC  Site Highlights Webcast: Oracle expert tuning secrets Oracle tuning can be complex with over 250 parameters, and thousands of causes Don Burleson shares tuning secrets, explores causes of poor performance and looks at the "silver bullets" for Oracle tuning. Subscribe to Oracle Tips today Increase efficiency with these Oracle development and management tips Subscribe today and you'll get tips on subjects like 9i migration, performance tuning, querying, SQL secrets and more. Webcast series: Managing IT Heterogeneity Register today for all three webcasts in this Web services mini-series Learn how Service-Oriented Architectures enable new strategies to address security, mainframe and integration issues: PART 1: Extending Security across IT Islands PART 2: Integrating Legacy Assets: Service-Oriented Architectures on the Mainframe PART 3: Unified Enterprise Messaging - Seamlessly Bridging J2EE and CORBA Platforms This is your chance ... to interact with top experts, network with your peers and ensure the success of your CRM projects. Register to attend the 2003 CRM Technology Decisions conference today! Details here Storage Management Sign up for the FREE Storage Management 2003 conference to learn the processes, procedures and technologies that will help you get the most out of your storage operations! Click here Upcoming conferences Check this page regularly for database-related events, such as: Hotsos Symposium on Oracle System Performance on February 9 and CRM Technology Decisions Conference on February 12. Check it out 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 2002, 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".