Archive for January, 2010

Older Entries

How to Update Select From the Same Table in MySQL

In: MySQL

30 Jan 2010

MySQL doesn’t allow referring to a table that’s targeted for update in a FROM clause, which can be frustrating. There’s a better way than creating endless temporary tables, though. This article explains how to update a table while selecting from it in a subquery. Recently I am assigned to update a bunch of records in [...]

Akayama Rina 秋山莉奈 Photoshoot

In: Photography

28 Jan 2010

Been busy moving my hosting package, so haven’t make any update to my blog lately. I will try to create more post these few days since starting next weekend I will be flying away for vacation for nearly 2 weeks. Enjoy this nice photo shoot from Akayama Rina. Bookmark It Hide Sites $$(‘div.d1469′).each( function(e) { [...]

Copy Table and Data Between 2 Database

In: Oracle

15 Jan 2010

Recently I need to do some task base on the Production data and I don’t want any accident happen to my production database so I decided to copy the production tables I need over to the UAT database and do the ETL. I got 2 option to achieve this: Create dblink to another database and [...]

High-Availability Storage With GlusterFS On Ubuntu 9.10 – Automatic File Replication (Mirror) Across Two Storage Servers

In: Ubuntu or Linux

13 Jan 2010

This tutorial shows how to set up a high-availability storage with two storage servers (Ubuntu 9.10) that use GlusterFS. Each storage server will be a mirror of the other storage server, and files will be replicated automatically across both storage servers. The client system (Ubuntu 9.10 as well) will be able to access the storage [...]

How To Set Up Database Replication In MySQL On Ubuntu 9.10

In: MySQL|Ubuntu or Linux

13 Jan 2010

This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases [...]

God Mode in Windows 7

In: Microsoft Windows

8 Jan 2010

Don’t be take away by the name “God Mode” and get overly excited. The hidden “God Mode” is actually a control panel that lets users access all of the operating system control panel option within single folder. This can be done by creating a new folder in Windows 7 and rename it to: GodMode.{ED7BA470-8E54-465E-825C-99712043E01C} After [...]

Select Comma Separated Values (CSV) From MSSQL Table

In: MS SQL

7 Jan 2010

Creating Comma Separated Values (CSV) from Table Column is a very common task and we sometimes do it to export to excel for further massaging the data. Below is the script used on Microsoft SQL Server: USE AdventureWorks GO — Check Table Column SELECT [Name] FROM HumanResources.Shift GO — Get CSV values SELECT STUFF( (SELECT [...]


Older Entries

About this blog

This is a place I create just for fun and to write down some experience and notes for myself. So feel free to enjoy and drop any comments you have. I had been employed as Programmer, System Analysts, System Administrator, DBA and Project Manager. I will share some of my case study here as well. Enjoy!

Categories

Archives

  • kc: great.. it solved my issue ... thnks a lot... :) [...]
  • mike: thank you so much. it helped solve my error. :) [...]
  • Wyatt Richardson: I'm pretty much impressed with the stability of Windows 7. It is better than windows Vista which hog [...]
  • Ellie Hughes: Playstation is the best gaming console that i have owned. Me and my brother are addicted in playing [...]
  • Eric Patterson: I have tried using Chrome OS in one of my desktop PC's, the overall performance is above average to [...]

 

Calendar

January 2010
M T W T F S S
« Dec   Feb »
 123
45678910
11121314151617
18192021222324
25262728293031

Copyright © 2007 - Vpire Blog - is proudly powered by WordPress | Log in