摘要：
If our web site hosted on web server canot be accessed by other computer by public network, one of the possiblity is the firewall setting is not confi... 阅读全文
摘要：
As a so exciting dream, I would like set up my owned web site which can be accessed anywhere nomatter from laptop/mobile phone or tablet. Current now ... 阅读全文
摘要：
You know as a beginner to learn WCF, the first thing is to make a simplest WCF service work like a classic "Hello World" console application. Now I wi... 阅读全文
摘要：
"Serilog": { "MinimumLevel": { "Default": "Information", "Override": { "Microsoft": "Warning", "System": "Warning" } }, "Enrich": [ "FromLogContext", 阅读全文
摘要：
using Newtonsoft.Json;using Newtonsoft.Json.Converters;using Newtonsoft.Json.Serialization;using System;using System.Collections.Generic;using System. 阅读全文
摘要：
SELECT des.program_name , des.login_name , des.host_name , COUNT(des.session_id) [Connections]FROM sys.dm_exec_sessions desINNER JOIN sys.dm_exec_conn 阅读全文
摘要：
OS: Deepin LinuxIDE: Intellij IdeaProject: SpringBoot based maven project Issue: cannot debug in Idea, but run is OKIdea 2017.2.4:java.lang.ClassNotFo 阅读全文
摘要：
1. netstat -aon|findstr "1080" 2. taskkill /pid 2372 /F // need replace the PID according to the results of first step 阅读全文
摘要：
Issue: Resolution: 1. Open the system variables, find the Path and edit it, add below item : C:\Users\hp\AppData\Local\Android\Sdk\emulator 2. Special 阅读全文
摘要：
对各种连接的理解，可以参照文章。 下面是对连接结果表条数统计的思考：假设有主表Ta有5条记录，从表Tb有4条记录 Ta corss join Tb, 结果为2表做笛卡尔积，5*4=20条 /*下面其它连接返回的结果都是cross join的子集*/ Ta inner join Tb, 结果分为有重复 阅读全文
摘要：
1. 尽可能把数据的存储和计算放入Memory而不是Disk，且减少IO操作，比如运用Redis等缓存技术 2. 对数据表进行精心设计，特别是大数据表，对常用数据字段进行适当的冗余，尽可能避免分表导致的Join查询，即使非Join不可也是大表和小表Join，而不是一堆大表之间Join 3. 对常用查 阅读全文
摘要：
System.Runtime.Serialization.SerializationException: Type is not resolved for member 'Oracle.ManagedDataAccess.Client.OracleException,Oracle.ManagedDa 阅读全文
摘要：
Root cause: the site refused the connection from the http request origin, by default it is setted as below: Origin: chrome-extension://aicmkgpgakddgna 阅读全文