How to Reduce Connection Pools Hitting Multiple Databases

Microsoft’s connection pooling built in to the .Net Framework greatly improves performance by allowing hundreds of database calls to share the same pool of connections used to connect to the database. The .Net Framework creates a new pool of connections for each unique connection string. This works fantastic when your web application connects to a […]

Read more
Few Errors in SQL Server and How to Fix it

When starting to work with Entity Framework and SQL Server, you often run into the same errors. Sometimes these errors are caused by missing permissions for the database connection, and sometimes it’s caused the way that the database is accessed. In this article, we will go through some of the most common errors and some […]

Read more