Arsip

Archive for Juli, 2006

Membuat Shell Context Menu Untuk Me-Register/UnRegister ActiveX Object

Jika Anda sudah selesai membuat suatu ActiveX object baik itu berupa DLL atau OCX, maka pastilah Anda harus me-register-kannya ke Windows agar object Anda bisa dikenali. Ini bisa dicapai dengan mengetikkan:regsvr32.exe <namafile_activex_object_anda> Baca selanjutnya…

Kategori:Computer

Tips MySQL: Mengganti Nama Tabel pada MySQL

Juli 20, 2006 2 komentar

Tips sederhana kali ini adalah cara mengganti nama tabel pada database MySQL Anda. Semisal Anda saat ini sudah memiliki tabel dengan nama ‘karyawan’ dan ingin menggantinya dengan nama ’employee’, maka Anda cukup ketikkan saja perintah berikut ini. Baca selanjutnya…

Kategori:Computer

Running Out of Space

Juli 14, 2006 4 komentar

Ever notice that there are so many bad things that can happen to a DBA? One of the many errors that will make the blood of DBA run cold is ‘insufficient space’. In this article I’d like to talk about some basic strategies both for avoiding it as well as dealing with it if…or when, it happens. Baca selanjutnya…

Kategori:Computer

SQL Server Full Text Search Language Features, Part 2

Juli 14, 2006 3 komentar

Query-time behavior

This is the second of a two-part article that explores the language features of SQL Full-text Search (SQL FTS), an component of SQL Server 7 and above that allows fast and efficient querying of large amounts of unstructured textual data. Part I dealt with index time language options, covering how words or tokens are broken from the text stream emitted from the iFilters and stored in the index. Baca selanjutnya…

Kategori:Computer

SQL Server Full Text Search Language Features

Juli 14, 2006 1 komentar

SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient querying when you have large amounts of unstructured data. This is the first of a two-part article that explores the full-text language features that ship with SQL Server versions 7, 2000, and 2005, with particular focus on the new language features in SQL 2005. Baca selanjutnya…

Kategori:Computer

Temp Tables in SQL Server

Introduction

Temporary tables are always a great help for a developer. In the early days when I used Access I used to create tables that I treated as temporary and then delete them whenever I finished my task. Using SQL Server this is much simpler. Or is it? Baca selanjutnya…

Kategori:Computer

Speed Up Firefox

Bagi temen-temen yang sering baca media seputar info teknologi pasti deh udah pernah denger yang ini. Dulu di media cetak pernah diulas. Di internet juga kalo misalnya buka google, terus iseng-iseng masukkan frase “speed up firefox” (tanpa tanda kutip nggak masalah) keluar deh hasilnya. Tapi khusus buat yang masih ketinggalan informasi, saya masukkan deh infonya di sini. Baca selanjutnya…

Kategori:Computer