Tag Archives: SQL Server

Use Visual Studio Server Explorer to Add New or Existing SQL Server CE Database

By | August 7, 2011

SQL CE is a free, embedded, lightweight  database engine that enables easy database storage. This does not required any installation and runs in memory. Visual Studio 2010 SP1 Came up with nice tooling support for SQL Server CE. We can add a SQL CE Data base using Add New Item option from Solution Explorer Context Menu. But In… Read More »

How to count number of active session for State Server Session Mode ?

By | December 28, 2010

While dealing with ASP.NET Session, generaly we use Session_Start() method in Global.aspx for count the number of active session, as whenever a new session start, it invoked the Session_Start method. Generally most of the developer use an Application variable with in Session_Start method to count the total number of active session as shown in below. But, sometime, when… Read More »

How to calculate Session data size for SQL Server session mode?

By | December 27, 2010

SQL Server use ASPState database to store the session information for SQL Server Session mode. ASPState database having two tables ASPStateTempApplications and ASPStateTempSessions. ASPStateTempApplications  table contains Application ID and Application Name which is specific to each and every application which are using SQL Server session mode on the particular database. ASPStateTempSessions table having numbers of fields to store… Read More »