Character Setup for Transfer data from MySql to SQL Server

WHY!!!! my language it was an alien after I have transfer data from MySql database to SQL server? Yeah! I know that many developer was upset when it was not as we wished, I have set tis-620 at my MySql database and I also did the same on SQL server but WHY!?. OKEY! please clam down and I have a solution for you, Just do it carefully by step by step then I am guarantee that you will get the answer and I am sure for an other language it will be the same, you just need to change character as your needs.

STEP-1
Go to control panel on the window menus

STEP-2
Find "Region" menu but if you do not see please change your view to small icon

STEP-3
Then you will see the popup window as photo below then click on "Administrative" tab

STEP-4
Click on "Change System Locale...", Exactly the default will be "English" if you installed window and choose the language as English or depend on your choose, You have to selected language as you want (In image I have to selected Thai)

STEP-5

You almost be done! ^_^ just click "Ok, Ok and Ok" then Restart window but my Warning is please save all jobs before you have to restart, I confirmed that your Thai language or any language will be fine after you have transfer data from MySql to SQL Server if you miss that mean you were wrong XOXO ^__^ and please set ODBC to tis620 or character code as you needs too. Click here for setup ODBC Character

STEP-6
For more add-on, If you have to transfer data from MySql to SQL server by SSIS you have to set conversion data, Please see in next stop by click on here

Read More

Config ODBC for connect to MySql

Yo! I know that it not easy to the beginner to try to configuration ODBC to connection to MySql and for be sure and I will never forget all knowledge as I know I'll tell you step by step, Hope all will help you Okey! let's go to step one.

STEP-1.
You have to download ODBC for window (If your server is Window) and download the version as your server was support, for more information you can see here "Download ODBC Driver" Oh! and please install in computer that you want to connect to an other server. (You have to register on site for free download)

STEP-2

After you have completed installed ODBC driver on your server then go to "Data Sources (ODBC 32-bit)"

STEP-3

Click on "System DSN" tab, you will see the popup (If you do not see that mean, you did wrong! ^_^ XOXO) Select the ODBC version as you have installed (For me I choose ODBC version 3.51)

STEP-4
Then you will see the popup window for you to fill information for connecting, then please fill all data as requested
- Data Source Name (put the name you as your idea but this job it quite hard for programmer to thinking the name and me too ^_^)
- Put IP address for server you want to connect to or if you want to connect localhost, just put this name in to TCP/Server
- Port, 3306 it was the default, you can change to an other port as your database server configuration
- User, It's your database username
- Password, It's your database password
- Click on "Test" if you fill all done to make sure for connection
- Oh! and one more thing, this is very important for me ^_^ because I am in Thailand and we use Thai language, do not forget to set Character Set by click at "Details>>" 


STEP-5
Character Set up, Click on Details then you will see many tabs appears, Do not hesitated to put character code as your requested for me I choose "tis620", WHY!? because if I forget and after I transfer data from MySql to SQL, I can not read Thai text, It will be an alien language ^_^ then PLEASE DO NOT MISS and if you have already set to tis620 it still not work, you have to config your window language in this step here

Read More

Business Intelligence

Business Intelligence (BI) What is it? Let's me tell you about my way as I know and understand.

BI it's just the concept to collection all data as you have on hand (some data it's in excel format, database in any platform, some are juck data) then we need to collect all data to clean, move, transfer, adapt or any verbs as you need to do to make your all data are quality for serve to your manager or CEO or any concern person as them requested. You can see my image (I have tried to drawing ^_^ look pretty!?)

And we have many tools to create the cube or report for CEO such as targit (In my experience said, YES! easy to create the report but toooooooo slow if you have big data more then 100,000 records to selection)

Any one else? Yes SQL server they have solution but you need to install Analysis Services Database, you have to selected all package in the first time when you have to install server (Click all if your server no have limited for recourse ^_^)
This is very simple to create a report, do not need more creative for design a wonderful report, but if your CEO or manage would like to add some photo, graphic, or color full, I'm not sure that this tool will be your best answer but for quality, I am guarantee.

And an other one as I know now it's IBM, it's name Cognos TM1 Performance, I have seen that the complicated things is, You can not query data and check it very easy as you use database, TM1 keep all data like a point of cube, That the weak point of TM1, You have to find an other technique to check data, For this detail I am still not sure google can help you ^_^ , Happy and Enjoin

If you have any idea and would like to share please send mail to me here aiauncha@gmail.com
Thank you for sharing

Read More

Simple Store Procedure Code Example

USE [DataBaseNameUsing]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[sp_TEST] -- Stored Procedure name
AS
BEGIN
set nocount on

-- ================ Declare parameter for query data from table source
declare @MonthforDelete decimal(18, 0)
 declare @YearforDelete nvarchar(10)
declare @ID nvarchar(10)
declare table_tmp cursor for

-- ================ Select data from table souce by unique year,month and ID
SELECT DISTINCT field_month,field_year,ID

FROM DataBaseNameSource..Table_Source

open table_tmp

-- ================ Save all select data as condition into table temp
fetch next from table_tmp
into @MonthforDelete,@YearforDelete,@ID

-- ================ Delete data from destinatin table
while @@fetch_status = 0
begin
DELETE FROM DataBaseNameDestination..Table_DataFact
WHERE ID = @ID
AND field_month = @MonthforDelete
AND field_year = @YearforDelete
fetch next from table_tmp
into @MonthforDelete,@YearforDelete,@ID
end

close table_tmp

deallocate table_tmp
END

Read More

Good Word to improve myself

Long distant we will get the aim by keep moving forward.

Not thing can make you feel suffering, It's depend on your point of view about that experience.

Every morning and before you sleep, You have to say thank you for every things to came to your life, even it will was good or bad ^_^.

Do the thing as you like, It will become the right one.

How do you know it's right if you never did wrong first!

Forget the pass then start the new ^_^.

Good leader you have to prove yourself by how much you make employ respect you with love, it's not to make people under you as command.

Keep moving forward, do not look back, it's just your a part of your life.

Read More