Script Task pada SSIS SQL Server 2008 sudah dapat dicoding dengan C#

Bagi pencinta SSIS SQL Server, sekarang para programmer C# dapat melakukan coding dengan bahasa C# pada Script Task. Sebelumnya SSIS SQL Server 2005, script task hanya dapat menggunakan bahasa VB.NET. Gw sendiri punya pengalaman buat script task ini pada SSIS SQL Server 2005 dengan VB.NET pada suatu project di bangkok. Kalaupun mau menggunakan C# maka kita membungkusnya dalam DLL yang kemudian digunakan VB.NET pada script task SSIS SQL Server 2005. Sekarang back to your mother language

Share this post: | | | |

Changing Database Design Prevention of SQL Server 2008 Features in Development Environment looks “bad idea”

Bagi rekan-rekan yang sering bekerja di SQL Server 2005 dan kemudian bekerja di SQL Server 2008. Pada suatu saat anda ingin mengubah tabel pada suatu database di SQL Server 2008 misalkan ada penambahan field baru pada tabel Customer. Setelah melakukan perubahan field kemudian anda simpan perubahan tabel Customer dan upps…ada warning seperti dibawah ini

Apa-apaan ini?!!! berulang-ulang anda simpan perubahan field ini akan selalu muncul kotak dialog peringantan tersebut.

Well, ini fitur baru pada SQL Server 2008. Secara default SQL Server 2008 mempertahankan database design supaya tidak menganggu database yang sedang berjalan so kalau merubah harus melakukan drop table dan kemudian cretae table serta update database relationship (kalau ada)..…oic, oic oic , tapi what’s tunggu dulu!! kalau untuk SQL Server 2008 yang berjalan di production memang fitur ini sangat membantu agar konsisten database design tetap terjaga tapi kalau di development? seperti kita ketahui, di development perubahan database akan sering terjadi apalagi yang suka plin-plan project nya . So fitur ini sangat tidak cocok sekali !!!….

Mematikan Fitur Ini

Microsoft team bukan orang bodoh yang sembarang membuat fitur yang beginian dan mereka sadar fitur bisa menjadi polemik kedepannya. Tidak suka dengan fitur ini? Microsoft memberikan opsi untuk mematikan, caranya? klik menu Tools->Options sehingga akan muncul kotak dialog Options. Klik bagian Designers->Table and Database Designers seperti dibawah ini

Lakukan tidak mencentangnya (unchecked) pada Prevent saving changed that require table re-creation. Setelah selesai klik tombol OK. Nah, setelah itu lakukan penyimpanan table dan boom, sekarang bisa…

Kalau udah begini…siap deh menghadapi project plin-plan dengan perubahan database design nya

Share this post: | | | |

Indihiang tool was certified by Softpedia

Thanks for Softpedia Labs (www.SoftPedia.com) team (special thanks to Radu Bogdan) that has certified my open source project, Indihiang tool. Information about Indihiang tool on Softpedia can be found on http://www.softpedia.com/get/Internet/Servers/Server-Tools/Indihiang.shtml 

Detail Note: http://www.softpedia.com/progClean/Indihiang-Clean-132815.html

Indihiang 0.1 Alpha - SOFTPEDIA "100% FREE" AWARD

This product was last tested in the Softpedia Labs on 6th of July 2009 by Radu Bogdan
Softpedia guarantees that Indihiang 0.1 Alpha is 100% Free, which means it does not contain any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.
This software product was tested thoroughly and was found absolutely clean; therefore, it can be installed with no concern by any computer user. However, it should be noted that this product will be retested periodically and the award may be withdrawn, so you should check back occasionally and pay attention to the date of testing shown above.

Share this post: | | | |

Pemrograman Game Dengan XNA Framework 3.1 dengan Target Windows dan Zune

Semenjak dapat Zune tahun lalu sebagai hadiah Microsoft MVP, gw pikir awalnya bosen masalahnya Zune cuman buat dengerin musik atau nonton video. Malah ada teman, Zune player di isi dengan film biru..so semua serba biru dan muka yang nonton jadi biru alias mupeng .

November 2008, Microsoft akhirnya release XNA Framework 3.1 yang memungkinkan untuk membuat aplikasi game pada Zune Device. XNA Framework 3.1 sudah terintergasi dengan Visual Studio 2008 sehingga kita dapat melihat template project seperti dibawah

Pada Zune device yang kita miliki harus di upgrade ke Zune 3.1 yang dapat dilakukan melalui Zune Software yang dapat didownload gratis di Website Zune. Kalau sukses maka pada Zune software akan muncul seperti dibawah ini.

Setelah kita membuat aplikasi game dengan target Zune maka untuk deployment ke Zune Device cukup mudah. Hanya dengan menghubungkan Zune device ke notebook melalui USB cable dan mendaftarkan ke XNA Game Studio Device Center yang ada pada Visual Studio 2008. Jangan lupa memilih Zune Device sehingga akan nanti akan muncul Device anda. Kalau sukses maka Zune kita akan muncul ke Visual Studio seperti dibawah ini

Akhirnya Zune kita bisa dimanfaatkan dengan coding game atau download game untuk maen game di Zune device. Lumayan sembari naik atau tunggu KRL kan bisa maen game dengan Zune .

