Posts in "dev"

SAP BW NW7 Transaction

SAP BW Client – SBIW : SAP Business Information Warehouse IMG (Implementation Guide) – RSA1 : Modelling DW Workbench. This is Main Transaction – SCC4 : Client Administration (BASIS Area) – RSECADMIN : Authorization, Replacing Obselete RSSM – SE10 : Transport Organizer – RSPC : Process Chain Maintenance – SE37 : ABAP Function Modules –… Continue reading

RDC and SQL Server Management Studio 2008 on Vista x86, cannot connect to Windows Server 2008 x64

Problem 1. Remote Desktop Connection (RDC) from Vista x86 as Client to Windows Server 2008 x64 as Server, lost (disconnected) in randomize duration. The error message: Because of an error in data encryption, this session will end. Please try connecting to the remote computer again 2. SQL Server Management Studio 2008  on Vista x86  cannot… Continue reading

OLTP vs OLAP

In many Business Intelligence implementation cases,  there’s a certain difficulty for IT Pro to explain or describe the difference  between OLTP (OnLine Transactional Process) and OLAP (OnLine Analytical Process).  I hope the table below might help a little. source: 360decisions

Saving Your Windows Activation Key

If you are a developer or a Windows tweaker, then formatting and reinstalling Windows operating system might became a regular basis activities. Reinstalling Windows Operating System in repetitive ways on a Hardrive or Virtualization such as VMWare or Virtualbox might resulting on Activation Key Suspension. How we can avoid Activation Key Suspension without calling local… Continue reading

Part 1 : Pengenalan Spatial Data Type di SQL Server 2008

Akhirnya Microsoft SQL Server 2008 mendukung tipe data spatial (keruangan). Sebelum memulai masuk ke bagian teknis ada baiknya kita sedikit berkenalan dahulu dengan data spatial. Data spatial (keruangan) dasarnya di bagi menjadi 2 bagian yaitu jenis data vektor dan satunya lagi jenis data raster. Jenis data vektor adalah “hasil” dari koordinat X,Y, Z untuk menggambarkan… Continue reading

Part 3: Data Loading,Methods dan Sample GEOMETRY di SQL Server 2008

Pada tipe data GEOMETRY (lupakan dahulu GEOGRAPHY, agar tidak bingung), SQL Server 2008 memiliki 3 opsi loading data (membentuk data) : OGC Well Known Text (WKT), Well Known Binary (WKB) dan Geography Markup Language (GML). Sedangkan untuk mempresentasikan data, SQL Server memiliki beberapa Methods sesuai standart OGC dan beberapa yang sifatnya extended. Contoh Syntax WKT:… Continue reading