One of the new features at TechEd SEA this year is Dotnet University that was held on Sept 11-14, 2007. As I mentioned at my 6 things I love about TechEd, this is an Instructor Led Lab (ILL) that focusing on .Net 3.0. It’s all about Windows Workflow, WPF, WCF, and Cardspace. The response from the attendees were overwhelming. They started to queue since 1 hour before every session. All available sessions are fully packed, even though the organizer managed to provide 5 sessions in a day.

 Actually the lab materials were not so deep. It gave an overview about 4 components in .NET 3.0, at level 200 from 500 scale. The public curiosity about this new framework is very high, that’s why the response was terrific. I hope the difficulties level will be improved at the next year since the adoption of .Net 3.0 going to be better.

I delivered the Workflow Foundation session at last class of the 3rd day (17.30 - 19.30). It was also fully packed, so my guess that the attendees prefer to go home was wrong. I did some demo with IF-ELSE branching and Code Activity, using Workflow designer for authoring workflow. Mark Dunn helped me a lot to handle the discussions at the QA session.

Another reason why they were very enthusiast was about the certificate and Dotnet University T-Shirt. They have to attend 4 session (WF, WPF, WCF, CardSpace) completely to be eligible for certificate and T-Shirt.

I want to bring this training to my community in Indonesia. In fact, I did the similar model with ASP.NET camp about 3 years ago. Since the ASP.NET adoption is quite good now, I think it’s the time to put .Net 3.0, SQL Server 2008, and “Orcas” to the picture. Do it with the bazaar model: cheap, large scale audiences, with the volunteer trainer who’s spent their time and share the knowledge for free.

Posted by mca | 3 Comments »

Posted by mca | 1 Comment »

Migration and upgrading are often overlooked by many developers and DBA. They never take care about it until they face the real problem in upgrade and migration. I recalled this matter when I was doing interesting discussion with several senior engineer at Freeport Indonesia on last April 5th, 2007. It was Dondy who called me and asked for an appointment, if I have a time to do technical presentation about this topics for his colleagues. Dondy is working for Freeport now, as he need, as a Software Archictect. Blah :P.

Actually I was on vacation at that time, but I agreed to do that. I’m willing to share anything I know to anybody who keen to learn. As usual, I opened my library and did some reviews before I went to Freeport office. Upgrade and migration is not a daily job, so that’s why every DBA is definitely miss many things about it.

To summarrize the discussion with Mera and Emal who’re responsible for big database at Freeport, these are the things that we need to take attention on migration:

Understand your need. You should choose between upgrade and migration. Upgrade means that you just install SQL2005 on existing SQL2000 machine, close your eyes, and the installation wizard will do everything for you. Hopefully everything is OK, then you will get a new SQL 2005 machine with everything is upgraded.

Upgrade is not the option when you have alot of DTSs, replications, and Analysis Services (AS) packages in your server. DTS and AS do not work well with the upgrade proccess. If this is the case, choose migration instead. Install a new SQL 2005 instance, either on the same machine or on another machine.

Migrate the database engine and database file first. You have some options to do this. Attach/dettach, backup/restore, or using copy database wizard. As far as my experiences, copy database wizard doesn’t work well with big database file. It’s often got the timeout or object copy errors.

Migrate the AS database with AS Migration Wizard. Just type MigrationWizard.exe and follow the path. You need to supply the instance of AS server for both source (SQL 2000) and destination (SQL 2005). Please take note that some AS object such as virtual cube is not supported in SQL 2005. Read the detail in MSDN about that.

Migrate the DTS package to SSIS. Type DTSMigrationWizard.exe in command prompt, and follow the steps. Once you’re connected to SQL 2000 instance, you can choose which DTS package to be migrated. Some objects in old DTS task is not supported, but you still have a chance to make it works in SQL 2005. Make sure you download the SQL Server 2005 Feature Pack, and install SQL 2000 DTS Backward Compatibility before the migration process.

Follow the rule in replication. If you have several servers that involved in replication, then you have to follow this sequence on migration process: upgrade/migrate the distributor first, followed by the publisher, and then subscriber.

We also discussed about the performance impact about placing the database file on several filegroups. Because their database is currently reside on one big filegroup, they need to alter every table they want to move to another filegroup. It’s not and easy job, but it will paid off :). Performance will increase as a result of accessing several IOs in parallel. Also, they can do backup, restore, archiving in an easier manner instead of doing backup and restore on one big file everytime.

It was a nice discussion, and it reminded me on several fundamental aspects of SQL Server. Hope to see you again!

Posted by mca | 1 Comment »

Posted by mca | 3 Comments »

Posted by mca | 11 Comments »

I try something new, giving ASP.NET lessons with practical approach. The attendee are high school teachers that mostly not familiar with programming tasks. I avoid sophisticated programming jargon, and down to earth with practical wizard. They have very high anthusiasm with this ASP.NET 2.0 toys. I hope can bring them the developer soul in 3 days training during August 24-26, 2006.

It’s a pleasure that I can introduce them to free programming toolkit: Visual Studio Express familiy. All hands on lab material already translated to Indonesian. After they go back to their own school, they will teach this material to their students. Then their students will meet in a nice programming competition.

Thanks to some friends from Ilmukomputer.com and ICT Centre that organized this event.

Posted by mca | 1 Comment »

It’s official now. I will speak at 2 sessions on second and third day (6 and 7 Sept for sure). The detail schedule for TechEd SEA 2006 is published here.. I’m very ecxited about this event, when I will speak about ASP.NET and data mining for south east Asia developers and DBA. So many Microsoft folks from Product Group will come and speak, and I hope will have enough time to have chat and discuss with them.

