Development Archives - Robby Gunawan Sutanto

Download .NET Framework 2.0 – 4.8

September 10, 2020 rgunawan Comments 0 Comment

Sometimes you download a program from internet or from your software vendor and cannot run because your Windows doesn’t have .net framework runtime, OR you need run your old application but missing .net framework, you can download it here and choose which version you need This is the content of the folder: \dotnetfx.exe\dotnetfx3.exe\dotnetfx35.exe\dotnetfx3_x64.exe\dotNetFx40_Full_x86_x64.exe\list.txt\NetFx64.exe\wic_x86_enu.exe\Windows6.0-KB2506146-x64.msu\Windows6.1-KB2506143-x64.msu\WindowsInstaller-KB893803-v2-x86.exe\4.5\DotNetFramework 451-KB2858728-x86-x64-AllOS-ENU.exe\4.5\DotNetFramework 452-KB2901907-x86-x64-AllOS-ENU.exe\4.5\dotNetFx45_Full_x86_x64.exe\4.5\NDP451-KB2858728-x86-x64-AllOS-ENU.exe\4.5\NDP451-KB2861696-x86-x64-DevPack.exe\4.5\NDP452-KB2901907-x86-x64-AllOS-ENU.exe\4.5\NDP452-KB2901951-x86-x64-DevPack.exe\4.6\NDP46-KB3045557-x86-x64-AllOS-ENU.exe\4.6\NDP46-TargetingPack-KB3045566.exe\4.6\NDP461-DevPack-KB3105179-ENU.exe\4.6\NDP461-KB3102436-x86-x64-AllOS-ENU.exe\4.6\NDP462-DevPack-KB3151934-ENU.exe\4.6\NDP462-KB3120735-x86-x64-AllOS-ENU.exe\4.6\NDP462-KB3151800-x86-x64-AllOS-ENU.exe\4.7\NDP47-DevPack-KB3186612-ENU.exe\4.7\NDP47-KB3186497-x86-x64-AllOS-ENU.exe\4.7\NDP471-DevPack-ENU.exe\4.7\NDP471-KB4033342-x86-x64-AllOS-ENU.exe\4.7\NDP471-KB4033344-Web.exe\4.7\NDP472-DevPack-ENU.exe\4.7\NDP472-KB4054530-x86-x64-AllOS-ENU.exe\4.8\ndp48-devpack-enu.exe\4.8\ndp48-x86-x64-allos-enu.exe and you can download from below link http://gestyy.com/eekrhz

Upgrade Lightsail Instance

July 22, 2020 rgunawan Comments 0 Comment

Untuk melakukan upgrade lebih mudah dibandingkan dengan downgrade, berikut ini langkah-langkahnya: Stop intance yang aktif buat snapshot sambil menunggu proses snapshot, detach dulu instance yang lama dari ip public setelah snapshot terbentuk, klik pada tanda titik 3 di sebelah kanan snaphot Pilih create new instance pilih instance yang lebih tinggi setelah terbentuk, attach instance yang baru ke ip public dan uji coba via browser Apakah sudah selesai? Masih belum, masih ada yang harus di kerjakan, yaitu: Jika mempunyai StaticIP, maka detach…

Read More Read More

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