Ok, we got a disaster in SAP BW NW 7 machine, part of the physical memory just suddenly break! Yeah! and The ‘fun’ part , the malfunction occures on heavy extraction of data from SAP R3 / IS-M Production Server. It break on pararel processing , although we can identify the malfunction Object, the team… Continue reading
If you’re using Apache web server, this is the first and basic step to protect your web application using .htaccess file. create and put the .htaccess file in root folder of your application and write the code; # Protect the files that important and contain sensitive information such as database username and password Order allow,deny… Continue reading
Right now, I’m using various developer tools to manage application code. Before this month, developer tools such as Visual Studio, SQL Server Management Studio, HeidiSQL and Notepad++ are the daily tools for developing application. Well, i think the application world is evolving in rapid ways, the horizon of an application development suddenly becoming more vast… Continue reading
Dear Support, Q: Today all my wordpress (wp) installation (parent and add-on domain) (foo.com; foo1.org, foo3.or.id) can’t perform simple wp feature “add new plugin”. It shows this error message: An unexpected error occurred. Something may be wrong with WordPress.org or this server configuration. If you continue to have problems, please try the i try to… Continue reading
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 pada bulan Februari 2012. Ketika memulai membuat materi , SQL Server 2012 masih pada tahap… Continue reading
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. It is administered via a web interface 2.Microsoft PerformancePoint Service PerformancePoint Services in Microsoft SharePoint… Continue reading
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)
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 Server Analysis Service) ? or where to start ? Firts thing first, you have to… Continue reading
A linked server configuration enables Microsoft SQL Server (MSSQL) to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages: Remote server access ; The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise ; and The ability to address diverse data… Continue reading
Arrghh!! need to manage an old version of MySQL database. Turnout the vary of MySQL version is a serious problem to lot of free MySQL Graphic User Interface (GUI). Most of it, cannot manage old version of MySQL database, only the new one *DOH!!*. Finally found… The only free GUI that work best and flawlessly… Continue reading