Posted by mca | No Comments »

I’ll be at Atma Jaya University Yogyakarta on next April 29, 2006. It’s a nice opportunity can do speaking in academic community. I will give brief theory of data mining, what data mining is, and the statistical ideas behind each mining model. Then I will move to a practical examples of data mining tasks using SQL Server 2005.
I found that market segmentation, market basket analysis, and project feasibility study with clustering and decision three will be very interesting for academic students. Soon after I come back from this events, the slide and code will available for download

Posted by mca | No Comments »

If you read my post about my speaking schedule, It is rescheduled to April 28 2006. There is an official announcement from government authority that March 31 will be a national holiday. Actually it is not a holiday. Because it will be deducted from our leave allowance. Oh may :(.
See you on Foxpro Community inTouch on April 28!. I will talk about Business Intelligence implementation of SQL2005 within Foxpro 9.0. Also, I will give an exciting demo about next version of Foxpro [codename:Sedna]. It works with .NET 2.0 in more native way than current version :).

Posted by mca | 1 Comment »

It seems BI of SQL2005 become my favourite stuff now. This is very interesting topic, because it does not talk about technical stuff but also delivering business insight in it. I will speak about this topic for Foxpro community next March 31, 2006. Oh Foxpro? Yes!. Mr. Hardian, the leader of FoxId community is person in duty for this seminar. I will explain the basic principles of BI and why we need it, review some mining models and OLAP, and then build presentation interface with Foxpro :). My latest Foxpro experiences is version 3.0, hopefully I do not find difficulties with 9.0. I will explore indepth on OLE DB for Data Mining and DMX query. Just register yourself to connections@netindonesia.net.

Also, I found this site is very interesting for data mining topics beside official MS site.

Posted by mca | 2 Comments »

Hei,
Finally I will speak something I really passionate. It’s SQL Server 2005 new features on Business Intelligence. Specifically, I will explore about Analysis and Reporting Service capability of this new generation of SQL Server.
The current version (SQL 2000) only provide Analysis and Reporting Service plugin for business intelligence foundation. But the new generation integrated every aspect of business intelligence solution. It begins with Extract-Transform-Loading (ETL) with SSIS, data warehouse, data mining, analysis services, and finally presenting data with reporting service or MS Office integration.

Date: September28, 2005
Venue: Auditorium Microsoft Indonesia, BEJ Building-Jakarta.

Sory, registraton seat is already full now :).
The presentation material can be downloaded here.
SQLServer2005BI.zip

Posted by mca | No Comments »

ADO probably is the most widely use by every microsoft based programmer. Based on this, the effort to change the mindset from “old” ADO to ADO.NET is very important for anybody who want to write .NET based application.

I will explore and explain many key difference between both, and how to handle the trouble. It called “ADO.NET for ADO Programmer” session. It’s Visual Basic community gathering that will be conduct at MS Indonesia Auditorium. July 14, 2005 is the day.

Posted by mca | No Comments »

Finally I have a schedule in Yogya, a nice cultural city in Central Java. I will give 2 days workshop on “Rapid Application Development with Microsoft .NET“.
This event organized by Informatics Student Group of Atma Jaya University, in cooperation with IlmuKomputer.Com. I’ll be there on 23-24 June, 2005. More info about this event can be found at their website.

Posted by mca | No Comments »

Category: Speaking Schedule
Following success stories of ASP.NET Training Camp at Jakarta, my friends at Medan arrange the same events there. I will give some sessions for SQL Server and ASP.NET with VB.NET.

Medan, April 22-23, 2005
Venue: AMIKOM-Medan
Organized by Webmedia Training Center and IlmuKomputer.Com.

Posted by mca | No Comments »

I will teach several sessions about
ASP.NET web development with VB.NET. This event organized by IlmuKomputer.Com in
Cooperation with INDC.

• January 29-30, 2005
• February 5-6, 2005
• March 13 and 20, 2005
• April 2-3, 2005

Venue: ICT Center-Kalimalang Jakarta

Posted by mca | No Comments »

Following seminar activities at Jakarta Fair last month, I will give 2 classes on web portal development. This one full day course is conducted for beginner and intermediate user who want to build website quickly. I will show how to install, configure, and make some layouts and block with PostNuke CMS in this class.

Student can choose from 2 schedules as follows :
August 15, 2004; 08:00 am - 05:00 pm
August 28, 2004; 08:00 am - 05:00 pm

Place : Puslatker TKLN Cevest (Depnakertrans)- Bekasi
Please contact training@ilmukomputer.com for registration

Certificate will be released by IlmuKomputer.Com and Puslatker Cevest.

Posted by mca | No Comments »

I spoke on free seminar about Mail Server Publishing with MDaemon and WinRoute as case study. This event held by IlmuKomputer.Com community, in cooperation with Microsoft Indonesia and Harco Mangga Dua. You can download the seminar material here.

Posted by mca | No Comments »

IlmuKomputer.Com will give free IT seminar every Saturday and Sunday at Jakarta Fair. The topics range from networking, hacking, and programming. I will give 2 sessions on mail server publishing and ASP .Net web portal. You can see complete schedule here.

Posted by mca | No Comments »

I will become a main speaker at MDaemon Seminar that will be held at Gramedia Book Store - Depok on March 13, 2004. This event is sposored by Elex Media, DMTEch, and organized by IlmuKomputer.Com community.
Mr Romi, the founder of IlmuKomputer.Com will give his keynote speak at this event.
You can download the seminar presentation here

Posted by mca | No Comments »