=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tip October 10, 2001 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
************ Sponsored by VERITAS *************** VERITAS Software Corporation is the leader in essential storage software solutions that enable customers to protect and access their business-critical data. Offering end-to-end storage products and solutions that meet the specific storage management needs of database applications. VERITAS provides customers with tools designed to optimize the performance of their applications, ensure 24x7 availability, and enables cost efficient data management in today's data-driven economy. http://ad.doubleclick.net/clk;3434985;5058249;u?http://www.veritas.com ************************************************* Welcome to searchDatabase.com's Database Administrator Tips newsletter! Three tips submitted by members this time -- check them out online and submit your own: http://searchdatabase.techtarget.com/tips =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THIS WEEK'S DBA TIPS "Be careful of the LIKE operator" by Hisham Sharifdeen http://www.searchDatabase.com/tip/1,289483,sid13_gci774748,00.html Watch out for this "gotcha" when using the LIKE operator in Oracle. Hint: make sure that the matching character string is not equal to the defined length of the database column. "Moving master logins" by Ray Higdon http://www.searchDatabase.com/tip/1,289483,sid13_gci774739,00.html Having a problem trying to migrate SQL Server logins and roles in the master database to a new server? What about migrating them so they are attached to the right databases? Here's how. "Calculating the number of working days in a month with SQL" by Sanjay Raj http://www.searchDatabase.com/tip/1,289483,sid13_gci774742,00.html There is a simple way in SQL to calculate the number of working days in a given month and year. This code can also pick up the holidays (like the 4th July) using a HOLIDAY table and then substract them to give the actual number of working days in a particular month and year... Share your knowledge: Submit your own tip. The best tipster this month will win a Visor Deluxe PDA! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz773507_cts773500,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEPTEMBER'S TOP-RATED TIPS PRIZE WINNER: "How to resolve 'user or role already exists' errors" http://www.searchDatabase.com/tip/1,289483,sid13_gci770923,00.html RUNNER-UP: "Restricting IP addresses from Oracle databases" http://www.searchDatabase.com/tip/1,289483,sid13_gci770955,00.html RUNNER-UP: "Calling Java stored procedures from triggers" http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci772163,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE DATABASE TOP FIVE | SearchDatabase Featured Topic What's on the minds of database administrators and developers? We tracked your queries of our search engine and tabulated the top five database terms. No surprise, SQL was number one. Lots of SQL info and much more inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci774054,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LIVE EXPERT Q&A | Building a Metadata Repository Step-by-Step Who : Shaku Atre, President, Atre Group When: Oct 18, 2001 at 1:30 PM EST (18:30 GMT) The management of "data about data" is critical to a successful data warehouse implementation. Join an industry leader in this Q&A about the seven steps to take when designing an effective metadata strategy. http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= NEW NEWSLETTER | Oracle Tips A brand-new, free monthly newsletter for Oracle DBA's and developers, chock full of advice from the experts and the Oracle community. To subscribe, just log in to your account and check off 'Oracle Tips' in the Tips & Columns section. http://searchdatabase.techtarget.com/register/1,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THIS WEEK'S FEATURED BOOK | searchDatabase.com Bookstore Title: Database Systems: A Practical Approach to Design, Implementation, and Management Authors: Carolyn Begg & Thomas Connolly "Database Systems" provides a practical, hands-on approach, making it uniquely suited to providing a strong foundation in good database design practice. A clear introduction to design implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable complete reference for database students and professionals alike. The new edition of this bestseller brings it up to date with the latest developments in database technology and builds on the clear, accessible approach that contributed to the success of previous editions. http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog%5Fname=Books&product%5Fid=0201708574&partner_id=77 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM CONTACTS TIM DICHIARA, Site Editor ([EMAIL PROTECTED]) >> Send us your original articles and best practices. ED PARRY, News Editor ([EMAIL PROTECTED]) >> Send in your product announcements and poll ideas. GABRIELLE DERUSSY ([EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ABOUT THIS NEWSLETTER Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2001, All Rights Reserved. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
