≡ Menu

Database

I'm a new MySQL server user. My server is running on a CentOS Linux. How can I check the number of active MySQL connections on Linux based system?
[click to continue…]

We establish connections to remote systems without supplying a password, however I do not want to store my password less keys ( passphrase-free keys) on my servers. ssh-agent, takes care of keys with passphase, which allowing me to easily have ssh-agent process per system per login session. How do I dramatically reduces the number of times I've to punch my passphrase from once per new login session to once every time my local server is rebooted? How do I use keychain utility for all my backup scripts for secure passwordless login?
[click to continue…]

MySQL Reset Root Password

I forgot the MySQL root password. How do I reset MySQL root password?
[click to continue…]

Freebsd Mount a NAS via SMB / CIFS

Q. I want to use our NAS server to store backups. Our NAS supports FTP and CIFS / SMB sharing technology. How do I mount and store files on NAS using FreeBSD? How do I automate entire procedure using a shell script? Is that doable? If so, what's the easiest solution ftp or CIFS?
[click to continue…]

MySQL: Find Out Which Table is Consuming Resources

Q. How do I find out which table is consuming resources under MySQL Database server from UNIX shell prompt?
[click to continue…]

What’s New in MS-SQL 2008

Q. Can you tell me more about MS SQL Server 2008? What's new in MS-SQL Server 2008?
[click to continue…]

Ubuntu Linux Remove Oracle Express Edition

I know how to install Oracle XE on Debian / Ubuntu Linux. But, how do I remove Oracle Express edition under Ubuntu Linux?
[click to continue…]