Skip to main content

Posts

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

Some Generic Errors in IIS 7 and IIS 8

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.

MySQL Workbench and MS Excel

I am a big fan of SOL Server since start of my career and will be long life may be god knows..  My SOL added in my resume in 2014. No doubt SOL Server is reach in feature and capabilities than MySQL. But today I am sharing you about MySQL's great feature that impressed me related to MySQL Excel Integration. MySQL is really very simple and light application, easy to manage and implement. Yesterday I was working on Excel and I seen an extra add ins option in Excel for MySQL Workbench. I followed the option. Really it impressed me.. Just see below…

Remote Access Enabling in MySQL using Workbench

MySQL became part of my skill set in 2014 . After installation of any instance of MySQL Server in Production or Test environment 2 nd most task for any DBA is to connect the Database from Remote. While i was new with MySQL it played with me a lot to do this task from remote machine. I hang over for 3 days and ask many ppl and search many site. Did telnet, ip-config, firewall et………….. but resolve my problem in easy through below process… 1 st Grant Remote Permission on Database Server 2 nd Configure Connection at client workbench to server

safe update mode updates in mySQL workbench error

Error Code: 1175  You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. above error came in MySQL Workbench 5.2. During executing update command on table using MySQL Workbench 5.2. while updating rows. update bl_user set user_email='smnjha989@gmail.com' where user_name='suman';