Artikel Tentang Pemrograman Zune Di Majalah PC Media

Minggu lalu, gw menyelesaikan dua artikel mengenai pemrograman game berbasis XNA Framework yang gw submit ke majalah PC Media. Dua artikel itu adalah

• Membuat Aplikasi Game dengan XNA Game Studio
• Membuat Aplikasi Game Pada Zune dengan XNA

So selamat menikmati….

Share this post: | | | |

Release Indihiang 0.2.1 – Improvement on Parallel Computing Feature

Thanks for using Indihiang to analyze IIS log files or remote IIS. I try to improve Indihiang application such as features, performance, usability, etc.

Today I uploaded updated Indihiang application version 0.2.1. What’s the improvement in Indihiang 0.2.1? As you know, Indihiang 0.2 used parallel computing feature to analyze log IIS simultaneously. I improved parallel algorithm in Indihiang. Here are the improved codes:

   1: try

   2: {

   3:     var resultData = new Future<List<BaseLogAnalyzeFeature>>[listFiles.Count];

   4:     _mainTask = Task.Create(

   5:             delegate

   6:             {

   7:                 Parallel.For(0, listFiles.Count, index =>

   8:                     {

   9:                         List<BaseLogAnalyzeFeature> features = IndihiangHelper.GenerateParallelFeatures(LogFileFormat);

  10:                         resultData[index] = Future.Create(

  11:                                () => ParseLogFile(features, listFiles[index])

  12:                             );

  13:                         resultData[index].Wait(-1);

  14:                     });

  15:  

  16:             },

  17:             _taskManager.Value,

  18:             TaskCreationOptions.None

  19:          );

  20:  

  21:     _mainTask.Wait(-1);

  22:     for (int i = 0; i < resultData.Length; i++)

  23:     {

  24:         List<BaseLogAnalyzeFeature> items = resultData.Value;

  25:         items.ForEach(delegate(BaseLogAnalyzeFeature item)

  26:         {

  27:             for (int j = 0; j < _paralleFeatures.Count; j++)

  28:                 if (_paralleFeatures[j].FeatureName == item.FeatureName)

  29:                     _paralleFeatures[j].SynchData(item.Items);

  30:         });

  31:  

  32:         items.Clear();

  33:         resultData.Dispose();

  34:     }

  35:     Thread.Sleep(100);

  36:  

  37: }

_mainTask object hold a task all analyzing computation. In this task, I created parallel task using Future<T> object to handle analyzing for a log file. I also passed TaskManager object in _mainTask object to optimize processor usage. I also implemented Lazy initialization for TaskManager object, here is the illustration code as below:

   1: _taskManager = new LazyInit<TaskManager>(() => new TaskManager(

   2:                    new TaskManagerPolicy(1, Environment.ProcessorCount)),

   3:                    LazyInitMode.AllowMultipleExecution);

After all tasks created by Future<T> object, I tried to wait and make sure all tasks completed. After completed, Indihiang consolidated all log IIS files and rendered data on GUI.

What’s the Next?

Now, you download Indihiang 0.2.1 for x86 and x64 platforms. You also can download the latest source code on http://indihiang.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=29480 

If you have any feedback please report on Indihiang portal http://www.codeplex.com/indihiang

Share this post: | | | |

Introduce my research project - Machine Learning Framework (MLF)

I would like to introduce my another open source project, Machine Learning Framework (MLF). Machine Learning Framework (MLF) is a library based on .NET Framework for machine learning implementation. This library consists of collection of machine learning algorithms such as Bayesian, Neural Network, SOM, Genetic Algorithm, SVM, and etc.

The objectives of this project are to help researchers, students, and programmers to build application based on Machine Learning using .NET platform easily. This is a part of my research project activity. On the future, I will integrate MLF and Indihiang projects so Indihiang tool can be used to do data mining analyzing

Machine Learning Framework (MLF) project is hosted on Codeplex portal, http://mlf.codeplex.com

Share this post: | | | |

How to Analyze Remote IIS 7 Log using Indihiang 0.2

When you use Indihiang 0.2 to analyze IIS log via IIS Remote on IIS7 on Windows Server 2008, sometimes you get error although you have filled administrator level. This problem occurs because Indihiang 0.2 uses WMI to get all log files on remote IIS so IIS7 should be configured for WMI compatibility using adding features on Server Management as below

Share this post: | | | |

Release Indihiang 0.2

Finally I can deliver Indihiang 0.2 today. You can download Indihiang 0.2 on CodePlex portal http://www.codeplex.com/indihiang

There are many new features and enhancement from previous version. What’s new? New features are

• Hits analyzing for month
• Bandwidth analyzing
• Processing Request
• IIS log files consolidation
• IIS log files analyzing for Remote IIS
• Parallel processing using Microsoft Parallel Extensions to the .NET Framework 3.5 June 2008

I also improve the previous version. There are some enhancement features on Indihiang 0.2.

• General analyzing
• Hits analyzing enhancement
• Processing monitoring
• GUI and its functionalities enhancement

I try to write the detail of these. Please keep on my blog.

Share this post: | | | |