how to check open port on ubuntu

simply  run this CLI

netstat -anltp | grep "LISTEN"

Create different VLAN on SCVMM 2012

Today i finally made it to add 1 or more VLAN inside my SCVMM 2012 machine. If you have 2 or more vlan such as 100, 250 and etc LAN you guys can simply add using below link.

Thank You very much for this useful knowledge and information

http://www.windowsitpro.com/article/system-center/logical-network-system-center-virtual-machine-manager-2012-142076

Installing MSSQL 2008 on Windows 2008 R2

i just copy the link from this site http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide-part-2.aspx

Thanks

Enable Virtual Support on Proliant 380 G5 Server

Enable Virtual Support on Proliant 380 G5 Server

http://itbod.wordpress.com/2009/10/07/how-to-enable-the-intel-vt-virtualisation-feature-on-a-supported-hp-proliant-server-running-esx-3-5-so-that-64-bit-guest-vm%E2%80%99s-can-run/

Grant mssql user in mssql db

Configuring user permissions for Microsoft SQL Server

Microsoft SQL Server defines SQL Server Agent roles that govern accessibility of the job framework. The SQL Server Agent jobs are stored in the SQL Server msdb database.

To install Websense Log Server successfully, the user account that owns the Websense database must have membership in one of the following roles in the msdb database:

SQLAgentUserRole

SQLAgentReader Role

SQLAgentOperator Role

Dumping the database structure for all tables with no data

Dumping the database structure for all tables with no data

Add the -d flag to signify that no data should be included in the output like so, where "mydatabase" is the name of the database to dump, and "someuser" is the login name used to connect to the database. The following command will dump the table structure for all tables in the specified MySQL database:

mysqldump -d -u someuser -p mydatabase

The -d flag says not to include data in the dump. Alternatively you can use --no-data instead if you find that easier to remember:

mysqldump --no-data -u someuser -p mydatabase

The -u flag indicates the username and the -p flag that a password will be supplied. After pressing you will be prompted for the password.

Alternatively, the password can be supplied on the command line, but there must be no space between the -p flag and the password. For example, if the password was "apples" do this:

mysqldump --no-data -u someuser -papples mydatabase

Clean URL drupal for ubuntu

clean URL inside ubuntu for drupal

http://drupal.org/node/134439

20 Linux System Monitoring Tools Every SysAdmin Should Know

Click Here guys.. a must know for system admin

Set / Change / Reset the MySQL root password on Ubuntu Linux

 Tested On

- Ubuntu Linux 7.10 Gutsy Gibbon and MySQL 5.0.45. (2007-10-21)
- Ubuntu Linux 6.06 Dapper Drake and MySQL 4.1.15.
- Ubuntu Linux 10.04 LTS Mysql 5.1

Virtual hosting with IIS

Virtual hosting with IIS (Internet Information Services)

NOTE: Only IIS versions for Windows Server and Windows Vista support multiple web-sites as described below.

If you are using Windows 98, Me, NT4 Workstation, Windows 2000 Professional, or Windows XP please see reference article below instead.

"Virtual hosting" means hosting multiple web-sites with different domain names on the same IP address.

This procedure is also described in Microsoft KB article Q190008

From the "Internet Information Services (IIS) Manager" window, right click on a web-site, and select "Properties":

In the web-site Properties dialog, click the "Advanced..." button:

In the "Advanced Web Site Identification" dialog, select the first "identity", and click the "Edit" button:

Enter the web-site domain name in the "Host Header Name" field:

Click the OK button in all the dialogs to save your changes.

Create additional web sites the same way.

Thanks to http://www.simpledns.com/kb.aspx?kbid=1149

Monitor All SQL Queries in MySQL

Microsoft’s SQL Server has a tool called Profiler that you can use to monitor every SQL query that hits the database. This is extremely useful for programmers as well as database administrators to troubleshoot the exact queries generated by an application.

Having switched to using MySQL on a frequent basis, this was one of the first things I wanted to figure out how to do. How else can you see the actual SQL code generated by WordPress or phpBB?

The first thing we’ll need to do is turn on logging of queries in MySQL. Be warned that this should only be done in development… it really slows things down to log every single query to a file.

Find and open your MySQL configuration file, usually /etc/mysql/my.cnf on Ubuntu. Look for the section that says “Logging and Replication”

#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.

log = /var/log/mysql/mysql.log

Just uncomment the “log” variable to turn on logging. Restart MySQL with this command:

sudo /etc/init.d/mysql restart

Now we’re ready to start monitoring the queries as they come in. Open up a new terminal and run this command to scroll the log file, adjusting the path if necessary.

tail -f /var/log/mysql/mysql.log

Now run your application. You’ll see the database queries start flying by in your terminal window. (make sure you have scrolling and history enabled on the terminal)

I’m impressed, phpbb3 has fairly tight, optimized SQL code. WordPress, on the other hand, is very inefficient.

Taken & credit to http://www.howtogeek.com/howto/database/monitor-all-sql-queries-in-mysql/

FreeBSD: Upgrade from 8.2 to 9.0

If you use this command to upgrade to latest release FreeBSD 9.0:

$ freebsd-update -r 9.0-RELEASE upgrade

You might see following error:

The update metadata is correctly signed, but failed an integrity check. Cowardly refusing to proceed any further.

This error indicate that it cannot accept % and @ characters which appear in FreeBSD 9 . To overcome this, run following command:

$ sed -i '' -e 's/=_/=%@_/' /usr/sbin/freebsd-update

Now start the upgrade process:

$ freebsd-update -r 9.0-RELEASE upgrade

Accept all prompted values and follow the wizard. This process downloads all files and patches required for upgrade so it takes time. You might need to press ‘Enter’ once to check /etc/hosts file. Once complete, run following command to start installing the updates:

$ freebsd-update install

After a while, you should see the system will prompt something as below:

Installing updates...rmdir: ///boot/kernel: Directory not empty   Kernel updates have been installed. Please reboot and run "/usr/sbin/freebsd-update install" again to finish installing updates.

Reboot the server:

$ init 6

Once up, it will boot to FreeBSD 9. Run again the installation command:

$ freebsd-update install

After the process completed, the system will ask you to build back all your application which installed using ports. Once done, you need to rerun again the above command to complete the upgrade process and you should something like below:

$ freebsd-update install Installing updates... Done

Your update should be completed now. To check the new version, run following command:

$ uname -r 9.0-RELEASE

Credit to : http://blog.secaserver.com/2012/02/freebsd-upgrade-8-2-9-0/

repairing mysql database

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases