SharePoint Club Indonesia: First meet-up

I have been running the SQL Server community quite a while, but [secretly] work on SharePoint in multiple projects. We have quite numbers of SharePoint pro’s here in Jakarta, and also Indonesia in general. Even though the SP practitioner are knowing each others, hangout, and has a very active Whatsapp group, We never had a formal meet-up like SQLServer-Indo.

Hence I initiate a first meeting of SharePoint club. We still do not have a formal name, let the folks decide tomorrow during a meeting. We will be talking about SharePoint Apps in SharePoint 2013. Provider hosted is very interesting, because it allow us to run non .NET app on along with SharePoint. Boike, one of the EBIZ Cipta Technical LEad will be the firs speaker. Let’s keep the ball rolling!

Knowledge sharing – SharePoint Geek.

Topic: Infrastucture Deployment for SharePoint Apps – Provider Hosted.
Speaker: Boike Syahrizal, Technical Team Lead – Ebiz Cipta Solusi

Place: Office88 Lantai 7 – Kota Kasablanka Jakarta (EBIZ Office)
Day/Date: Thursday, 11 Juni 2015
Time: 18.30 – 20.00

Registration via email to

Light dinner is available, first come first served.

June 2014. SQLServer-Indo Meet-Up: Power BI and Azure Survival Guide

We are organizing SQLServer-Indo meet up this month, with a a special guest speaker. Julie Koesmarno is an SQL Server MVP living in Australia. She has presented in various international events such as PASS Summit and SQL Rally in USA. We will setup a Lync conference call so She can do the remote presentation, broadcasted in the room.

As usual, there will be 2 topics presented in the meeting as follow:

Session 1: Azure Survival Guide for [On Premise] SQL Server DBA
By Choirul Amri, Senior Consultant – Microsoft Services
Are you confuse with all Azure buzzwords and new stuff? Struggling to understand affinity groups, availability sets, cloud service, and Vnet? Do You know When to use SQL Server VM instead of SQL Azure Database? What is the catch and trap of configuring Availability Groups in Azure? Join the session and grab the simplified, practical discussion of Azure architecture.

Session 2: Building Your Myth Busting Lab With Power BI
By Julie Koesmarno, SQL Server MVP
Did you know that a large portion of Information Workers’ and Data Analysts’ tasks are akin to “myth busting”? How can Power BI be used for these myth busting tasks? What if myth busting in business applications can be as easily done as few clicks or simply by asking questions in plain English?
Myth busting requires gathering facts, modeling data for repeatable usage and/or testing, exploring data captured, proofing a few theories, coming up with “what-ifs” and making a well informed conclusion. This session will demonstrate how to create an ideal Myth Busting lab for all these aspects all in one suite, Power BI. The demo will show how these activities are played by Information Workers, Data Analysts and IT Administration individually and how Power BI is used for enabling team collaboration. You will learn best practices on delivering self service and mobile Business Intelligence solutions with Power BI, that you can try at home and no safety goggles required!

Speaker Bio
Julie Koesmarno, SQL Server MVP, MCSE Data Platform and Business Intelligence, is a SQL Server and BI consultant at LobsterPot Solutions, with a bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her recent projects include delivering a SQL Server 2012 data warehouse and BI solutions for a leading finance company in the US and Australia. She regularly blogs in her site:

When: Thursday, June 26, 2014
Where: Microsoft Indonesia Auditorium – BEI Building Tower 2 18th Floor Jakarta
Time: 18.45 – 21.00

18.15 – 19.00 Registration
19.00 – 19.45 Session 1: Azure Survival Guide for [On Premise] SQL Server DBA
15 minutes break
20.00 – 21.00 Session 2: Building Your Myth Busting Lab With Power BI
21.00 – 21.15 Wrap up and closing

Please send your name and contact detail to

Light dinner is available on first come first served, so don’t be late.

See You!
Moderator SQLServer-Indo

SQLServer UG: Managing your tempdb

Updated on May 23, 2013

Tempdb is a piece of simple stuff that often overlooked in SQL Server planning. Many DBAs ask for more CPU, RAM, and storage but let alone tempdb stays in drive C. Tempdb can be the big bottleneck in system performance, because it contains many stuff for SQL Server operation.

What’s in tempdb, actually?

Here are the short list of tempdb contents:

  • User objects: your @tablevariable and #tempTable are 2 common example
  • Internal objects: required for internal SQL Server to run, but not directly created by users. Example: worktable in hash join and rebuilding index maintenance
  • Version store: obviously, when snapshot isolation is enable then SQL Server need to keep version store in tempdb

To summarize: when the application query uses alots of temporary operation, tempdb will grow very fast as well. How do we forecast tempdb size? Sad to say but true: there is no exact formula to calculate its size.

