Archive for the “dev” category

Keamanan Aplikasi Website

by diditho on March 11, 2013

Memahami, apalagi memulai diskusi mengenai kemanan aplikasi di internet (website) terkadang membutuhkan ‘entry point’ yang tepat. Hal ini dikarenakan banyaknya aspek yang harus dibahas, ada tentang sistem operasi, aplikasi, port , dan ribuan hal lainnya. Beberapa bulan lalu, saya mendapat (…)

Read the rest of this entry »

SQL Server 2012 : Manageability for Administrator

by diditho on November 1, 2012

Beberapa bulan lalu, pada acara SQL Server Meeting di kantor Microsoft Indonesia, saya mangajukan diri untuk membuat salah satu bab ebook ‘What’s New di SQL Server 2012. Saya mendapat jatah membuat materi Manageablity for Administrator Saya sudah menyelesaikan materi tersebut (…)

Read the rest of this entry »

Microsoft Analysis Service (OLAP) Front-End

by diditho on April 9, 2012

Option for MSSQL Analysis Service (OLAP) Front-End 1.Microsoft SQL Reporting Service SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. (…)

Read the rest of this entry »

SAP BW : Prepare Large ETL (DSO and Cube)

by diditho on December 14, 2011

Here’s are steps that need to execute before start executing Data Transformation 1. Delete Data and SID On Cube (Destination) 2.Delete Index (Destination) 3.Delete Aggregate (Destination) Related Posts:What is the secret recepies for making a good and reliable ERP system (…)

Read the rest of this entry »

SSAS: Mastering MDX on SSAS

by diditho on July 21, 2011

The Next step on using SQL Server Analysis Service (SSAS) as Business Intelligence (BI) / Warehouse (BW) platform is to master Multi Dimensional Expression (MDX), it’s like Query on T-SQL. Question, how to master MDX script language on SSAS (SQL (…)

Read the rest of this entry »