Speaking Schedule

Dotnet University: Rocks!

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.

quedotnetu 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.

scheddotnetu 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.

Speaking for SQLUG-ID

I will speak for SQL Server User Group Indonesia monthly meeting on April 30, 2007. Yes, I will be in Jakarta at that time. Meet with many old friends, community enthusiast, most of them are SQL Server and .Net addict :).  

I’m preparing 2 hours presentation about SQL Server Security. This is a big topic, so I limit the scope just for development area. The title should be SQL Server Security: A Developer Perspective. It contains some demos about common developer mistakes when dealing with SQL Server. It’s about something beyond the firewall, yes. When your firewall offers NO protection ;).

I’m proud with the growth of SQLUG-ID. Since I established this group about 2 years ago, It shows tremendous growth. New member come every week, and new posting appear everyday. We have consistent monthly meeting that attended by 20-30 members on average. We even made one MVP (yes Kiki!) that has the root from this group. I hope there will be more new MVP awarded to the active member of this group.

See you at BEJ Building 18th floor, Microsoft Office.

Nice Discussion on SQL Server Migration

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!

Boost Performance for Large Data Warehouse

When we deal with large data warehouse, it needs specific trick for best performance. I did presentation about this on last Oct 17 for Mini TechReady in Microsoft Singapore. Basically here are some guidances:

  • Take advantage from table partitioning for large fact table.
  • Put clustered index on fact table key, specially for datetime column and do partitioning based on this column.
  • Put non clustered index on non datetime column of fact table, when the query usually using exact criteria.
  • Do the query based on interval criteria, put BETWEEN on WHERE clause when dealing with datetime key, ofcourse after put clustered index on it.

There are another tips related to Analysis Services, hardware, and deal with Integration Services. Download my presentation here: SQL2005LargeDW
Due some users that encountered problem when download entracting the file, I have uploaded again. I have double tested and it works fine.

Choosing The Right Data Mining Algorithm

Imagine we have a business problem, and already have the historical data. We can analyze the data using several mining algorithm inside SQL Server 2005. This is what I’ve talked in my second session at Teched SEA 06 Kuala Lumpur. This was not so technical session, but explain any considerations to decide which mining model should be used for specific business problem. Then do the future prediction using the mining model.

Download sample code here
Download the powerpoint slide here

Practical ASP.NET for High School Teacher

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.

My Schedule at Teched SEA 2006 is Published

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.

Data Mining Chat @Yogya

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 :)

Rescheduled: Speaking for BI SQL2005

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 :).

Again, Business Intelligence on SQL Server 2005

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.