DBA Tips: Mapping SQL Server user and login security, and more...

[SearchDatabase.com]

Title: DBA Tips

December 15, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     IN THIS ISSUE:   >  SQL Server: Mapping user and login security   >  Write query results to Excel using a linked server and T-SQL   >  The case for data stewardship   >  Learning guide: Oracle performance tuning   >  DROP versus TRUNCATE table   >  PeopleSoft, JDE customers leery of Oracle support SPONSORED BY:  SearchDatabase.com Product and Vendor Guide Simplify the process of finding specific database products and solutions. SearchDatabase.com's Product and Vendor Guide allows you to search listings alphabetically, and by industry or across such topics as database tuning, data warehousing and more. Visit our easy-to-use guide now! SQL Server: Mapping user and login security [Baya Pavliashvili] Having problems with database users that aren't mapped to logins? You aren't alone. Here is an overview of the problem and a quick solution. MORE INFO: > Hundreds more SQL Server tips and scripts Write query results to Excel using a linked server and T-SQL [Eli Leiba] This procedure is useful as a general tool for exporting SQL Server data to an Excel spreadsheet since the BCP utility can only export to a text file. The case for data stewardship [SearchDatabase.com] What does bad data cost your organization? Where does it come from? How can you fix it? A designated data steward just may be the answer. Learning guide: Oracle performance tuning [SearchOracle.com] A slow DBMS is not only annoying to users, it can affect your company's bottom line. This exclusive Learning Guide can help newbie and expert DBAs establish a smart approach to performance tuning, use and interpret Oracle's tuning utilities and identify specific problem areas. ASK THE EXPERT:  DROP versus TRUNCATE table Our Sybase expert Mich Talebzadeh answers the question: "What is the difference between the drop and truncate table commands?" INDUSTRY NEWS:  PeopleSoft, JDE customers leery of Oracle support As Oracle seals a $10.3 billion deal with PeopleSoft, customers are clamoring over future support of their business software. 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?cid=499997&lid=430854&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 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494