DBA Tips: Passing parameters using simple T-SQL XML parsing, and more...

[SearchDatabase.com]

Title: DBA Tips

December 21, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     IN THIS ISSUE:   >  Passing parameters using simple T-SQL XML parsing   >  SQL Server: Mapping user and login security   >  Build DB2 Web apps using free utility -- WOW!   >  Oracle partitioned table details   >  Oracle on Linux vs. Windows ROI and TCO   >  MySQL exec: Open source to be New Year's resolution for many 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! Passing parameters using simple T-SQL XML parsing [Eli Leiba] This article describes an alternative way of passing a varying number of input parameters from one SQL Server T-SQL stored procedure to another by using the built-in OPENXML T-SQL row set statement. MORE INFO: > Hundreds more SQL Server tips and scripts 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. Build DB2 Web apps using free utility -- WOW! [Paul Holm] With the DB2/400 world moving away from green screen toward browser-based Web interfaces, wouldn't it be great if there were a way to have Query/400 available on the Web? Well something very similar is available -- and it's free. Oracle partitioned table details [Ravi Nookala] It is difficult to display the details of a partitioned table without repetition of column values. This PL/SQL block displays all the details of a given partitioned table in one shot. ITKNOWLEDGE EXCHANGE:  Oracle on Linux vs. Windows ROI and TCO Check out this discussion currently raging on ITKE: "Does anybody have info about Oracle on Linux vs. Windows ROI and TCO? What about performance? I would appreciate facts beyond Larry betting on Linux and something specific about Oracle since I'm not comparing the OS, but the performance Oracle has on both platforms." If you'd like to participate in discussions like these, join ITKE today! INTERVIEW:  MySQL exec: Open source to be New Year's resolution for many It was a year of milestones for the open source database MySQL. The company's Zack Urlocker discusses what 2004 meant for MySQL, what to expect in 2005 and why he believes companies will choose open source as their New Year's resolution. 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=500422&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