This Week: DB2 tips and scripts

[SearchDatabase.com]

Title: TechTarget

An e-newsletter published by SearchDatabase.com  February 09, 2004 >> Receive this e-mail as text  >> About this e-mail   In this Issue >> From the editor: Fun with cross-learning >> Featured Topic: DB2 tips and scripts >> Expert Technical Advice: New expert advice, forum posts, and tips >> Site Highlights: * How much of a database guru are you...really? * Have you registered for the Data Center Decisions conference yet? * Featured IBM DB2 tip  From the Editor: by Sara Cushman, Assistant Editor Last week, SearchDatabase.com Senior Site Editor Tim DiChiara opined that the happy days of IT spending may be back, particularly for small and mid-sized businesses. Perhaps not coincidentally, the big three DBMS vendors have recently been waging war to win over these new customers. Oracle and DB2 have both introduced lower-priced versions of their respective DBMSs specifically to attract the smaller crowd that SQL Server has traditionally courted. So what do these industry trends and the tactics of the big vendors have to do with you? Maybe nothing. But it could mean that there's a good chance that you'll have to deal with upgrading, installing, or maintaining a system new to you, or even multiple ones. Are you ready? Administering a heterogeneous environment or learning a new DBMS certainly has its challenges, but if you happen to be making the switch to DB2, we can help you get started. Check out our popular Learning Guide: DB2 basics for Oracle and SQL Server pros or these tips on how to leverage your Oracle 9i skills or your SQL Server 2000 skills to learn DB2 UDB v8. Need to figure out SQL Server? Try our SQL Server Basics learning guide. Our sister site SearchOracle.com has all the info you need to get started with 10g. Can't find what you need? Drop us an e-mail and tell us. Good luck, Sara  Featured Topic: DB2 tips and scripts by Tim DiChiara, Senior Site Editor IBM's multi-platform relational database management system in on the move. Newbies and gurus alike will benefit from our collection of free DB2 tips, tutorials, news analyses, webcasts, and expert advice below... Read more about this topic  Expert Technical Advice: Featured Expert Craig Mullins, Director of Technology Planning, BMC Software Category: DB2 Craig has extensive experience in the field of database management, having worked as an application developer, a DBA and an instructor with multiple database management systems, including DB2, Oracle and SQL Server. Additionally, Craig worked as a Research Director with the Gartner Group covering the field of database administration. He is the author of the DB2 Developer's Guide, the industry-leading book on DB2 for OS/390, and has published more than 100 articles on database technology. Ask Craig your tough DB2 questions! Read Craig's answers to previous questions This Week: In the forums >> How to lock record in a SQL Server table Member "kromax" is using DAO in VB and is wondering how to lock a record to prevent read/write by other users of the application? Give him your two cents in our "SQL Server Tech Forum". >> B-trees and hashing Member "jay25" which is more effective for data storage: B-trees or hashing? Give him your two cents in our "DBA Water Cooler" forum. Tip of the Week: Compare two many-to-many relationships How can you compare two many-to-many tables? Our SQL expert Rudy Limeback has the answer. >> Read complete tip  Site Highlights How much of a database guru are you...really? Think there's not much more to know when it comes to the database? Check out our Learn IT Guide and find out - explore a list of concepts and take our quiz to find out how much you've learned! Browse the guide and take the challenge! Have you registered for the Data Center Decisions conference yet? Register for the Data Center Decisions conference and find out the latest about emerging technologies within the storage space and how they will affect the data center. Register now Featured IBM DB2 tip Sign up for the DB2 Tips newsletter and get similar tips sent directly to your inbox Check out our "Leverage your SQL Server 2000 Skills to Learn DB2 UDB v8" tip and learn how to use your current knowledge of Microsoft SQL Server 2000 to quickly gain skills in DB2 UDB for Linux, UNIX, and Windows Version 8. Resources for database pros Select newsletters you would like to receive from the list below. Oracle E-Business Suite Update Database Administrator Tips Daily News E-mail    Not a member? We'll activate your membership with your subscription. Career Center The average IT salary is being hurt by offshore outsourcing - is yours? Check out SearchDatabase.com's Career Center, take our interactive salary survey and see how your salary stacks up to your peers'! Compare wages E-Business Suite Edit your member profile and activate your subscription to the Oracle E-Business Suite to receive helpful tips on Oracle applications and up-to-date news from top Oracle gurus. Sign up now! Webcast Library Missed our webcast on "Semantic information management for data integration in the enterprise" webcast? Visit SearchDatabase.com's Webcast Library and view this and other database-specific webcasts on automation, performance tuning and more. View webcasts A B O U T   T H I S   N E W S L E T T E R Contact us: SearchDatabase MemberServices 117 Kendrick Street, Suite 800 Needham, MA 02494 This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. TechTarget offers magazines, Web sites, e-newsletters, Webcasts and conferences for enterprise IT professionals. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "Updates on new site content": Go to unsubscribe: http://searchDatabase.techtarget.com/unsubscribe?track=NL-78 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed.