Activities

July 2014
M T W T F S S
« Jun   Aug »
 123456
78910111213
14151617181920
21222324252627
28293031  

web-based MS SQL administration tool for MSSQL server 2012

images

While I’m setting up a Windows 2012 server for a small .Net project, I have a need of providing MSSQL server 2012 Express access to Developers. Following are the options normally a admin will do,

1. Create a normal user having Remote Desktop access and provide SQL user account. 2. Open Remote MSSQL server access [...]

Simple file backup script for Windows

IIS-image

Here is a tiny backup script for daily file backup in a windows environment for a small project. This script zip the folders those are to be backed and renamed it in a dated manner. Also this script will delete the old backup as well. Here I’m using 30 days retention period for this server. [...]

Running multiple Glassfish instances in a server

One of the client to want to use 3 Glassfish environment for his Dev,QA and UAT purpose. He does not wish to pay separate servers for these low priority application roles.

System requirements

1. Have more RAM (16GB is fine) and medium computing power 2. 3 static IP for 3 environments 3. Glassfish installation.

[...]

MySQL 5.5 : How do I enable slow query log

mysql-logo

Prior to optimize the performance of a busy MySQL Database server, I need to enable all the queries those consume more than 10 second to complete the execution. This server load is high most of the time and being hit on performance issue due to this load.

I’m using the server which have 32 CPU’s [...]

How do I terminate all the user process

Redmine_issue

One the user account in a Cpanel account showing errors “fork: Unable to fork new process” while the user is try to access his shell.

it’s because there would be set a shell session limit for each users in Whm/Cpanel account. on my scenario, it uses suphp in Apache settings and apache uses user [...]

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol

mysql

While I’m accessing MySQL server 5.5 remotely from a windows server which was MySQL 5.6 libraries installed, I got the following errors.

C:\Documents and Settings\Administrator>mysql -h 192.168.10.24 -ureadusr -p Enter password: ************ ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option ‘secure_auth’ enabled)

How do I skip this error and able [...]