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
Bagi pemilik / pengelola perusahaan kelas menengah ataupun besar tentunya sangat mendambakan kehadiran sistem Enterprise Resources Planning (ERP). Entah sudah mengetahui betul ‘binatang‘ apa itu ERP atau hanya sekedar mendapat presentasi dari team marketing vendor ERP, yang jelas pemilik perusahaan menginginkan adanya suatu sistem otomatisasi proses bisnis yang dapat menampilkan data(baca:laporan) kondisi perusahaan secara cepat,… Continue reading
The common T-SQL script to shrink/truncate log file is using the script below
|
1 2 3 |
USE [foo] GO DBCC SHRINKFILE(foo_log, 1) |
But, if the script runs on SQL Server 2008 instance, it will fail. You still have the same log file size, nothing change (shrink) . In other word you cannot shrink the log file. To solve the issue here’s a work… Continue reading
Minggu ini banyak perubahan besar yang terjadi di internet, mulai dari Bing, yahoo 360 dan Google Wave. 1.Bing Bing adalah mesin pencari baru dari Microsoft yang dipromosikan tidak hanya sebagai sebuah mesin pencari biasa tetapi merupakan suatu Decision Engine. Sepertinya Live dirasa kurang ampuh melawan Google. Will Bing became a Bang, Big Bang ? Give… Continue reading
In my opinion, Sharepoint Portal Server 2003 (SPS 2003) is a superb! Content Management System (CMS) and Collaboration Portal for Intranet. It’s build (runs) on top of Windows Sharepoint Service 2.0 (WSS 2.0). It’s very suitable for Knowledge Management. You can throw almost any kind of document, collaborate and find it again just a second…. Continue reading