Development | Robby Gunawan Sutanto

DOWNGRADE WORDPRESS LIGHTSAIL AWS

July 22, 2020 rgunawan Comments 0 Comment

Lightsail dari AWS merupakan cara termudah untuk membuat VPS di AWS, berbeda dengan EC2, dimana kita masih harus memilih ukuran storage, memory dan processor yang sesuai dengan kebutuhan kita sendiri. Nah, Lightsail ini sudah ada pricing nya sendiri dan FIXED hardware, perhatikan gambar di bawah ini JIka diperhatikan, bahwa pasangan antara VCPU, memory, storage, data transfer dan harga adalah fixed, jika kita menggunakan EC2, billing tiap bulan akan berbeda-beda sesuai dengan pemakaian kita. Minggu ini saya mencoba utak atik wordpress…

Read More Read More

Setup Bitnami WordPress Multisite sub Direktori pada AWS EC2

July 17, 2020 rgunawan Comments 0 Comment

Sekitar awal bulan Juni 2020 saya mendapatkan kesempatan credit AWS selama 2 tahun dari program AWS Startups (https://aws.amazon.com/startups/), iseng-iseng ikut, ternyata mendapatkan credit yang cukup banyak selama 2 tahun plus premium support selama 1 tahun. Setelah dapat credit, langsung saya coba migrasi aplikasi wordpress dari shared hosting ke AWS, proses instalasi cepat, dan aksesnya juga cepat, tapi yang menjadi kendala lagi adalah, saat saya menggunakan WordPress Multisite sub Direktori terjadi error TOO_MANY_REDIRECT saat mencoba akses ke subdirektori admin console, padahal…

Read More Read More

Trigger AutoNumber di SQL Server

August 19, 2017 rgunawan Comments 0 Comment

Berikut ini trigger buatan saya untuk membuat autonumber, mungkin belum sempurna 100%, tapi paling tidak sudah berjalan dalam 3 tahun terakhir === begin trigger === SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[ti_Quotation] ON [dbo].[Quotation] after insert AS declare @xcounter nvarchar(100), @tahun nvarchar(2), @bulan nvarchar(2), @nomor int; declare @curr_tahun nvarchar(2), @curr_bulan nvarchar(2); declare xcount cursor for select counter,substring(counter,4,2), substring(counter,6,2),CONVERT(INT,substring(counter,8,5)) from AutoGen where table_name = ‘Quotation’; declare curr_monthyear cursor for select replicate(‘0’,2-len(convert(varchar,MONTH(GETDATE()))))+convert(varchar,MONTH(GETDATE())) , substring(convert(varchar,YEAR(getdate())) ,3,2); open xcount; open…

Read More Read More

Saving bandwidth when downloading Visual Studio 2017

March 7, 2017 rgunawan Comments 0 Comment

Today Microsoft release Visual Studio 2017, in the my previous post, you can download offline install of Visual Studio, but for some people, they just need Desktop development only, no need to download all component which is total around 18GB. To saving your bandwidth, download only what you need, use –add <workload_id> options,for example: I just want download Winform Development only, so use vs_community__18950355.1469052767.exe –layout d:\vs2017a –add Microsoft.VisualStudio.Workload.ManagedDesktop It’s only 1.4GB, faster than you download all component which is total…

Read More Read More

Step by step using Microsoft Synchronize SDK for multi client

January 7, 2017 rgunawan Comments 0 Comment

Prepare SQL Server Local Cache Start command prompt Check your localdb version, if you want deploy to 32 bit client, you should use version 12.xx (SQL server 2014 LocalDB) Type sqllocaldb v To check SqlLocalDB Instannce, use sqllocaldb i If you have 2 version, now check your MSSQLLocalDB server version If the version is not version 12.x, you have to create new instance and set version to 12 Now check again your synctestDB instance using correct version (12.0.2000.8) Now you’re…

Read More Read More

[Free Ebook for Today] Cross-platform UI Development with Xamarin.Forms

November 21, 2016 rgunawan Comments 0 Comment

Cross-platform UI Development with Xamarin.Forms Create a fully operating application and deploy it to major mobile platforms using Xamarin.Forms Create standard user interfaces on Windows Mobile, Android, and iOS and then make those interfaces look good with ease Design a full-blown application in very little time with just about the entire code being shared Learn how to access platform-specific features and still have the same core code with this handy guide Download the ebook here

Installing SQL Server on Ubuntu

November 20, 2016 rgunawan Comments 0 Comment

Microsoft just launched SQL Server vNEXT CTP1 for Linux, below is tutorial for installing SQL Server on Ubuntu Prerequisites: Internet connection At least Ubuntu 16.04 64bit Here’s the steps to install SQL Server on Ubuntu Import the public repository GPG keys curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add – Add Microsoft SQL Server Ubuntu repository curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list Run commands below sudo apt-get update sudo apt-get install -y mssql-server Once the installation finish, run the script to install…

Read More Read More

Essential Studio 2016 Volume 4 Release v14.4.0.15

November 19, 2016 rgunawan Comments 0 Comment

Syncfusion just release new version that support Visual Studio 2017 (https://www.syncfusion.com/forums/127486/essential-studio-2016-volume-4-release-v14-4-0-15-is-available-for-download) Direct link for download is here or if you already have community license, just login to your portal and download from there. For Offline documentation for VS 2010/2012/2013/2015/2017 can download here and for VS 2005/2008 can download here

[Direct link] MS SQL Server 2016 Service Pack 1

November 19, 2016 rgunawan Comments 0 Comment

Microsoft just release the first service pack for MS SQL Server, with some improvement as mention here The following table compares the list of features which were only available in Enterprise edition which are now enabled in Standard, Web, Express, and LocalDB editions with SQL Server 2016 SP1. This consistent programmatically surface area allows developers and ISVs to develop and build applications leveraging the following features which can be deployed against any edition of SQL Server installed in the customer…

Read More Read More

Create Visual Studio 2017 RC Offline Installer

November 19, 2016 rgunawan Comments 1 comment

Microsoft just launched new version of Visual Studio 2017 (previously it’s called Visual Studio 15) with the lightweight installer For some users are good since they have enough bandwidth to download it, but for limited bandwidth and needs to install to several computers, it’s the problem. But, don’t worry, there’s a way to download it and you can distribute to another computers without internet connection. Download the installer here Use the following switch or argument below (using two dash) –layout…

Read More Read More