DebugView for Windows

DebugView for Windows v4.76

If you are a developer, you will find this tool very useful.

DebugView is an application that lets you monitor debug output on your local system, or any computer on the network that you can reach via TCP/IP. It is capable of displaying both kernel-mode and Win32 debug output, so you don't need a debugger to catch the debug output your applications or device drivers generate, nor do you need to modify your applications or drivers to use non-standard debug output APIs.

To use DebugView in your code, put some trace messages where you want to have some log informations, like

System.Diagnostics.Trace.Write("This is my trace log message");

You need to have the application open to see your messages.

Get emails from Hotmail in Gmail account

Lets get a little bit out of this blog topics, and learn how to config a gmail account to receive your @hotmail or @live account emails.

In your Gmail account, go to Settings and choose the accounts tab.

To config the Gmail to Send mail as:
Click on the blue link "Add another email address you own".
Write your Name and your hotmail ou live email address, in the text boxes.
Gmail will make a verification of the email address you just wrote.
After you've made all the steps to verify that you own this email address.
It's all done.

To config the Gmail to Get mail from other accounts:
Click on the blue link "Add another email address you own".
Write the email address you own. And go to the next step.
In here, you have to fill three text boxes: Username, Password and PopServer.
Fill in the Username with your email address, like me@hotmail.com.
Fill the password for this account.
In the PopServer box write pop3.live.com in Port 995.
Check the box "Always use a secure connection (SSL) when retrieving mail".
If you want, label it, so you know when the emails arrived from hotmail.

That's it, it's all setup and running.
Now you can receive and send messages like if you were on the hotmail page.

Hope you find this usefull.

Create a MS SQL link to MySQL database

To create a MS SQL link to MySQL database, first be sure to install the MySQL ODBC Connector from here: http://dev.mysql.com/downloads/connector/

Create a new System DNS for the MySQL Database on the ODBC Data Source Administrator from the Control Panel | Administrative Tools

To establish a link to the MySQL database from the Microsoft SQL Server Management Studio, open a query window and run the following SQL statement:

EXEC master.dbo.sp_addlinkedserver
@server = N'MYSQL',
@srvproduct=N'MySQL',
@provider=N'MSDASQL',
@provstr=N'DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; DATABASE=; USER=root; PASSWORD=; OPTION=3'

This script will produce a link to the MySQL database through the ODBC connection.

Installing mySql on ubuntu

To install mySql on ubuntu, type the following command on the terminal window

sudo apt-get install mysql-server

To create a new database, type the following mysqladmin command:

mysqladmin create -uroot -p

If you are running PHP you will have to install the php module:

sudo apt-get install php5-mysql

If you want to give Root user logon permissions from any host computer on the network, you will need to update the mysql user table, using the % wildcard. Type the command on the terminal to open the command-line mysql client on the server using the root account.

mysql -uroot -p

to see what the root user host has permissions for, type,

use mysql;
select host, user from user;

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host, user from user;
+-------------+--------------------------+
| host | user |
+-------------+--------------------------+
| 127.0.0.1 | root |
| localhost| |
| localhost| debian-sys-maint |
| localhost| root |
| ubuntu | |
| ubuntu | root |
+-------------+--------------------------+
6 rows in set (0.00 sec)

to update the ubuntu host to use the wildcard, and then issue the command to reload the privilege tables, type,

mysql> update user set host='%' where user='root' and host='ubuntu';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

Now its possible to connect to the server from any other computer on the network, using the root user account. Doing this has some secure issues, beware to set a password for the root user accont.