The Young DBA

BLOB/Image/Videos are unstructured data. RDBMS like SQL Server is made to store relational data. File stream is new feature of SQL Server since 2008 to store large data. This is not always the best solution to store images on db. Store the pictures on the file system and picture locations in the database. My previous experience is also saying. Why? Because...

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.

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.

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.

Error:  It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS." I faced with above error while implementing VB.net+MySQL application yesterday in the company where I am working. Actually this error will come when Virtual Directory is not being configured as an ASP.NET application. To do so we have to follow below steps :- 

In Short for Daniel of Service Attack ( DoS ) is a type of attack attempt to make a machine or network resource unavailable to its intended users .  Risks Associated with Denial of Service Attacks :- Network bandwidth Server memory Application exception handling mechanism CPU usage Hard disk space Database space Database connection pool

Source : Technet

In short Page File is simply a file on the hard drive that handles situations where the system wants to move or page out sections of memory .  There are several situations that cause this, but the one you're most concerned about is when the system is out of physical memory. Tech net  Article is best to configure & monitor Paging File.

Sometimes if we require to find the windows uptime or when last booted our system we can do by net statistics server.... Just open cmd prompt from Run. and type  net statistics server . Thanks Suman