Skip to main content

Posts

Showing posts from February, 2016

Slow Web Based Java Applications | Solution

Hey All, Another day for the issues and resolution. This time - JAVA Applications Issue : JAVA Applications (e.g. Primavera Web Portal, EMC Unisphere Management Console, etc.) takes too long time to open / respond. Scenario : Web Based Java Applications getting accessed from Client Machines having JAVA 7 Update 25+ and above JAVA Based Intranet / Internet Applications Resolution :  Open Java Control Panel : Start ==> Configure Java 1) Enable client side Java Applet caching (If not enabled)   2) Disable Online Certification Check (Online Certificate Status Protocol)   3)  Click OK. Restart your browser. Open the application. It may take time for the 1st time. Subsequent loads should be faster. Cheers!!! Let me know if this solution worked for you.  

Script to attach multiple databases in 1 Click | SQL Server | Migration

Dear All, Scenario : Source Server : SQL Server 2008 R2, Windows Server 2008 , Destination Server : SQL Server 2014, Windows Server 2012 R2 We are in process of SQL Server Migration from 2008 R2 to 2014 We faced situation that we had to attach 600+ databases to newly created setup, which would require 10+ Hrs. Then i decided to create script for it. Thanks to google, I got ready made information from Michelle Gutzait (https://www.mssqltips.com/sqlservertip/1786/auto-generate-sql-server-database-attach-and-detach-scripts/#comments) And comment from James E. Satterthwaite helped me for my requirement. Hope that this helps for you too. ================ Solution ================ Goto SQL Server Management Studio on the Source Server and Run this query on the required instance. -- ******************************************************* -- Script for attaching multiple Databases at a time -- Do following if you want to relocate DB and log files elsewhere -- FIND    H:\