M. Choirul Amri

dotnet coder wannabe :)
See also: Other Geeks@INDC

Browse by Tags

All Tags » SQL Server (RSS)
My Demo Code and PPT at Teched SEA 2006
My PPT and demo code is available and can be downloaded at my personal site . It's a great opportunity presenting ASP.NET and SQL05 mining model in Teched Kuala Lumpur. Share this post: | | | |
Posted: Sep 07 2006, 01:13 AM by choirul | with no comments
Filed under: ,
Invitation: Fifa WorldCup and SQLServer-Indo Monthly Meeting
Rekans, SQL Server User Group Indonesia mengundang kehadiran Anda dalam monthly meeting edisi bulan Juni 2006. Dalam acara ini Kita juga akan sekaligus nonton bareng partai seru Argentina Vs Serbia Montenegro, Acara dilaksanakan hari Jumat, 16 Juni 2006...
Posted: Jun 14 2006, 11:47 PM by choirul | with 1 comment(s)
Filed under:
Row_NUMBER() and Custom Paging ASP.NET
Hi Guys, Please find my last article in SQLServerCentral.Com today: http://www.sqlservercentral.com/columnists/mcAmri/sql2005forthesql2kdeveloperpart2.asp Happy reading :) Share this post: | | | |
Posted: May 12 2006, 04:29 AM by choirul | with no comments
Filed under: ,
Simple Demo: Smart ASP.NET Application
On last March, there was a discussion about data mining in dotnet@netindonesia mailing lists. I still left 1 question from Pardo that still unanswered. How to access SQL05 mining model from ASP.NET ? Actually it's a simple task, we just need a DMX query...
Posted: May 03 2006, 04:15 AM by choirul | with no comments
Filed under:
Download Materi SQLUG-ID
Sebagaimana diposting oleh Kiki, 21 April minggu lalu komunitas SQL Server User Group Indonesia telah mengadakan monthly meetingnya yang ke-4. Topik bahasannya adalah New Developer Features, terutama berkaitan dengan Transact SQL Enhanchment. Untuk yang...
Posted: Apr 25 2006, 07:24 AM by choirul | with no comments
Filed under:
First Installment at SQLServerCentral
After 2 months of review and processing by their editor, my first article at SQLServerCentral is published. Starting from now, I will write regular monthly column in this site. Hit and read it here . If you're not a member, You will be asked for a simple...
Posted: Mar 30 2006, 07:28 AM by choirul | with no comments
Filed under:
Business Intelligence with SQL Server 2005
My article on BI with SQL2005 has been published by SDA Magazine, Indonesia edition recently. Some of my colleagues ask me for an english version of it. So I rewrite it in a short, english version of this article and publish it here. You can read the...
Posted: Feb 15 2006, 11:30 PM by choirul | with no comments
Filed under:
Second Monthly Meeting of SQLUG-ID
SQL Server User Group Indonesia (SQLUG-ID) will conduct a second meeting this evening. Kiki has spoken at a nice meeting last month, and his presentation can be downloaded from Files section at our mailing list. The topic for today is SQL2005 data mining...
Posted: Feb 15 2006, 10:54 PM by choirul | with no comments
Filed under:
Writing on SQL 2005 BI
Following Risman's move, I also write for SDA Magazine about SQL 2005 Business Intelligence features. Just please buy January issue, :). Huh, I help Mr. Sony and Tom to advertise their magazine :p. Also, if you interested in OLAP features of SQL 2005...
Posted: Jan 06 2006, 06:41 AM by choirul | with 2 comment(s)
Filed under:
SQL 2005 Feature Pack
Buat yang suka main-main deeply dengan SQL Server, baru saja direlease SQL Server 2005 Feature Pack. Release ini berisi berbagai tool yang tidak tersedia dalam release SQL Yukon beberapa minggu lalu. Ada driver koneksi dengan SAP, DB2, Oracle. Juga ada...
Posted: Dec 14 2005, 04:24 AM by choirul | with 2 comment(s)
Filed under:
SQL Server 2005!Secure by default
Setelah beberapa bulan terakhir bekerja dengan SQL 2005 aka Yukon, banyak sekali fitur-fitur baru di bidang security. Salah satunya adalah proteksi terhadap remote connection. Apabila di SQL 2000 kita bisa langsung melancarkan query ke remote SQL Server...
Posted: Nov 24 2005, 03:20 AM by choirul | with no comments
Filed under:
T-SQL still alive
Ada kejadian yang membuat heboh hari ini. Saldo-saldo laporan keuangan mendadak menjadi 2 kali lipat. Kalau betul profit naik 2 kali lipat, boss pasti senang. Tapi kalau penyebabnya “bug” di database server, bisa kehilangan pekerjaan besok...
Posted: May 19 2005, 06:00 AM by choirul | with 2 comment(s)
Filed under:
Extended Stored Procedure Part1
SQL Server menyediakan banyak extended stored procedure, yang merupakan SP builtin di server. Extended SP ini bisa digunakan untuk mengambil berbagai informasi berkenaan dengan kondisi sistem server SQL maupun OS. Berikut beberapa contoh: Melihat Drive...
Posted: Apr 30 2005, 01:53 AM by choirul | with 2 comment(s)
Filed under: