=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tip September 19, 2001 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Welcome to the searchDatabase.com Database Administrator Tips newsletter! This week, we offer you not one, but three tech tips for your education and entertainment. Don't forget that we're giving away a Toshiba DVD player at the end of the month, so be sure to submit your own Oracle, SQL Server, DB2, or database development tip today! *********** Sponsored by SyncSort *************** *** FREE Syncsort Trial and FREE Flashlight!*** Mine Web data Fast! Companies like Microsoft are using SyncSort, to sort, select, reformat, clean, standardize and aggregate web data super-fast. For a FREE product trial, and a FREE flashlight to remind you that SyncSort can shine a light on buried information nuggets fast, click here: http://www.syncsort.com/tga910 ************************************************* THIS WEEK'S TIPS SUBMITTED BY SEARCHDATABASE.COM MEMBERS: "Comparing the contents of two tables with SQL" http://www.searchDatabase.com/tip/1,289483,sid13_gci770903,00.html With a nod toward set theory, member Eli Leiba submits a SQL code snippet that allows you to determine if the contents of two tables is the same (assuming they have the same structure). "How to resolve 'user or role already exists' errors" http://www.searchDatabase.com/tip/1,289483,sid13_gci770923,00.html Member Carla Cahill submitted this tip: "There are several instances when you may encounter SQL Server errors indicating that a user or role already exists. This is likely after restoring a database from another server without a master DB. When you attempt to add a login or to set permissions, you receive an error stating that the user or role already exists. In many cases, you are unable to drop the login or role without going into system tables. But wait! There is a better and cleaner way, one that not too many people seem to know about..." "Restricting particular IP addresses from Oracle databases" http://www.searchDatabase.com/tip/1,289483,sid13_gci770955,00.html Have you ever wanted to control whether or not particular IP addresses can connect to your Oracle database? Sameer Wadhwa shows you first how to allow, then how to restrict, single or multiple IP addresses. Share your knowledge: Submit your own tip. The best tipster this month will win a Toshiba DVD player! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html ================================================ SPONSORED BY: **Storage Decisions 2001** ================================================ TIME IS RUNNING OUT to qualify to attend the FREE Storage Decisions 2001 conference in Chicago September 26-28. Learn to set strategy/make the smartest decisions to most effectively manage your storage initiatives for 2002. Pre-qualified audience of your peers and NO vendor sales pitches. Don't get shut out at this critical event. Visit: http://ad.doubleclick.net/clk;3230220;5058249;w?http://www.StorageDecisions2001.com today! ======================================= MORE GREAT STUFF ON SEARCHDATABASE! ======================================= This week's Featured Topic: "SQL Server tips and tricks" Although the PASS conference was cancelled this week for obvious reasons, we've got your SQL Server needs covered. Scads of free tips, tutorials, and advice about SQL Server performance tuning, design, stored procedures, and much more are inside... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci769983,00.html Did you miss Bill Inmon's excellent presentation about the "Top ten data warehousing success factors"? Check out this archived version, complete with audio and PowerPoint presentation: http://searchdatabase.techtarget.com/onlineEventsTranscriptSecurity/1,289693,sid13_gci760304,00.html "OO for application development, not database management" http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci769023,00.html In Fabian Pascal's latest column, he writes: "We rarely hear about OODBMS's anymore. On the rare occasion when we do, they're still not ready for prime time and for good reason: they *can't* be!" WIN A TOSHIBA DVD PLAYER: Share your knowledge, help your peers, and compete to win a $200 DVD player. Submit your technical tip today: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz764692_cts764388,00.html Over 200 DBA, developer, Oracle, DB2, and SQL Server tips FREE to searchDatabase members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html NEW: Hundreds of hand-picked and reviewed resources about every aspect of data warehousing and business intelligence, including ETL, data quality, ROI, OLAP, star schemas, and much more: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281567,00.html Take our advanced database quiz! http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci768715,00.html Thought our first quiz was too easy? This one is guaranteed to strain the limits of your database knowledge. Let us know how you do! ======================================= LEARNING ZONE FEATURED BOOK OF THE WEEK ======================================= "Oracle 9i SQLJ Programming" By Nirva Morisseau-Leroy Take advantage of greater programming capabilities with SQLJ--a standard language specification that embeds SQL statements in Java--in the Oracle 9i environment. Officially authorized by Oracle Corporation, this authoritative resource explains how to develop hosted applications, achieve remarkable scalability, implement real-time business intelligence features, and reach a new level of programming functionality. Get comprehensive coverage of SQLJ programming techniques, including SQL programming and development, SQLJ stored programs, triggers, and object-relational processing. Oracle9i SQLJ Programming will help you control each piece of the development process. Discover the benefits of Oracle's highly developed SQL-embedded Java programming standard. http://www.digitalguru.com/product_detail.asp?catalog_name=Books&category_name=&product_id=0072190930&partner_id=77 ================================================ If you would like to sponsor this or any TechTarget newsletter, please contact Gabrielle DeRussy at [EMAIL PROTECTED] ================================================ 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.
