Welcome to MSDN Blogs Sign in | Join | Help

August 2004 - Posts

Thursday, August 26, 2004 10:43 AM

Rhythms Airlift

Yesterday I had the fortune of meeting Bob Beauchemin ( http://staff.develop.com/bobb/weblog/ ) for the first time. I am a big fan! I really admire his ability to simplify hard concepts into easy to digest articles and his willingness to roll down his
Posted by angelsb | 1 Comments
Wednesday, August 25, 2004 10:26 AM

Connection Pooling and the "Timeout expired" exception FAQ

System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Well, it has happened again,
Posted by angelsb | 30 Comments
Filed under:
Tuesday, August 24, 2004 8:49 PM

Using Sql Server 2005 Snapshot isolation level with ado.net 2.0

Sql Server 2005 now supports non-blocking read operations with the Snapshot isolation level. What does this mean for ADO.NET 2.0? Not much really, all of the hard work is done in the server and all we have to do is expose it. We already have a System.Data.IsolationLevel
Posted by angelsb | 0 Comments
Monday, August 09, 2004 2:46 PM

Programatically accessing ADO.NET 2.0 performance counters

I have found that many times using Perfmon with the new ADO.NET counters is not ideal, a much better approach may be to get the performance counter information directly through code. There is only one minor complication, to make it easy to differentiate
Posted by angelsb | 1 Comments
Wednesday, August 04, 2004 12:12 PM

ADO.NET 2.0 new SqlClient Provider Statistics

Presenting ODBC-style statistics for SqlClient. SqlClient statistics are strictly per connection, this should be obvious looking at how the API has been designed. Statistics are not kept for operations that are canceled or datareaders closed before their
Posted by angelsb | 3 Comments
Tuesday, August 03, 2004 5:54 PM

ADO.NET 2.0 new GetSchema method. Schema is finally a first class citizen of the managed providers.

ADO.NET 2.0 has finally added support for retrieving Schema information. In v1.1 your only option was to go through the OLEDB native provider through the GetOledbSchemaInfo class, now Schema is a first class citizen in all of the Managed Providers. using
Posted by angelsb | 9 Comments
Monday, August 02, 2004 9:27 PM

ADO.NET 2.0 new Performance Counters

Today I want to go over one of the least talked about new ADO.NET features, performance counters. This has been a black mark on the ado.net story since RTM. We found out the hard way that performance counters did not work with URT v1.0 and v1.1, it is
Posted by angelsb | 4 Comments
 
Page view tracker