Skip to main content

Posts

Difference between SQL Handle and Plan Handle

When we execute query select * from sys . dm_exec_query_stats it will show aggregate performance statistics of cached query plans of SQL Server. The details including one row per query statement within the cached plan, and the lifetime of the rows are tied to the plan itself. Details have two column SQL Handle and Plan Handle.

Configure Impersonation Authentication in IIS8 for MVC Application

Impersonation is when ASP.NET executes code in the context of an authenticated and authorized client. By default, ASP.NET does not use impersonation and instead executes all code using the same user account as the ASP.NET process, which is typically the ASPNET account. There are 5 below steps by which we can establish Impersonation configuration in our secured application environment. 1.)    Creation of Application/Proxy user where Application is hosted. 2.)    Give appropriate access to the user. 3.)    Create Database Login user on database. 4.)    Authenticate User and provide credential on IIS. 5.)    Then Configure web.config on Application.

Microsoft Delhi UG Meet Nov 2014

Hello friend,  I have been drunk last week end ,, yeah 5 liter vodka.. Dont surprise this drunk was IT enable  drunk in Microsoft Delhi UG Meet . Still my eye not opening and thinking about meets. Like Bangalore Monthly UG Meet microsoft planned for Delhi UG also. Thease are all about through MVPs of NCR ( Deubug_mod , Sarabpreet sir , ahmed sir , brij sir and Aman sir ).. 

How to generate moving Average of Last two days

Hi friend,   These days I become little bit Lazy. The reason was my long leave from work. I visited my Hometown in Durga Puja. It was really very cheerful moment for me to meeting with parents and cousins. Please  don’t ask about my last 7 Days I was suffered with Eye-Flue. It isolated me becouse I was not  unable to use TV/Computer/Phone/Book, social media and SQL. After 6 days  now i become OK. Session of Diwali festival also comes up.  So I should wake up and write some Diwali special Query.  I started my SQL Server, opened SSMS and New Query Editor new problem ….. How to generate Running Average of Last two days?

IIS backup and Restore in 7.0

We should not expect that we required to use my backups but we should always ready for worst cases scenario either DB or IIS Server’s Configuration… In previous version IIS 6.0   we were taking Meta base (IIS Configuration) backup from GUI but later on in new version (7.0 > ) this is removed and now we are using AppCmd utility of IIS manager Service. Today i want to share about AppCmd.

Bootstrap Study for SQL Installation Error

When we install any SQL Server Instance, all installation log we can study through its Boot Strap folder which we can find from the PATH C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log .  Like Below