This week: 600 tips and scripts

[SearchDatabase.com]

Title: SearchDatabase.com

Published by SearchDatabase.com  November 15, 2004 >> Receive this e-mail as text  >> About this e-mail   In this Issue >> From the editor: OracleWorld beckons >> Featured Topic: 600 DBMS tips and scripts >> Technical Advice: Featured expert advice >> Site Highlights: * Hewlett-Packard Upgrade Assessment Resource Center * Sybase Best Web Links * 24/7 access to database experts  From the Editor: by Tim DiCihara, Editor The SearchDatabase.com and SearchOracle.com teams will in lovely San Francisco in a few weeks for Oracle's massive OracleWorld 2004 conference. It promises to be even more massive than usual this year, since the show has merged with the old AppsWorld conference devoted to the E-Business suite. Perfect for those who thought that hanging out with 15,000 of your fellow database geeks just wasn't enough stimulation. Indeed, there will be a lot to absorb: 400 technical sessions, 250 vendor exhibits, histrionics from all the top brass at Oracle and keynotes by a "who's who" of the IT executive ranks, including Carly Fiorina, Michael Dell, Scott McNealy, and Joe Tucci. The concert this year is by the band Tears for Fears, continuing the perplexing early-80s theme from last year when the Violent Femmes played. (At least it beats the mid-70s theme from 2002 when -- gasp! -- Journey and Cheap Trick were featured.) It will be information and sensory overload, as usual. If you're going, email me and perhaps we can meet, or pull me aside if we cross paths at the show. (Although, as you can tell from my photo, I don't exactly stand out in this sort of crowd!) I'd love to chat about the state of the business, your plans for 2005, what you look for in a web site, how SearchOracle.com can improve, whatever's on your mind. Till next week, Tim  Featured Topic: 600 DBMS tips and scripts by Tim DiChiara, Editor Looking for that perfect script that will make your life as a DBA or database developer just a tad easier? Well, you've come to the right place. We offer over 600 Oracle, DB2, SQL Server, and SQL tips, free for the taking. Enjoy! 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! Ask Craig a question Featured expert advice >> Ask the Expert: Reverse engineering Sybase Our Sybase expert Mich Talebzadeh answers a question about figuring out the structure of an inherited ASA database. Tip of the Week: Implementing Oracle's MINUS set operator in T-SQL This article describes how to implement the MINUS set operator that exists in Oracle SQL but unfortunately not in SQL Server 2000 T-SQL. >> Read the full tip  Site Highlights Hewlett-Packard Upgrade Assessment Resource Center How do you know whether or not an upgrade will increase your shop's productivity or reduce security vulnerabilities? Check out Hewlett-Packard's Upgrade Assessment Resource Center and read various white papers and case studies that outline how to make the best possible decision. Visit the resource center 24/7 access to database experts SearchDatabase.com's Rudy Limeback is available 24/7 to address your toughest SQL scripting questions. Pose your question now! Sybase Best Web Links Pose your question now! Don't waste your time scouring the web for Sybase resources -- visit SearchDatabase.com's Best Web Links. Resources for database pros Select newsletters you would like to receive from the list below. SQL Server White Paper Alerts SQL Server Webcast Alerts E-mail    Not a member? We'll activate your membership with your subscription. Database glossary Swimming in a sea of database jargon? SearchDatabase.com has your lifejacket. Check out the SearchDatabase.com Glossary and find definitions for hundreds of database specific terms. Browse terms White papers Check out the free database white papers available at SearchDatabase.com. Topics covered include: Data storage, Database administration, Enterprise Java, and much more. Read more Free Newsletters Sign up for free newsletters at SearchDatabase.com today. Get news and tips that matter to you. Newsletters include: DBA Tips, Today's News, Ask the Experts, and much more. Sign up now   A B O U T   T H I S   N E W S L E T T E R Contact us: SearchDatabase Member Services 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?cid=497325&lid=430848&track=NL-78&ad=497325 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.