Switching to Azure MySQL In-App from ClearDB

When I first moved my blog to Azure, there is no MySQL provided by Azure themselves, but from their partner ClearDB. But now since Microsoft already announced that they are providing Azure MySQL In-App server, thought it is still in preview, I’m switching to Azure MySQL In-App, away from ClearDB.

The reason why I’m moving away from ClearDB is not because it is expensive, for my use case it is very affordable, I’m moving away because even with my Azure credit, I still have to pay for the service separately, making me not able to fully utilize my credit.

Read more…

 

How to Transfer Azure Subscription to Another Account

Recently I need to transfer Azure subscription from one of my account to another one. I was using Developer Program Benefit subscription for my blog for quite some times, until recently, I just realized that I have free Azure credit every month from my MSDN, since the Developer Program Benefit subscription is coming to end, so I decided transfer the new Azure subscription to my new account to give it a purpose rather than sitting there.

But my problem is that my Visual Studio Enterprise subscription was with my other Microsoft account, and I don’t want to migrate my blog over to that account, so I decided to just transfer the subscription over.

While I can’t find the link to trigger the transfer, so I log a ticket with the support to ask about how to transfer Azure subscription. The support called me all over the U.S in 2 hours, and help me through the process. It was pretty straight forward, I just need to reply the email sent by the support to both of my email address, to approve the transfer, and it’s done within an hour.

After I got my Visual Studio Enterprise subscription transferred over, it is time for me to switch my resources in Azure to the new subscription, it is quite straight forward.

Read more…

 

SharePoint sp.taxonomy.js Term.getTerms not Working

A while back I worked on a small library with the SharePoint Online’s taxonomy, building the tree structure, and filtering the taxonomy data from SharePoint using JavaScript.

While most of the information can be found at SP.Taxonomy.js namespace in MSDN and many resources online. But I’m struggling with one particular method of Term, according to the MSDN, the function to search for a term under a term will be

SP.Taxonomy.Term.getTerms(termLabel, lcid, defaultLabelOnly, stringMatchOption, resultCollectionSize, trimUnavailable)

This is different than searching for a term under the term store or term set level, which need to use the SP.Taxonomy.LabelMatchInformation for the request. So the code for searching for term in a term will look something like this:

Read more…

 

Migrating WordPress to Azure – Part 2

From previous post, I managed to set up WordPress on Azure, so now is time to move on. To move my existing WordPress over, very obviously I need to do backup, transfer, and setup.

Read more…

 

Migrating WordPress to Azure – Part 1

From my previous post about moving away from HostGator, so I’ll have to move my WordPress as well. Thankfully Microsoft given away some free credits for Azure through Visual Studio Dev Essentials few months back, so I use the opportunity to migrate WordPress from HostGator over to Azure.

At first I thought it will be a troublesome process, as I might need to setup a VM, and install PHP, MySQL myself, but actually it’s very simple to setup WordPress on Azure.

Read more…

 

HostGator Storing Plain Text Password

I’ve been using HostGator for many years to host my blog, I’ve been wanting to migrate to DigitalOcean or other cloud hosting provider, but I haven’t found any motivation to do so previously, and I’ve found it last year (I’m cheap, I waited till it expiring so that I can move away), the main and only motivator is that HostGator keeping my password in plain text in support case.

Last year, I did upgrade my package so that I can support multiple domain, I’ve purchased extra domain so that I can host demo site for my clients, but I never really use it that much, so I raised a ticket to HostGator to request for downgrade my package, and before my ticket go through, I’ll need to key in my login and password for verification purpose.

Read more…

 

Frustration UX at Lego Ideas

UI and UX design wasn’t something that I’m good or decent at, and most of the time when developing some features, UX often come to my mind last, and usually ended up with following some most basic form of structuring the elements on the web page without giving much thought.

Recently I saw an amazing idea for Lego set posted in Lego Ideas page, so I decided to go and support the idea, so that it get make by Lego and I can get one for myself. So by default, when I saw something nice and I wanted to support it, I feel excited, and I immediately click the “Support” button.

Read more…

 

Deploy Laravel on Shared Hosting with Subdomain

To deploy Laravel on shared hosting is not too complicated compared to self hosted environment. This example show how to configure Laravel on shared hosting, on a subdomain. I’m using HostGator here, but it should be just same for other hosting solution.

Read more…

 

404 Page Not Found After Migrate WordPress Database

Recently I lost my local WordPress development environment, so I need to get the copy from my server, I still have WordPress source files, so I just need to FTP back my themes folder and export the whole database in SQL file.

After I get the SQL file, I open the SQL file in text editor and replace all the server domain to my local domain, e.g. changing www.stephensaw.me to stephensaw.local. Then run the SQL on my local database to restore it, it works great, can access to stephensaw.local without problem, can access to admin, the site URL in admin also correct.

But,

Read more…

 

Set Initial View in Xcode 6

I was playing with Xcode 6 and messed up all the views in storyboard, so I’ve decided to delete all the view and drag in new view controller, and I wasn’t able to run the app because it can’t find the initial view. Previously I’ve learned that I can set which view to be initial view by dragging the starting point arrow, but since I dont’ have anything on my storyboard, that arrow was gone, even after I dragged in the new view controller

To get the starting point arrow back:

xcode 6.1 set initial view

  1. Click the view controller on storyboard.
  2. On the Attributes Inspector (on the right pane), under View Controller section, check the Is Initial View Controller box right under the Title box.

That’s it, two steps.

Note to myself: Next time look properly.