Problem: Suddenly, after detached and re-attached a WSS 3.0 content database , the WSS 3.0 search service or Search Server 2008 Express (SS2008E) cannot crawl the portal anymore. So i began to refresh the service and repopulate the search index by performing these steps: But still, nothing happen, the search action resulting an empty page…. Continue reading
Posts in "dev"
How good is SAP ERP, really?
SAP ERP is the flagship ERP solution from the third largest software company in the world. So it has to be good, right? That’s the marketing hype, but does that mean that SAP ERP is good for the particular needs of your organization? Because at the end of the day, that’s what really matters. And… Continue reading
First start with SAP BI …
The SAP resources for Business Intelligence is not much as Microsoft BI does , and i think this link below is a good place to start… SAP NetWeaver (Business Intelligence) Library.
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 2 : Geometry dan Geography di SQL Server 2008
Ada 2 Jenis tipe data baru (spatial), pada SQL server 2008. Kedua jenis data tersebut adalah GEOMETRY dan GEOGRAPHY. 1. Geometry, pada permukaan datar. (Flat Earth Model). presentasi dari X dan Y 2. Geography, pada permukaan yang bulat. (Ellipsoidal Model). presentasi dari Latitude dan Lontitude. Lakukan Instalasi SQL Server 2008 (Tipe apa saja, termasuk Express)… 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
Step 4: Extraction, Loading SPATIAL Data Type
Pada tiga penjelasan sebelumnya, kita sudah berkenalan dengan jenis data spatial di SQL Server 2008. Topik berikunya mengenai load data spatial jenis shapefile(shp) ke dalam table SQL Server 2008. Mengapa saya memilih menyimpannya di SQL Server 2008 dibandingkan dengan penyimpanan format flat file macam shapefile (shp,idx,dbf) ? Berdasar pengalaman, data dalam bentuk tabular lebih mudah… Continue reading
Kill a lock process
The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server:
1 2 3 4 |
--This example shows how to terminate SPID 55. KILL 55 --This example generates a status of the rollback process for the specific spid. KILL 55 WITH STATUSONLY |
–This is the progress report.spid 55: Transaction rollback in progress. Estimated rollback completion: 70% Estimated time left: 15 seconds.