Multi language in ASP.NET

Oracle tips

sqlplus username/password@connect_identifier spool output.log select * from users; spool off; --disable escape parameter SET DEFINE OFF Check language setting for Oracle select value from nls_database_parameters where parameter='NLS_CHARACTERSET'; Oracle SQL Developer Tools for Visual Studio 2013 - MSI Installer http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html 1.Remeber to commit after execute the scripts

ETL Tools

Fully Automated ETL Testing: a Step by Step Guide

Performance of bulk operations

1. Efficient way to bulk load data in .NET using SqlBulkCopy: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx This SqlBulkCopy outperforms the ADO.NET SqlDataAdapter bulk operations a lot. Check out the performance analysis in this link: http://sqlblog.com/blogs/alberto_ferrari/archive/2009/11/30/sqlbulkcopy-performance-analysis.aspx looks very impressive. 2. Bulk Insert using SSIS: http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server (impressive 22GB in over 8 minutes) 3. Data Loading Performance Guide: http://msdn.microsoft.com/en-us/library/dd425070.aspx