This Week: Open source databases

[SearchDatabase.com]

Title: TechTarget

March 24, 2003 >> Receive this email as text  >> About this email   In this Issue >> From the Editor: DBA profiles >> Featured Topic: Open source databases >> Expert Technical Advice: New expert advice, forum posts and tips >> Site Highlights: * Profiles in data management * Database glossary * Check out our database tips  From the Editor: by Tim DiChiara, Site Editor As my colleague Sara Cushman wrote recently, our new "Profiles in data management" series is dedicated to highlighting the various types of work that you, our readers, do every day. We posted our second profile last week, on Senior DBA Kevin Mok. Kevin keeps on top of the latest IBM technology by testing beta products such as DB2 v8 in Big Blue's laboratories. With 15 years experience and a job at a protein research company, Mok also tests IBM products in the real world. If you missed it, be sure to check it out here. If you would like to nominate someone you know, including yourself, to be featured, let us know! Send an e-mail to [EMAIL PROTECTED] with a few details or interesting facts. Cheers, Tim  Featured Topic: Open source databases by Tim DiChiara, Site Editor Free, open source DBMSs such as MySQL and PostgreSQL have found significant niches in enterprise IT. Learn more with the collection of news, expert advice, and tech tips inside... Read more about this topic  Expert Technical Advice: Featured Expert Tony Bain, Senior Database Consultant, SQLServices.com Categories: SQL Server Description: Tony is a MCSE, MCSD, MCDBA and author of "VB.NET & SQL Server 2000: Building an Effective Data Layer." Ask him your tough SQL Server questions! View all of Tony's answers This Week: In the forums >> Migrating from SQL Server 6.5 to 2000 Member "Jeg" is still wondering what the best method is to do the upgrade: use scripts and BCP or use the upgrade wizard? Go to our "DBA Water Cooler" forum to offer your two cents. >> DTS workflow precedence problem Member "Gilligan" is having some SQL Server scripting problems, specifically in some if/then logic. Go to our "SQL Server Tech Forum" if you can help. Tip of the Week: This Oracle query will answer the following questions: 1) Is there enough space in my tablespaces to allocate the next N extents related to the tables that have less than M % of free space left? and 2) What percentage and amount of space will I be left with in case such allocations occur? >> Predicting the future of space usage  Site Highlights Todd Barbera on the Job Did you miss our first Profiles in Data Management? Read our first installment featuring a sr. systems administrator & Oracle DBA for a Boston-based broadcasting company. Database glossary Can't find an industry acronym in Webster's? Need the "long" definition of a technical term? Our glossary is here for you! If don't find a term in our dictionary, let us know. Our editors will find it and add it to the list! Check out our database tips section You'll find hints and tricks from other DBAs here. Share the knowledge! Read the tips and then submit your own! Recently submitted tips include: * Planning your upgrade to DB2 v7.1 * Limit access to date and time * Export all the tables in a given schema * Return all values in a comma-delimited string * Upgrading from SQL server 7.0 to 2000 Update your subscriptions Select newsletters you would like to receive from the list below. Database Administrator Tips Ask the Database Experts Daily News Email:     Not a member? We'll activate your membership with your subscription. IOUG Live! 2003 April 27 - May 1 is THE Education Conference for Oracle Users by Oracle Users. 200+ sessions in seven focus areas -- tuning, database migration, installation and more. Register before 3/28. Save $325 now! Are you ready? Prepare yourself for tomorrow's strategic and technological challenges -- Attend Data Center Futures and hear Gartner Group VP Carl Claunch's four-year industry forecast. More info Reducing costs Join us for this educational webcast discussing how you can dramatically reduce the complexity and cost of wide area data access. Join Us! 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".