After play around with ASP.NET 2.0 during last eight months, I feel confidence with this new framework now. It has many enhanchment both on UI and framework, make my life easier and more productive. Then I start write a book on this topic. Still write in Bahasa Indonesia, and wil be published during next 2 months by major book publisher in Indonesia.

I choose VWD Express instead of full package of heavy duty Visual Studio 2005. Because VWD Express is free, it’s very interesting publish its capability. The most feature I miss from Express are Source Safe and any project collaboration stuffs.
Here is the table of contents of the book:

Cepat dan Mudah
Membuat Web Dinamis
dengan Visual Web Developer 2005 Express

1. Mengenal Visual Web Developer 2005 Express
1.1. Fitur dan Kemampuan VWD Express
1.2. Integrated Development Environment
1.3. Web Site Anda yang Pertama

2. Merencanakan Web Site
2.1. Diagram Pengembangan Web Site
2.2. Membuat Halaman Web
2.3. Membuat Master Pages

3. Bekerja dengan ASP.NET Controls
3.1. Apa itu ASP.NET
3.2. Menggunakan Kontrol ASP.NET
3.3. TextBox
3.4. Label
3.5 GridView
3.6 Calendar
3.7. Image
3.8. Validator

4. Konfigurasi Membership untuk Web Site
4.1. Mengapa menggunakan Membership
4.2. Menyiapkan Database
4.3. Pengaturan File
4.4. Pengunaan web Administration Tool
4.5. Membuat User
4.6. Membuat Role

5. Mengelola Membership dengan ASP.NET
5.1. Mengenal Login Control
5.2. Membuat Formulir Registrasi
5.3. Penggunaan Status Login
5.4. Reset Password
5.5. Pengujian Membership

6. Memudahkan Desain dengan Style
6.1. Mengapa menggunakan CSS
6.2. Membuat CSS
6.3. Menerapkan CSS di Web Site

7. Sistem Navigasiasi
7.1. Penggunaan Navigation Control
7.2. Navigasi dengan SiteMap

8. Membuat Web Site Lebih Personal
8.1. Mengenal Personalization
8.2 Keamanan dan Personalization

9. Meningkatkan Desain dengan Themes
9.1. Konsep dan Penggunaan Themes
9.2. Membebaskan Pengguna Memilih Themes

10. Kursus Singkat SQL Server
10.1. Mengenal Database dan SQL Server
10.2. Mendesain Database
10.3. Relationship antar Tabel
10.4. Perintah SQL
10.5. Mengenal View dan Stored Procedure

11. Mengakses Database dengan GridView
11.1. Menampilkan Data
11.2. Mengedit dan Menghapus Data
11.3. Menampilkan Gambar
11.4. Membuat Formulir Master Detail

12. Lebih Lanjut dengan ASP.NET Controls
12.1. Kontrol FileUpload
12.2. Memutar Banner dengan AddRotator
12.3. Tampilkan Laporan dengan ReportViewer

13. Memisahkan Kode dengan Web Page
13.1. Mengapa Perlu Dipisah?
13.2. Praktek1: Sistem Login dan Membership
13.3. Praktek2: Mengelola Database dengan Gridview

14. Membuat Komponen untuk Website
14.1. Mengapa Membuat Komponen
14.2. Membuat Data Access Layer
14.3. Mengakses DAL dengan GridView

15. Studi Kasus: Membuat Personal Blog

Posted by mca | 5 Comments »

My article on Business Intelligence (BI) is published by SDA Magazine-Indonesia edition. It contains SQL Server 2005 capability as BI platform. MS has do many great enhanchments in BI area with this new product. It’s really kick some other compitors, specially for entry level BI market. Imagine this: with the cheap price of database server (comparing with Oracle and another BI player such as Business Object), your company will have BI solution in the box.

The coolest things I like is integration service or SSIS. It replaced its father DTS, but it is not DTS. MS has rewrite it, make it DTS more powerfull than DTS. It can collect data from various data source such as Oracle, DB2, flat file, XML, or any OLEDB and ODBC compliant data source. Not only importing, I also can put some function, calculation, or validation in the SSIS package. Than the loaded data on the data warehouse is have been summarized, agregated, or validated. If the developer want to do more, they can invoke it with some .Net coding. It really cool and challenge for every developer to do it.

The data warehouse than can be minned with 7 statistics algorithm, make it easier to analize and read the pattern of the data. The presentation layer is reporting service. Built and present on the browser, it is very easy to deploy across the intranet. The good things is user can do the report by themself by adhoc report designer. Also, the pivot tables capability of MS Excell still compatible with this BI platform.

Posted by mca | No Comments »