# 介紹好網站：從 SQL Developer Support 發現常見開發技巧

我有訂閱 [MSDN Blogs RSS](https://devblogs.microsoft.com/feed/) 的習慣，但這個 RSS 每天都差不多會有幾十篇到上百篇的文章在這裡出現，我當然無法全部看完，所以這個 RSS 對我來說純粹是一個「隨緣」的 RSS 訂閱，但三不五時就會發現一些不錯的部落格與文章，像是今天要介紹的 [Common tips and tricks from a SQL Developer Support perspective](https://learn.microsoft.com/en-us/archive/blogs/spike) 部落格就是一例，裡面有好多跟 SQL Server 開發相關的技巧，真的挖到寶了。

這些從 Support Team 寫出來的文章都是很恐怖的，我跟微軟技術支援中心的人交涉過幾次，他們的專業度都很高，那種能做超過五年的工程師基本上都不太像人，經常讓我佩服的五體投地。:-p

雖然這裡文章不多，但對細節都有很深入的探討，而且很實用，有好幾篇文章看到時都有種相見恨晚的感覺，像我們每天都在處理跟資料有關的應用，有時後光是當 **茶包射手**(Trouble Shooter) 是不夠的，多學一些東西對日常的開發工作有很大的幫助。

以下列出一些我看過覺得不錯的文章：

-   [How to see the SQL executing when updating a DataSet via DataAdapter.Update()](http://blogs.msdn.com/spike/archive/2009/12/11/how-to-see-the-sql-executing-when-updating-a-dataset-via-dataadapter-update.aspx)
-   [How a proper physical TCP/IP connection to SQL Server works. Network Monitor](http://blogs.msdn.com/spike/archive/2009/11/06/how-a-proper-physical-tcp-ip-connection-to-sql-server-works-network-monitor.aspx)
-   [My take on @@IDENTITY vs SCOPE\_IDENTITY()](http://blogs.msdn.com/spike/archive/2009/10/20/my-take-on-identity-vs-scope-identity.aspx)
-   [Why massive inserts using SubmitChanges lack in performance.](http://blogs.msdn.com/spike/archive/2009/09/01/why-massive-inserts-using-submitchanges-lack-in-performance.aspx)
-   ["System.Data.Linq.ChangeConflictException: Row not found or changed" Finding the culprit](http://blogs.msdn.com/spike/archive/2009/09/07/system-data-linq-changeconflictexception-row-not-found-or-changed-finding-the-culprit.aspx)
-   [XQuery in SQL Server, some examples](http://blogs.msdn.com/spike/archive/2009/09/21/xquery-in-sql-server-some-examples.aspx)
-   [How to read a SQL Server trace file using .Net code, TraceFile and TraceServer.](http://blogs.msdn.com/spike/archive/2009/08/27/how-to-read-a-sql-server-trace-file-using-net-code-tracefile-and-traceserver.aspx)
-   [How to create a .Net SqlTransaction deadlock with SQL Server](http://blogs.msdn.com/spike/archive/2009/06/10/how-to-create-a-net-sqltransaction-deadlock-with-sql-server.aspx)
-   [A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)](http://blogs.msdn.com/spike/archive/2009/04/16/a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-tcp-provider-error-0-an-existing-connection-was-forcibly-closed-by-the-remote-host.aspx)
-   [(working) TCP network monitor trace explained.](http://blogs.msdn.com/spike/archive/2009/02/27/working-tcp-network-monitor-trace-explained.aspx)
-   [(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)](http://blogs.msdn.com/spike/archive/2008/12/19/provider-tcp-provider-error-0-no-connection-could-be-made-because-the-target-machine-actively-refused-it.aspx)
-   [Connectionstrings, mixing usernames and windows authentication. Who goes first?](http://blogs.msdn.com/spike/archive/2008/11/14/connectionstrings-mixing-usernames-and-windows-authentication-who-goes-first.aspx)
-   [TCP connections hanging in the CLOSE\_WAIT and FIN\_WAIT\_2 state.](http://blogs.msdn.com/spike/archive/2008/10/09/tcp-connections-hanging-in-the-close-wait-and-fin-wait-2-state.aspx)
-   [Command prompt utilities, some resources in one place.](http://blogs.msdn.com/spike/archive/2008/10/07/command-prompt-utilities-some-resources-in-one-place.aspx)
-   [Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.](http://blogs.msdn.com/spike/archive/2008/08/25/timeout-expired-the-timeout-period-elapsed-prior-to-obtaining-a-connection-from-the-pool.aspx)
-   [How to use a FileDsn in .Net](http://blogs.msdn.com/spike/archive/2008/08/01/how-to-use-a-filedsn-in-net.aspx)
-   [“Deferred vs. Immediate Loading” or “Lazy vs. Eager Loading”, simplyfied, I hope....](http://blogs.msdn.com/spike/archive/2008/09/25/deferred-vs-immediate-loading-or-lazy-vs-eager-loading-simplyfied-i-hope.aspx)