Lab Sql

We fight the issue in production when once in a while our Azure SQL database performance significan… Read more Active Azure Sql Connections Are Over The Connection Pool Limit

I am developing a stand alone application, using sql server compact 3.5 sp2 which runs in process. … Read more Review Of Connection Handling And Data Access Layer Using C#, Sql Server Compact 3.5

I am trying to turn my jdbc code to use Connection Pool functionality on Tomcat. My system is a jsp… Read more Jdbc Connection Pool With Sql Server 2008 Fails

I've got a windows service that regulary (every 10 sec) does a lot of db activity. I've ver… Read more Sysprocesses Table - Will It Help Me Debug Connection Pooling Issues?

I've got a really simple class that is giving a strange error. It's quite simple one and ha… Read more Nhibernate.adoexception: Could Not Execute Query --> System.indexoutofrangeexception: Id13_

A while back I asked a question about TransactionScope escalating to MSDTC when I wasn't expect… Read more Transactionscope Helper That Exhausts Connection Pool Without Fail - Help?

I just tried to make a simple schema change to a table in a SQL Server database (by using the Desig… Read more What Is The Relationship Between Open Sqlconnections In The Client App And Processes In Sql Server?

My understanding of the connection pool is; if the connectionstring is the exact same, then we reus… Read more Connection Pool – One Process – Many Threads