Sunil Agarwal from SQL product group has done a series of writing on tempdb monitoring and maintenance. I suggest you to read it for better understanding. His posts collection are here:

I presented this topic for SQL Server Group in MS Office – Jakarta on Febr 28, 2013. Below is the summary of tempdb tuning and optimization:



The complete PPT and sample code are available for download here:

Jakarta–SQL Server 2012 Community Launch

I’m organizing a community event together with SQLServer-Indo, MUGI, and @meisariarvini: The new SQL PM at MS Indonesia. Now We also invite @cfrandall to come in town! The official invite is below, sorry it is in Bahasa Indonesia. You can di BingTranslate it anyway :).

SQL Server 2012, versi terbaru dari SQL Server, telah hadir. Tentunya rekan-rekan community ingin tahu lebih banyak mengenai fasilitas-fasilitas terbaru yang diberikan, seperti bagaimana SQL Server 2012 dapat membantu penerapan Hybrid IT, sebuah kombinasi Cloud Computing dan On Premise Computing. SQL Server 2012 juga membuka peluang aplikasi-aplikasi yang dibangun menggunakan teknologi non-Microsoft untuk menggunakan fasilitas-fasilitas canggih ini, misalnya bagi para pengembang aplikasi berbasis PHP. SQL Server 2012 Community Launch ini ditujukan untuk rekan-rekan Developer dan Profesional TI yang tertarik untuk mengetahui lebih rinci mengenai fasilitas-fasilitas ini. Manfaatkan juga kesempatan untuk bertemu dengan para pembicara untuk berdiskusi secara langsung Lokasi:
Bursa Efek Indonesia, Tower II, Lt. 18,
PT. Microsoft Indonesia,
Microsoft Auditorium.Waktu:
Sabtu, 7 July 2012, 08.30 – 16.00Audience:
Developer and IT Pro 


Profil Pembicara Utama


Chris Randall
Director of Training, SolidQ, North America.

Chris Randall adalah Director untuk training di SolidQ, Amerika Utara. Chris dikenal melalui kompetensinya sebagai public speaking di berbagai teknologi konferensi di level global, spesialis untuk training, courseware workbooks, T-SQL, SQL Server Integration Services, SSAS, dan SSRS. Chris adalah mentor SolidQ yang telah familiar dengan SQL Server sejak tahun 1996. Aktif sebagai trainer, konsultan dan juga sebagai pembicara. Chris telah banyak berkontribusi terhadap konten training yang berhubungan dengan T-SQL, SSIS dan Arsitektur Business Intelligence. Chris sudah banyak mengajar ribuan peserta training dalam kelas dan konferensi kelas dunia, termasuk diantaranya SQL PASS, SQL Saturday dan berbagai konferensi untuk Microsoft Certified Trainers (MCT). Chris memiliki MCT dan MCITP sertifikasi untuk SQL Server 2008 portofolio. Chris juga sebelumnya adalah board member Denver SQL Server User Group, chapter PASS. Selain tugasnya mengajar dan sebagai konsultan, Chris sangat bersemangat untuk hadir di Indonesia dan menyampaikan berbagai peluang yang muncul dengan kehadiran SQL Server 2012.

Ikuti Chris di twitter : @cfrandall dan blog


Berikut adalah topik-topik yang akan dibahas pada SQL Server 2012 Community Launch ini :

Main Session
  09.00 – 09.15

Opening by Manish Chopra
M&O Director, Mirosoft Indonesia

  09.15 – 10.00

Case Study:
Implementing SQL Server 2012 Business Intelligence

  10.00 – 10.45

Note from The Field:
PHP Development with SQL Server
Bastian Harahap
CTO Urbanesia

  10.45 – 12.15

Embracing Big Data with SQL Server 2012
Chris Randall
Director of Training of SolidQ – North America

  12.15 – 13.00 Lunch
Breakout Session
    IT Pro     Developer and BI
  13.00 – 14.00

  Best Practices Running SQL Server 2012
on Hyper-V

  Hotma Roland Pasaribu, MCT
  Mirosoft User Group Indonesia

  Build Modern Windows 8 Metro Apps
and SQL Azure
  Rudy Setyo Purnomo
  CEO Erudeye

  14.00 – 15.00

  AlwaysOn High Availability Group
  in SQL Server 2012

  Kiki Rizki Noviandi
  Microsoft MVP (SQL)

  Powerful Data Visualization with PowerView
  Hendra Eka Putra
  Microsoft MVP (SQL)

  15.00 – 15.15 Break
  15.15 – 16.15

  Monitoring SQL Server 2012 with SCOM
  Faisal Susanto
  Senior Consultant, Microsoft Services

  Performance Tuning in SQL Server 2012
  Choirul Amri
  Senior Consultant, Microsoft Services

  16.15 – 16.30 Closing remaks and door prize




