글

How to trace DLL loading problem.

https://stackoverflow.com/a/1527249 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion Add: DWORD ForceLog set value to 1 DWORD LogFailures set value to 1 DWORD LogResourceBinds set value to 1 DWORD EnableLog set value to 1 String LogPath set value to folder for logs (e.g. C:\FusionLog\)

Index 사용 현황 조회하기.

SELECT i.name, s.* FROM sys.dm_db_index_usage_stats s inner join sys.indexes i on i.object_id = s.object_id and i.index_id = s.index_id where s.object_id = Object_id('WACORe_Main.dbo.TB_Main_appointment'); https://blogs.msdn.microsoft.com/sqlserverstorageengine/2007/04/20/how-can-you-tell-if-an-index-is-being-used/

To programmatically configure NLog

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using NLog; using NLog.Config; using NLog.Targets; namespace NLogger {     class Program     {         static void Main(string[] args)         {             var config = new LoggingConfiguration();             var consoleTarget = new ColoredConsoleTarget("Console");             var fileTarget1 = new FileTarget("File1");             var fileTarget2 = new FileTarget("File2");              config.AddTarget(consoleTarget);             config.AddTarget(fileTarget1);             config.AddTarget(fileTarget2);             consoleTarget.Layout = @"${date:fo...

SQL 서버의 프로세스ID와 OS의 프로세스ID 맵핑

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;

To use IIS as redmine proxy

이미지
You should reboot pc after installing URLRewrite. Origin

Tips about .net XmlSerialization with derived types

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

From DataTable to POCO via AutoMapper

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]; }