I spoke on SQL Server User Group Indonesia
monthly meeting last month, discussed about a developer perspectives of SQL Server Security. I covered most of the session with some SQL Injection techniques, completed with real sample code in web application.
I started with the awareness that network administrator is not the only person who’s responsible for computer security. Networking guys are only responsible at the network (firewall) and host (OS) level. At the application level, is a developer responsiblity for the software security. Ensure that no single line of code contains a hole, something that can be utilized by an attacker to compromise the system.
Continue Reading May 13th, 2007
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.
Continue Reading October 19th, 2006
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
September 8th, 2006
I will speak today, the topic is “Smart ASP.NET Web Apps with SQL2005 Mining Model. This session mainly focus on OLE DB for DM and DMX query stuff. The sample code is about prediction of potential buyer based on their demographic data. It uses Microsoft Decision Trees algorithm in plain DMX query inside C# code.
Download sample code here
Download the powerpoint slide here
September 6th, 2006
I just come back from Yogyakarta, giving a 2 hours chat on Data Mining at Atma Jaya University. Last weekend was very busy, I presented about SQL Server 2005 BI for Foxpro developer in MS Office on Friday (April 28), and early in the Saturday morning on April 29 I went to Yogya with the first flight schedule.
The presentation material and demo code is rather same for both events, but I added some Foxpro snipet code for Friday material. I talked more on practical implementation of OLAP and data mining for Atma Jaya student, and my fellow Zeddy gave more attention on academic approach of mining model. I made some coding enhanchments for Saturday chat, so It looks more fancy and real. The demo code was about “smart” ASP.NET application using Association Rule mining algorithm of SQL2005.
Continue Reading May 1st, 2006