2019年03月11-15日週報
2019年03月11-15日週報
SQL
不要再用Session id < 50來判斷該Session是System Process還是User Process了
https://dotblogs.com.tw/rockchang/2017/11/23/132954
查詢SQL Server目前連線(Connection)狀況
https://domaxtb.wordpress.com/2015/08/04/%E6%9F%A5%E8%A9%A2sql-server%E7%9B%AE%E5%89%8D%E9%80%A3%E7%B7%9Aconnection%E7%8B%80%E6%B3%81/
sys.dm_exec_sessions (Transact-SQL)
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-sessions-transact-sql?view=sql-server-2017
Understanding SQL Server Transaction Savepoints
https://www.mssqltips.com/sqlservertip/5538/understanding-sql-server-transaction-savepoints/
【EntityFramework】DBContext Dispose與否，與DB的連線數是否有關係
https://toyo0103.blogspot.com/2016/12/entityframeworkdbcontext-disposedb.html
Do I always have to call Dispose() on my DbContext objects? Nope
https://blog.jongallant.com/2012/10/do-i-have-to-call-dispose-on-dbcontext/
C#
C#關鍵字-base的使用
https://dotblogs.com.tw/brooke/2017/09/09/103922
What does <T> denote in C# [duplicate]
https://stackoverflow.com/questions/9857180/what-does-t-denote-in-c-sharp
Generic type parameters (C# Programming Guide)
https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/generics/generic-type-parameters
C# List<T>用法詳解
https://www.itread01.com/content/1510829774.html
C# 泛型(Generics) - 教學筆記 (使用visual studio)
https://adon988.logdown.com/posts/1203957
C# 泛型（Generic）與base用法
http://www.runoob.com/csharp/csharp-generic.html
[心得整理] c# 物件導向程式 - 3.抽象與interface
https://dotblogs.com.tw/initials/2016/06/18/102618
C#中IEnumerable、ICollection、IList、List之间的区别
https://www.cnblogs.com/sunliyuan/p/5816666.html
[C#] 委派 Delegate - 簡化程式碼歷史 第一章
https://dotblogs.com.tw/initials/2017/02/05/a02_delegate
.NET Core
如何使用 VS Code 建立 .NET Core 開發環境 ?
https://oomusou.io/vscode/netcore/
ASP.NET
ASP.NET學習經驗#27----瞭解ADO.NET，常用的DataSet與DataReader
https://ithelp.ithome.com.tw/articles/10159499
SVG
設計師對 SVG 應該有的觀念
https://intersection.tw/%E8%A8%AD%E8%A8%88%E5%B8%AB%E5%B0%8D-svg-%E6%87%89%E8%A9%B2%E6%9C%89%E7%9A%84%E8%A7%80%E5%BF%B5-38ba64b48b32
Others
[奇怪事件簿] 事件0.specflow消失的來源
https://dotblogs.com.tw/initials/2016/06/14/183424
[奇怪事件簿] 事件4. 程式都寫好要簽入時，一時恍神用版控還原檔案，該如何是好？
https://dotblogs.com.tw/initials/2016/09/10/215841