=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips January 30, 2002
Essential tools and advice for the enterprise DBA: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: View a database, transact custom SQL statements - SQL Server Tip: Encrypting a string to a varbinary(128) - Oracle: Which indexes require a re-build? - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Online Event: Data warehouse security management - Ask the Expert: Oracle, SQL Server, DB2 questions answered - Featured Topic: Web services: What? Why? How? ___________________________________________________________________ ************** FREE SUBSCRIPTION TO STORAGE MAGAZINE ************** Storage is now a front and center issue. No longer "just capacity," storage is a critical IT asset that must be managed effectively. Increasingly complex, it's become a huge percentage of your overall IT budget. That's why we created Storage magazine, a new resource to help you set your storage strategy, manage storage effectively, and make key vendor selection and architecture decisions. Subscribe today FREE and as a bonus you get the FREE 42-page Storage Networking special report! Visit http://ad.doubleclick.net/clk;3802184;5058249;k?http://www.storagemagazine.com __________________________________________________________________ __________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE CODE: VIEWS A DATABASE, TRANSACTS CUSTOM SQL STATEMENTS This is a simple, free program that views a database and transacts custom SQL statements in SQL Server 2000. The SQL-VB connection established here is often the foundation of front-end applications. This project uses ADO programming techniques. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci799193,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ENCRYPTING A STRING TO A VARBINARY(128) | by Eli Leiba This code is useful when encrypting sensitive data (like passwords) into a varbinary. The PWDENCRYPT and PWDCOMPARE functions are used to encrypt and compare DATA passwords not visible anywhere in the database. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci799191,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WHICH INDEXES REQUIRE A RE-BUILD? | by Danny Mohar This script is used to determine which indexes require a re-build to assist with system performance. A ratio of 10-20% deleted lf rows to lf rows may be candidates. The script will attempt to use dynamic SQL to execute the DDL commands required to execute the analyze table commands directly. The script will then re-build the indexes above a specified level of deleted rows. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci798208,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: MULTI-ROW JOIN IN ONE COLUMN | by Sujit Mishra http://www.searchDatabase.com/tip/1,289483,sid13_gci798204,00.html All of you are aware how to join columns, but this example will show you how to join two or more rows from tables and put them in one column. GET THE SERVER'S DEFAULT COLLATION | by Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci795978,00.html Here's a SQL Server script that will get the description of the server default collation as given in setup. IDENTIFY THE USER AND SESSION ID FOR A UNIX PROCESS | by R. Stucke http://www.searchDatabase.com/tip/1,289483,sid13_gci798209,00.html This quick process identifies the Oracle user and session ID of a UNIX process that is using up a large amount of CPU. It can also be used to help find inefficient queries. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip, win a PHILIPS CD/MP3 PLAYER! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz785186_cts785185,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LIVE EXPERT Q&A | Data warehouse security management Who: Shaku Atre When: February 5, 2002 at 1:00 PM EST (18:00 GMT) Join an industry leader in a discussion about the often overlooked but essential need for security in a data warehouse environment. Learn the unique requirements of multidimensional databases and star schemas, how to balance security and access, and much more. >> CLICK: http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's toughest database questions answered DB2: Listing rows using current date, Part II http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid432119_tax285651,00.html SQL: Key factors for successful SQL http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid424593_tax285649,00.html Oracle: What is a petabyte? http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid431961_tax285650,00.html SQL Server: DTS error converting varchar to numeric http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid431626_tax285648,00.html Data Warehousing: Metadata management stategy for a bank, Part 1 http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid407871_tax288371,00.html Dozens more expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WEB SERVICES: WHAT? WHY? HOW? | SearchDatabase Featured Topic Will 2002 be the year that web services are translated from hype into reality? Wait--what are web services anyway and why do I need them? Fear not, we have the XML, .NET, & J2EE tips, tutorials, and analysis you need inside... >> CLICK for our current Featured Topic... http://www.searchDatabase.com/featuredTopic/0,290042,sid13_gci798776,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ ***** STORAGE MANAGEMENT CONFERENCE | Hosted by searchStorage ***** Ask questions and hear directly from EMC Executive Chairman Michael Ruettgers, who joins our March 20-22 Storage Management conference in Chicago. Also speaking are Giga Information Group's Bob Zimmerman; prolific storage author and speaker, Jon William Toigo; Storage Group founder W. Curtis Preston; BMC's CEO Bob Beauchamp; VERITAS CEO Gary Bloom; and many more. Don't miss out! Qualify for FREE attendance today: http://ad.doubleclick.net/clk;3829700;5058249;n?http://www.storagemanagement2002.com/html/registration.htm ___________________________________________________________________ ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Feedback and original articles. ED PARRY, News Editor (mailto:[EMAIL PROTECTED]) >> Product announcements and poll ideas. TOM CLICK (mailto:[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 2002, 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.
