SQL Server Indonesia User Groups Community

Hari ini iseng-iseng belajar mengenai bagaimana cara menghitung kebutuhan perangkat keras server database di masa mendatang. Dengan menggunakan OS Windows Server dan SQL Server, saya pun mencoba pengetahuan baru dari salah satu buku yang sedang saya baca. Bagi Anda yang menggunakan Windows Server 2003...

Sesuai dengan janji saya kepada pak Julius Fenata, ADE Microsoft (dan bos saya juga) , akhirnya buku ‘Bermain Data dengan SQL Server’ selesai juga. Buku ini merupakan pengenalan ringan terhadap beberapa fitur SQL Server 2005 Express Edition. Tidak begitu tebal dan semoga tidak terlalu rumit untuk dipahami...

Pada hari Sabtu yang lalu (5/12/2009), dilaksanakan Training Internal MUGI Unikom. Saat itu, saya turut hadir dalam acara tersebut untuk memberikan materi mengenai SQL Server. Acara yang bernama Unikom Tech Ready tersebut pada dasarnya menyampaikan 2 buah materi kepada para pesertanya, yaitu tentang...

Saya telah membuat tutorial praktis untuk teman-teman yang masih menggunakan Database Ms. SQL Server 2000 dan Microsoft Visual Foxpro. tutorial tersebut dapat didownload disini Download Tutorial MS. Visual Foxpro dan Sql Server 2000

How to Migrate Non XML Column into XML Column By : Kasim Wirama, MCITP, MCDBA You might store xml data in text or varchar column type in SQL Server 2000 or previous version because it doesn’t support XML data type for storage. Now SQL Server 2005 and SQL Server 2008 support XML data type natively. It...

Detect Database Blocking Issue with SQL Server Dynamic Management View By : Kasim Wirama, MCITP, MCDBA DBA has responsibility to maintain database from backup-restore, data integrity until smooth database daily operation. Most common problem regarding to database operation especially busy database activity...

MERGE Statement in SQL Server 2008 By : Kasim Wirama, MCITP, MCDBA In TSQL area, SQL Server 2008 has some enhancements; one of them is ability to wrap several DML statement into one by MERGE statement. Syntax for MERGE statement is : MERGE <target table> [AS <target table alias>] USING <source...

Viewing Big Data in Excel 2007 By : Kasim Wirama, MCITP, MCDBA SQL Server Integration Services (SSIS) is excellent ETL platform to do export import data from and to heterogeneous data source. In this posting, I would like to give my thought about exporting data into excel file as it is most popular alternatives...

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt...

Concatenate Multi Row Column Value into One Row By : Kasim Wirama, MCDBA, MCITP Sometimes you need concatenate multiple rows into 1 string value separated by delimiter (usually comma). For example to get orderdescription from same customerid like the example below : Declare @order table (orderid int...