Pragmatic Programmer

select hostname, hostprocess from master..sysprocesses where  spid = 68 select s.host_name, s.host_process_id, t.os_thread_id, s.session_id from sys.dm_exec_sessions s join sys.dm_exec_requests er on s.session_id = er.session_id join sys.dm_os_workers w on er.task_address = w.task_address join sys.dm_os_threads t on w.thread_address = t.thread_address where s.session_id = 68;

You should reboot pc after installing URLRewrite. Origin

If types are scattered over assemblies, impose same namespace with XmlRootAttribute If derived types are, supply XmlSerializer with ExtraTypes information.

http://stackoverflow.com/questions/16222313/how-to-use-automapper-to-map-a-datarow-to-an-object-in-a-wcf-service public static Customer GetSingle(DataTable dt) { if (dt.Rows.Count > 0) return null; List<Customer> c = AutoMapper.Mapper.DynamicMap<IDataReader, List<Customer>>(dt.CreateDataReader()); return c[0]; }

SELECT * from NLS_DATABASE_PARAMETERS WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET', 'NLS_SORT', 'NLS_LANG');

http://www.iis.net/learn/manage/configuring-security/application-pool-identities

EXEC master.dbo.sp_MSset_oledb_prop N'OraOLEDB.Oracle', N'AllowInProcess', 1; EXEC sp_addlinkedserver @server = 'XE', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = '//localhost/orcl'; Exec sp_serveroption 'XE' , 'rpc' , TRUE; Exec sp_serveroption 'XE' , 'data access' , TRUE; Exec sp_serveroption 'XE' , 'rpc out' , TRUE; EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'XE', @useself = N'False', @rmtuser = N'jjs', @rmtpassword = N'jjs'; SELECT * FROM OPENQUERY(XE,'SELECT * FROM test_Tbl where p2  < 1000 and reg_dt >=' || '2012-10-01'); select * from [XE]..JJs.TEST_TBL;