Pendaftaran dapat dilakukan dengan mengirimkan email dengan mencamtumkan informasi berikut: Nama Lengkap, perusahaan tempat bekerja, dan nomor telepon yang dapat dihubungi. Acara ini gratis, namun mengingat keterbatasan kapasitas maka diharapkan rekan-rekan komunitas dapat mencantumkan informasi lengkap untuk keperluan konfirmasi kehadiran. Kami tunggu kehadiran rekan-rekan dengan mendaftar selambat-lambatnya tanggal 3 July.

Anggota komunitas dapat mendaftar ke kontak berikut:

SQL Server User Group Indonesia: Cahyo Listyanto| Email:

Microsoft User Group Indonesia: Abdul| Email:

© 2012 Microsoft Corporation. Panduan Penggunaan | Merek Dagang | Pernyataan Privasi

Jika pesan ini tidak tampil sebagaimana mestinya, silakan lihat versi online
Microsoft menghargai privasi Anda. Mohon membaca Pernyataan Privasi online kami.
Mohon klik disini apabila Anda tidak menginginkan email promosi di kemudian hari dari Microsoft Indonesia.
Pilihan ini tidak akan mempengaruhi aturan langganan newsletter Anda lainnnya ataupun komunikasi
pelayanan wajib yang dianggap sebagai bagian dari pelayanan Microsoft.

Microsoft Indonesia memberikan dukungan terbaik kepada pelanggan dan mitra melalui no. tel +6221 2552 8700, 5155151

P.T. Microsoft Indonesia, Lt. 18 Tower II Indonesia Stock Exchange Building,
Sudirman Central Business District, Jl. Jend. Sudirman Kav. 52-53, Jakarta 12190, Indonesia

MVP for the 3rd Year and Kicking..

I just received an email from Microsoft 3 days ago, stated that I’m awarded as an MVP again. This is my 3rd year renewal, thanks!

Dear Muhammad Amri,

MVP_Horizontal_FullColor Congratulations! We are pleased to present you with the 2008 Microsoft® MVP Award! The MVP Award is our way of saying thank you for promoting the spirit of community and enhancing people’s lives and the industry’s success every day. Your extraordinary efforts in Visual Developer – ASP/ASP.NET technical communities during the past year are greatly appreciated.

There are several notes for this year renewal:

  • I’m awarded as a Singapore MVP, and no longer Indonesian MVP. Since I moved to here for my job, my MVP lead transferred my award status to Singapore.
  • Despite my award that belong to Singapore region, I’m still going to continue my activities for Indonesian communities such as IlmuKomputer.Com and SQL Server Indo. I’m still on my commitment to do writing and participating in online forum.
  • I did several writings for SQLServerCentral last year, and I want to increase it next year. I will participate more on global online portal and Singapore communities.

Hopefully I can do better next year :)

Speaking for SQLUG-ID

I will speak for SQL Server User Group Indonesia monthly meeting on April 30, 2007. Yes, I will be in Jakarta at that time. Meet with many old friends, community enthusiast, most of them are SQL Server and .Net addict :).  

I’m preparing 2 hours presentation about SQL Server Security. This is a big topic, so I limit the scope just for development area. The title should be SQL Server Security: A Developer Perspective. It contains some demos about common developer mistakes when dealing with SQL Server. It’s about something beyond the firewall, yes. When your firewall offers NO protection ;).

I’m proud with the growth of SQLUG-ID. Since I established this group about 2 years ago, It shows tremendous growth. New member come every week, and new posting appear everyday. We have consistent monthly meeting that attended by 20-30 members on average. We even made one MVP (yes Kiki!) that has the root from this group. I hope there will be more new MVP awarded to the active member of this group.

See you at BEJ Building 18th floor, Microsoft Office.

MVP for the 2nd Year

Sunday evening, Singapore time. I received email from MVP team stated that I’m awarded for the second year. Thanks, This award belong to my community: IlmuKomputer.Com, SqlServer-Indo, and INDC.

Dear Muhammad Amri,

Congratulations! We are pleased to present you with the 2007 Microsoft® MVP Award!

The Microsoft MVP Award is our way of saying thank you and to honor and support the significant contributions you make to communities worldwide. As a recipient of Microsoft’s Most Valuable Professional award, you join an elite group of technical community leaders from around the world who foster the free and objective exchange of knowledge by actively sharing your real world expertise with users and Microsoft. Microsoft salutes all MVPs for promoting the spirit of community and enhancing people’s lives and the industry’s success everyday. To learn more about the MVP Program, visit:

Your extraordinary efforts in Visual Developer – ASP/ASP.NET technical communities during the past year are greatly appreciated. The benefits you will enjoy as a recipient of the MVP Award are outlined below.