DBA Tips: DB2 client security, SQL Server web admin, and more...

[SearchDatabase.com]

Title: DBA Tips

May 26, 2004 Published by  SearchDatabase.com DBA Tips Issue Sponsored By: SearchDatabase.com Career Center IN THIS ISSUE: DB2: Trusted clients vs. untrusted clients SQL Server: The Web Data Administrator tool Oracle: Improving PL/SQL performance by using collections Good planning, service packs help avoid DB2 outages Featured Topic: Data management career tips SearchDatabase.com Career Center How does your salary compare to those of your peers? Visit SearchDatabase.com's Career Center powered by Dice and take our salary survey. Find training, certification, resume resources and over 27,000 IT job openings to search through. Register now and access a host of career resources! Click Here DB2: Trusted clients vs. untrusted clients [Roger Sanders] This tip from examines client authentication and the ways in which Version 8.1 of DB2 UDB implements this type of security. MORE INFO: Hundreds more SQL Server tips and scripts SQL Server: The Web Data Administrator tool [SearchDatabase.com] The Web Data Administrator utility will help you with 90% of your daily tasks, making it a most useful addition to your arsenal. Oracle: Improving PL/SQL performance by using collections [Mark Rittman] Compared with Oracle7-style PL/SQL, newer code generally runs around 3-5 times faster. Why? The author looks at one reason: "collections". Good planning, service packs help avoid DB2 outages [SearchDatabase.com] Most companies have trouble keeping up with service packs, but a DB2 engineer says you should apply updates several times a year in order to eliminate costly downtime. ASK THE EXPERTS: Ask the Expert: Row-level access in DB2 Our SQL expert Craig Mullins answers the question: "Does DB2 have a mechanism for providing row-level access?" TOPICS: Featured Topic: Data management career tips The DBA life has always been challenging but now new threats are emerging. The tips and advice inside will guide you along the perilous path to becoming a database guru... Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] ABOUT THIS E-NEWSLETTER This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "DBA Tips": Go to unsubscribe: http://searchDatabase.techtarget.com/u?track=NL-94 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. Contact Us: SearchDatabase MemberServices 117 Kendrick Street, Suite 800 Needham, MA 02494