THIS WEEK: Spotlight on DB2

[SearchDatabase.com]

Title: TechTarget

October 21, 2002 >> Receive this email as text  >> About this email   In this Issue >> From the editor: San Francisco or bust? >> Featured Topic: Spotlight on DB2 >> Expert Technical Advice: New expert advice, forum posts, and tips >> Site Highlights: * Live Webcast: Calculating your ROI in a SAP-BI initiative * Capacity and performance planning for Web services * Live Webcast: Tom Kyte answers your Oracle9i questions  From the Editor: by Tim DiChiara, Site Editor The SearchDatabase.com team is headed over to San Francisco in a few weeks for Oracle's massive (and newly renamed) OracleWorld conference. Perhaps "massive" might not be the right term this year. It's a fait accompli that trade show attendance is way down for a litany of dismal reasons: the U.S recession, the continuing dot bomb era, terrorism threats. Despite 400 technical sessions, 250 vendor exhibitions, keynote histrionics by all the top brass from Oracle -- including Larry Ellison, who will be "live from New Zealand" for some reason -- and even "rock and roll Karaoke," anecdotal evidence is that OW will be no exception to the downward spiral. I recently polled SearchDatabase.com's Oracle experts and almost all weren't attending this year due to budget cuts. What do you think about trade shows these days -- are they worth the considerable expense? Is your department's travel budget going to be cut next year? Which ones do you find the most useful and why? Pop on over to our DBA Water Cooler discussion forum and offer your proverbial two cents. Thanks, and have a great week, Tim  Featured Topic: Spotlight on DB2 by Tim DiChiara, Site Editor DB2 is IBM's fast-growing, multi-platform, Web-ready relational database management system. 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 Mike Hotek Director of Database Operations, AdOutlet Category: 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 >> Transposing Oracle data Member "nm" needs to transpose data in columns in his table across rows. Is there any easy way of doing this? Go to our "DBA Water Cooler" forum if you can offer any advice. >> Encryption in SQL Server Member "navee" has a SQL Server 7 app using the ENCRYPTION keyword in the create procedure declaration and he wants to make all of them encrypted. Go to our "DBA Water Cooler" forum if you can help out "navee". Tip of the Week: In this first part of a new series, author Craig Mullins introduces the techniques for optimizing the performance of any database. >> Optimizing database performance, part 1: Partitioning and indexing  Site Highlights Calculating your ROI in a SAP-BI initiative Hari Guleria discusses calculating ROI in your data warehouse in Thursday's webcast Simplify BI ROI calculations with an ROI methodology using business processes and end-user deliverables as basic drivers. Capacity and performance planning webcast Tomorrow - Find out how you can make sure your next Web services project succeeds Identify and address potential performance problems, accommodate usage peaks, define SLAs and optimize trade-offs. Exclusive webcast with Oracle guru Tom Kyte This Wednesday at 1:00 p.m. EDT, Tom Kyte answers your questions Upgrading to Oracle 9i? Make sure you're getting all the functionality and performance you should. Tom Kyte, one of the world's foremost Oracle experts, is talking 9i and answering user questions in this webcast. Pre-register today. Bill Inmon Seminar Learn critical success factors for analytics Nov 18-22 with Bill Inmon, Computer Associates, Hyperion & Sagent. Learn how to leverage your data warehouse to gain a competitive edge. Register today Sneak Preview Check out the new sessions and top speakers coming to Web Services Decisions 2003. Members apply now for FREE attendance. Register early Oracle Report Card What do Oracle users think about Oracle? See the results of our recent survey. Learn more 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".