The Young DBA

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.

Shortcut is always 2 nd important things to learn any software if we started working and using in daily DBA or Development activity. Today I am sharing 3 Shortcuts of MySQL Workbench which I use always during work and last 2 query to find tables with primary and Procedures list.

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 ).. 

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?

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.

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

Below are two generic errors in every version of IIS. If we deploy applications without few configuration or setting in Application Pool & ISPAI Extension these errors will comes up. There are few changes in IIS 7/ IIS 8 but process are same.  After New installation of IIS and before deploying any Application I do below configuration in IIS 8/7 to remove these error.   The requested content appears to be script and will not be served by the static file handler.  or An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.