THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Ado.Net   (RSS)
  • After the timeout

    After the timeout, we may sometimes, but not always, end up with an outstanding transaction. If this is the case, we need to rollback the transaction ourselves. Otherwise the consequent commands which use the same connection might not work as expected. Let us debug through some client code and see what is happening in more ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on January 9, 2013
  • Slides and demos from AD-401: ADO.NET 2.0 Enhancements for SQL Server 2005

    I just got a request for my slides and demos from PASS, so I figured I would post a link to them here in case anyone else wants to check them out.The demos cover protected data sections, SqlConnectionStringBuilder, MARS, SqlBulkCopy, and SqlDependency.  Just for the record: I make no guarantees about the quality, usefulness, or lack of bugs ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 20, 2006
  • SqlDataReader performance tips

    I just posted a few SqlDataReader performance tips in response to a newsgroup post; I think they're some pretty good tips, so I'll repeat them here. These tips were gleaned from using both Lutz Roeder's Reflector and Compuware's DevPartner Profiler Community Edition. Both of these packages are free, excellent additions to the toolbox ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
Privacy Statement